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

Syntax error or access violation: 1064 #12564

Closed
wlinker opened this issue Feb 15, 2018 · 4 comments
Closed

Syntax error or access violation: 1064 #12564

wlinker opened this issue Feb 15, 2018 · 4 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@wlinker
Copy link

wlinker commented Feb 15, 2018

in: Matomo matomo-3.x-dev, AND Matomo latest stable from webpage I have this error:


An error occurred
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 '. piwik_log_visit' at line 1
Go Back | Go to Matomo

Matomo.org homepage
Matomo Frequently Asked Questions
Matomo Documentation
Matomo Forums
Professional help for Matomo
« Back to Matomo

But i don't get any information about where are the problem, help me!

@Findus23 Findus23 changed the title I have this problem Syntax error or access violation: 1064 Feb 15, 2018
@wlinker
Copy link
Author

wlinker commented Feb 15, 2018

My Error.log from PHP show this:
[15-Feb-2018 18:41:05 UTC] Error in Matomo: 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 '. piwik_log_visit' at line 1

My Server specs are:
Windows Server 2016
Database: 8.0.3-rc-log - MySQL
IIS : 10.0.14393.0
PHP: 7.1.10

@yoshimasa0202
Copy link

My Error.log from PHP show this:

PHP message: Error in Matomo: 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 '. piwik_log_visit' at line 1

piwik/console core:archive from CRON error show this:

INFO [2018-04-21 23:36:59] Error: Got invalid response from API request: ?module=API&method=API.get&idSite=11&period=day&date=last52&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:219:"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 '. piwik_log_visit' at line 1";}'

--
My Server specs are:
CentOS Linux 6.9 (x86_64)
Mysql 8.0.11
Nginx 1.14.0
PHP 7.1.12

@thelittlefireman
Copy link

Same error after the installation step when you set the db.
i'm using the docker image of matomo : 3.4.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 '. matomo_log_visit' at line 1

Mysql 8.0.13

@Findus23 Findus23 added the Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. label May 24, 2020
@sgiehl
Copy link
Member

sgiehl commented Nov 9, 2022

I hope this issue was meanwhile fixed silently somewhen in the last 4 years. If anyone still has this problem, please don't hesitate to create a new issue for it. Thanks.

@sgiehl sgiehl closed this as not planned Won't fix, can't repro, duplicate, stale Nov 9, 2022
@sgiehl sgiehl added answered For when a question was asked and we referred to forum or answered it. and removed Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. labels Nov 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

5 participants