WordPress WassUp Error
07 Apr 2008 | programming | comments | editI've upgraded the wassup plugin to the latest version ( 1.5 ) and an error started to show in the pages:
[ wp_wassup_tmp' doesn't exist ]
The solution is to deactivate the plugin and then reactivate it... witch should be the right way to upgrade your plugins.
Update:
I also get a syntax error from the wassup plugin, on the dashboard:
***WordPress database error:*** [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND 1207656596' at line 1]
SELECT COUNT(DISTINCT wassup_id) AS itemstot FROM wp_wassup WHERE wassup_id IS NOT NULL AND timestamp BETWEEN AND 1207656596
It seems that the errore comes from a debug query that was left in the wassupDashChart() function. To fix the error you need to comment two lines (1631,1632) of code in wassup.php:
1 // This is the function to print out a chart's preview in the dashboard
2 function wassupDashChart() {
3 global $wpdb;
4 $table_name = $wpdb->prefix . "wassup";
5 $to_date = wassup_get_time();
6 $Chart = New MainItems;
7 $Chart->tableName = $table_name;
8 $Chart->to_date = $to_date;
9
10 //$itemstot = $Chart->calc_tot("count", $search, null, "DISTINCT");
11 //print $itemstot;
12
13 echo '<h3>WassUp Stats <cite><a href="admin.php?page=wassup">More ยป</a></cite></h3>';
14 echo $Chart->TheChart(1, "400", "125", "", $wassup_options->wassup_chart_type, "bg,s,00000000", "dashboard", "left");
15 } //end function wassupDashChart