I've been trying to upgrade our moodle frmo 3.3 to 3.5 today, but keep running into this error:
Debug info: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'latin1'
SELECT * FROM mdl_config_plugins where plugin=? and name LIKE ? COLLATE utf8mb4_bin ESCAPE '\\'
[array (
0 => 'hub',
1 => '%\\_httphubmoodleorg',
)]
Error code: dmlreadexception
I've been through the guide here: https://docs.moodle.org/32/en/Converting_your_MySQL_database_to_UTF8
I've set the various settings in the my.cnf file, I've run the mysql_collation.php cli script.
Here are the character sets and collations:
And here is the my.cnf file:
character_set_system apparently can't be overriden, so that is still utf8.
I'm not sure why collation_connection is general and not unicode, i'm setting it with an init-connect, but obviously that's not working.
As you can see the table is utf8mb4, the columns are all utf8mb4:
Nothing is latin1, so I just don't know where that error is coming from.
Strangely, if I run the SQL command manually:
SELECT * FROM mdl_config_plugins where plugin= 'hub' and name LIKE '%\\_httphubmoodleorg' COLLATE utf8mb4_bin ESCAPE '\\'
The error I get is:
Error Code: 1253. COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
At this point i'm just very confused...