DB errors after migration

Support & Bugs
1

Hi all,

I migrated a matomo installation, incl database to a new server. After the migration I started getting the following errors a lot in my DB log. Any ideas how to approach them?
So far most operations seem to work fine though.

[ERROR] Incorrect definition of table mysql.column_stats: expected column ‘hist_type’ at position 9 to have type enum(‘SINGLE_PREC_HB’,‘DOUBLE_PREC_HB’,‘JSON_HB’), found type enum(‘SINGLE_PREC_HB’,‘DOUBLE_PREC_HB’).
[ERROR] Incorrect definition of table mysql.column_stats: expected column ‘histogram’ at position 10 to have type longblob, found type varbinary(255).

2

Hello,

If you did not resolve your problem yet you probably should upgrade mysql.

For example :

mysql_upgrade -u root -p<yourpassword>
3

Hi @perelin
Another solution could force the database update:

$ ./path/to/matomo/console core:update