Illegal Mix of Collations
If you receive an error like this:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT)
for operation '='
INSERT INTO mdl_scorm_scoes_value (attemptid, scoid, elementid, value, timemodified)
It is indicating that you have tables with different collation types in your database e.g. utf8_unicode_ci vs utf8_general_ci
You'll need to change them all to the same type using the mysql_collation.php CLI tool:
e.g. change them all to utf8_unicode_ci.
php admin/cli/mysql_collation.php --collation=utf8_unicode_ci
Converted: 168, skipped: 1663, errors: 0
No Comments