when I enable the small chart on the dashboard, I get the following database error:
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 '-3600) AS UNSIGNED)), '%H:00') as thedate FROM wp_wassup WHERE ]
SELECT COUNT(DISTINCT wassup_id) as items, COUNT(wassup_id) as pages, DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-3600) AS UNSIGNED)), '%H:00') as thedate FROM wp_wassup WHERE timestamp BETWEEN 1227717100 AND 1227803500 GROUP BY DATE_FORMAT(FROM_UNIXTIME(CAST((timestamp-3600) AS UNSIGNED)), '%H') ORDER BY timestamp
I wonder if it has something to do with the webhost using MYSQL 4.0.27. Is there any way to fix it?