Open Flash Chart
JSON Parse Error [Syntax Error]
Error at character 0, line 1:
0: SQLSTATE[42000]: 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 ')
I’m trying to view today’s stats but they don’t seem to be updating. When I click on today’s date to view this error shows up in the visitor modules. Any ideas?
Though I would like to bring up another issue, coincidence I’m sure, but when I put this post up my site was bombarded with visits mostly looking for some access to different versions of my database through various forms of phpMyAdmin in the url. The only reason I bring this up here is because at that same time Piwik is reporting that some are coming from “www.phpmyvisites.net” and “www.phpmyvisites.us” as well as some urls pointing to “/?piwik_campaign=fdfff” Piwik campaigns that don’t exist.
If you have any input toward this that would be nice.
I’ve just set up Piwik and got the same problem (or similar).
I am getting error
a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:282:“SQLSTATE[42000]: 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 ( ‘max_actions’, ‘nb_uniq_visitors’, ‘nb_visits’, ‘nb_ac’ at line 3”;}
at “Last visits graph”.
Please give a detailed instruction how to fix it, if you can.
Change the date.timezone setting in php.ini to match the timezone of the MySQL server. You’ll find a list of supported timezones at PHP: List of Supported Timezones - Manual