@anonymous-piwik-user opened this issue on September 19th 2009

I get the following error when trying to view the Last Visits Graph for the current day:

Request URL: http://www.mywebsite.com/ezpiwik/index.php?module=VisitsSummary&action=getEvolutionGraph&columns[]=nb_visits&idSite=1&period=day&date=2009-08-21,2009-09-19&viewDataTable=generateDataChartEvolution

Response: 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 ( 'nb_visits' )' at line 3

I've dropped and recreated the database and deleted and reinstalled piwik multiple times and this still becomes an issue after the first days data is recorded, it starts giving this error. It appears to be archiving fine as I can see in the database, so I do not know what the issue is.

@robocoder commented on September 19th 2009

This sounds like a variation of the timezone anomaly. (To be addressed in #56.)

Please confirm that PHP's date.timezone (default is Eastern if not specified) matches your MySQL server's timezone.

@anonymous-piwik-user commented on September 19th 2009

I set them both to US/Eastern and it seems to have fixed the problem for now. I'll keep an eye on it though.

This issue was closed on September 21st 2009
Powered by GitHub Issue Mirror