SQL error after migration to new server

Support & Bugs
1

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
normannescio

2

Hi,

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
3

Fine, thank you for answering.