@wlinker opened this Issue on February 15th 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!

@wlinker commented on February 15th 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 commented on April 21st 2018

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 commented on April 26th 2018

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

Powered by GitHub Issue Mirror