Task #102667
closed
BE Module Reports show"illegal mix of collations" Message
0%
Description
The message "illegal mix of collations" is shown if the BE Modul Webreactions or Webhooks is installed.
Because both modules creates a db table with a field using a differente collation:
sys_reaction.fields use the collation utf8mb4_bin and sys_webhook.additional_headers use the collation utf8mb4_bin also
But the default collation is "utf8mb4_unicode_ci"
This results in a error message inside the BE Reports Module:
our default database is set to create tables with character set "utf8mb4_unicode_ci", but contains tables or columns with different collations. Please fix these tables to avoid "illegal mix of collations" errors.
i dont have taken a deeper look if the different collation is necessary for the db fields (imho sorting and comparing) but this message is maybe a false positive or could be confusing some users
Files
Updated by Garvin Hicking 14 days ago
- Status changed from New to Needs Feedback
Could it be you created the tables and switched default collations in your setup at some point? Does it happen on a fresh installation for you too, or an existing project (migrated?)
Does the DB Compare tool show any outstanding changes?
Updated by Benni Mack 11 days ago
- Category changed from WebHooks - Incoming = Reactions + Outgoing to Reports
Updated by Garvin Hicking 5 days ago
- Status changed from Needs Feedback to Closed
The TYPO3 core itself doesn't define utf8mb4_bin itself, so this is most likely a problem in the order of database operations or performing import/export with changes of default collations.
Ideally you should ensure that utf8mb4_unicode_ci is used everywhere.
The DB Analyzer for TYPO3 v13 is also worked on to address collations.
I will close this issue for now, if you feel this is a mistake or have additional feedback, please get in touch. You can also create a follow-up issue.