'SQLSTATE[42000]: Syntax Error Or Access Violation' Error When Installing

Support & Bugs
1

Hello!

I am receiving a message stating ‘SQLSTATE[42000]: Syntax Error Or Access Violation’ Error when manually installing the latest version of Matomo. What can I do to resolve this issue?

Thanks!

2

Hi,

Does the error message say anything after Syntax Error Or Access Violation?

3

The complete error is as follows:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DEFAULT CHARSET=utf8mb4’ at line 10

4

Same here… first I had a different error, chose PDO/MySQLi
now this crap…

Any ideas?

5

Hatte das gleiche Problem beim Installieren – bei mir lag’s an der MySQL-Version, die war zu alt. Nach dem Update auf MySQL 5.7 lief alles problemlos durch.