SQL errors on Matomo

Support & Bugs
1

Hi ,

Environment

Matomo version: 3.8.1
MySQL version: 10.2.21-MariaDB with TokuDB
PHP version: 7.0.33

I am seeing following SQL errors on two screens of Matomo . Any idea what can be done about these ?

Evolution over the period

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=utf8’ at line 13

Visits Over Time

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=utf8’ at line 13

2

I migrated the database from TokuDB to InnoDB .

All these errors are gone since i moved to InnoDB .

1 Like