Problem

In one clients installation whyever the default collation was changed.

So new tables were created with the different collation.

Several String compare statements did not work after that. For example the following Update Statement of alter file 134-editor-mysql-TRANSLATE-1188.sql:

UPDATE `LEK_terms` `t`, `LEK_term_collection` `c` set `t`.`collectionId` = `c`.`id` where `t`.`taskGuid` = `c`.`taskGuid`;

Error message was:

ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

since tables are defined differently LEK_terms with utf8_general_ci and LEK_term_collection with utf8_unicode_ci.

That lead to the problem that that SQL script stopped working and therefore broke all further update steps.

solution

For this customer we provided some custom fixes.

In general we should add a check for Database default charset and default collation in the install-and-update.sh script (Models_Installer_PreconditionCheck).