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: 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.
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.
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.