Same problem here, happened with the upgrade from 11.4.3 → 11.5.2. I checked all my collations, and they all match.

Hi @an0nfunc If you did the DB migration, then I suppose the problem comes from there. You have to fix this manually, or revert to the previous DB…

Hi @none When upgrading, did you also add new plugins?

Hi, i did not install anything. I just run the update to the latest matomo version via matomo interface. Thete were no error messages diring the update. Since the updaze i get those sql errors.

Fix what manually? The tables and columns all have the correct collation, that’s what’s so weird about this. Matomo was not upgraded since this started. Was only the mariadb upgrade.

Hi @an0nfunc , @none , @54mu3l It seems the bug has been reported in the Matomo GitHub: [Bug] Illegal mix of collations opened 06:57AM - 28 Aug 24 UTC (UTC) [felixlabrot] felixlabrot …

@heurteph-ei It’s not a fresh installation. The installation is running for several years now. The issue arose a couple days ago. It might be linked to the update to Matomo v5.1.1. But, there might also have been an automatic MariaDB update. So this could also be the root of the problem. Currently…

This will need changes on Matomo’s side. Setting the connection collation should fix this, probably.

We also have the same issue. We updated Matomo to 5.1.1 and then the docker, which is running 11.5.2, and now we get the mismatch error. Should we expect an update from Matomo, or do we have to fix this ourselves, and if so, how?

Hi @yellowdog , I think you’ll have to wait for a fix. As soon as a a pull request will be linked to the ticket and the merge approved, you’ll be able to apply manually the fix on your installation, before waiting for the official release containing this fix.

Illegal mix of collations

Support & Bugs

heurteph-ei (Philippe) September 26, 2024, 6:28am 17

The problem has been fixed!