SQL error after migration to new server

I am migrating a matomo installation to a new server.
On the old server are the following versions are installed:
MySQL: 5.7.11
PHP: 7.1.7
Piwik: 3.0.1
On the new server:
MYSQL: 8.0.12
PHP: 7.1.21
Piwik: 3.0.1 (copied from old server)
On the new server i get the following error on calling the piwik installation in the browser:
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
I assume that the reason is the difference in PHP- or MySQL-version. Any help is appreciated.

Best regards


This issue has been reported in

and fixed in 3.5.0.

So just update Matomo to the latest version before migrating to make it support MySQL 8.x.

1 Like

Fine, thank you for answering.