Data from previous days shows up just fine. However, when I try to look at any data from today in the dashboard for example I either get “no data for this table”, and in the Last Visits Graph I get the following error:
SQLSTATE: Syntax error or access violation: 1064 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 name IN ( ‘nb_visits’ )’ at line 3
I’ve run archive.sh from the command line and that seemed to run successfully but didn’t help. I’ve also restarted apache and mysql. How do I either get this working or roll back to 0.5.4?