WassUp Forums

• Forums
• WassUp

1. 

   sjespers
   Member

   Hi guys,
   I upgraded to WP2.5 yesterday and since then I have these errors on top of my Wassup visitor details page (just above what is supposed to be the graph):
   Warning: Invalid argument supplied for foreach() in /home/webkitchen-wp/public_html/wp-content/plugins/wassup/lib/main.php on line 844

   Warning: Wrong parameter count for max() in /home/webkitchen-wp/public_html/wp-content/plugins/wassup/lib/main.php on line 675

   Warning: Wrong parameter count for max() in /home/webkitchen-wp/public_html/wp-content/plugins/wassup/lib/main.php on line 677

   Any thoughts? I am on the latest Wassup. Just tried reinstalling Wassup but that didn't help.

   Thanks,
   Serge

   Posted 4 years ago #
2. 

   Michele
   Key Master

   Hi Serge,
   please could you try the new beta version we are working on? It is the 1.5pre version and you can download it by following this link: http://trac.wpwp.org/changeset/124/trunk?old_path=%2F&format=zip

   It should fix the problem and add some new features, we need some test before releasing it so if you could help us it would be great.
   Thank you very much

   Michele - WassUp Project

   Posted 4 years ago #
3. 

   sjespers
   Member

   Installed the beta. That solves the errors but it's not showing the graph.

   Posted 4 years ago #
4. 

   Michele
   Key Master

   If you are able to edit php file please follow these step to enable some debug to understand what it's happening:

   - edit the file in the wassup directory: lib/main.php
   - on line 852 please comment off the following lines:

   /* Debug
   $q = "SELECT COUNT(DISTINCT wassup_id) as items, COUNT(wassup_id) as pages, DATE_FORMAT(FROM_UNIXTIME((timestamp-$UTCoffset)), '$x_axes_label') as thedate FROM ".$this->tableName." WHERE wassup_id IS NOT NULL AND timestamp BETWEEN $hour_fromdate AND $hour_todate ".$this->whereis." $ss GROUP BY DATE_FORMAT(FROM_UNIXTIME((timestamp-$UTCoffset)), '$Ctimeformat') ORDER BY timestamp";
   echo $q;
   */

   - go to wassup visitors details and please paste here the result SQL code.

   Thank you very much

   Posted 4 years ago #
5. 

   sjespers
   Member

   Sure thing... here it is:
   SELECT COUNT(DISTINCT wassup_id) as items, COUNT(wassup_id) as pages, DATE_FORMAT(FROM_UNIXTIME((timestamp-7200)), '%H:00') as thedate FROM wp_wassup WHERE wassup_id IS NOT NULL AND timestamp BETWEEN 1207082705 AND 1207169105 GROUP BY DATE_FORMAT(FROM_UNIXTIME((timestamp-7200)), '%H') ORDER BY timestamp

   Posted 4 years ago #
6. 

   helene
   Moderator

   Hi Michele,
   I saw this post and thought I'd offer up a possible solution: Unix timestamp is an unsigned integer in MySQL and the offset subtraction may be changing that. Try using this replacement MySQL code for the chart. It is untested so, Serge, you shouldn't change the code yourself :

   SELECT COUNT(DISTINCT wassup_id) as items, COUNT(wassup_id) as pages, DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-$UTCoffset) AS UNSIGNED), '$x_axes_label') as thedate FROM ".$this->tableName." WHERE timestamp BETWEEN $hour_fromdate AND $hour_todate ".$this->whereis." $ss GROUP BY DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-$UTCoffset) AS UNSIGNED), '$Ctimeformat') ORDER BY timestamp

   The CAST() MySQL function will keep the timestamp as an unsigned integer.

   -Helene D.
   http://techfromhel.webege.com

   Posted 4 years ago #
7. 

   Michele
   Key Master

   Thank you Helene,
   I tested it there is a simple error in the bracket but it works great, I hope this could be the problem.

   Serge if you are so kind to test it too, here are the steps to make the changes:

   - edit the file in the wassup directory: lib/main.php
   - on line 856 please change the line started with: "$aitems = $wpdb->get_results("SELECT[...]" with this:

   $aitems = $wpdb->get_results("SELECT COUNT(DISTINCT wassup_id) as items, COUNT(wassup_id) as pages, DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-$UTCoffset) AS UNSIGNED)), '$x_axes_label') as thedate FROM ".$this->tableName." WHERE timestamp BETWEEN $hour_fromdate AND $hour_todate ".$this->whereis." $ss GROUP BY DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-$UTCoffset) AS UNSIGNED)), '$Ctimeformat') ORDER BY timestamp", ARRAY_A);

   - connect to the visitors details and let me know if you are able to see the chart

   Thank you very much

   PS
   a question: did you see the site usage (visits, pages, spams count) above the chart?

   Posted 4 years ago #
8. 

   sjespers
   Member

   Hmm... I'm sure I answered this but the answer is not here. This is still not working... I'm not seeing an error anymore but I also don't get the chart...

   Posted 4 years ago #
9. 

   helene
   Moderator

   Serge,
   Sorry that my suggestion didn't solve your problem. It would help if I knew what version of MySQL and PHP that you run on your web server. The MYSQL statement above may need to be altered just for your configuration.

   Posted 4 years ago #

RSS feed for this topic

Reply

You must log in to post.