Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MySQL Syntax Error when viewing Todays Visit Summary #989

Closed
anonymous-matomo-user opened this issue Sep 19, 2009 · 2 comments
Closed

MySQL Syntax Error when viewing Todays Visit Summary #989

anonymous-matomo-user opened this issue Sep 19, 2009 · 2 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Critical Indicates the severity of an issue is very critical and the issue has a very high priority. duplicate For issues that already existed in our issue tracker and were reported previously.
Milestone
0.4.4

Comments

@anonymous-matomo-user
Copy link

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
Copy link
Contributor

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-matomo-user
Copy link
Author

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.

@anonymous-matomo-user anonymous-matomo-user added this to the Piwik 0.4.4 milestone Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. Critical Indicates the severity of an issue is very critical and the issue has a very high priority. duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Milestone
0.4.4
Development

No branches or pull requests
2 participants
@robocoder @anonymous-matomo-user