SQLSTATE[HY000]: General error: 1193 Unknown system variable 'STATEMENT'

Support & Bugs
1

Hi community,

I installed the latest version of Matomo on my server. The config for database is set to PDO and database-server is MariaDB 5.5.68. The installation worked fine and finished without problems. But now I get following Error (e.g. in graph of last visits):

SQLSTATE[HY000]: General error: 1193 Unknown system variable ‘STATEMENT’

How can I fix this?

Thanks in advance!

Felix

2

You should update your MariaDB. 5.5.68 ist very old (2020?). I think that error happens because your MariaDB version is not compatible with some SQL statements used by Matomo.

I recommend 10.3 or higher, but I haven’t checked if matomo recommends something else. We run 10.3.39.

3

Thanks for your quick reply. Well, that’s what I feared. We will look into it and try getting a newer version of MariaDB.