Hi All,
I was being prompted by Moodle to update my Collation of my database from utf8_bin to utf8mb4_bin. Since having done this I am unable to add new users to my moodle site and I get the following error when trying to add users. (see image attached)
Any advice, would be greatly appreciated.
…update my Collation of my database from utf8_bin to utf8mb4_bin. Since having done this… – what steps did you take?
It looks like your database uses character set utf8 but in config.php you have 'dbcollation' => 'utf8mb4_bin' which isn't a valid collation for that character set. But neither utf8_bin nor utf8mb4_bin are the correct collation for Moodle, it should be either:
This reply suggests how to migrate to the recommended character set utf8mb4 and collation utf8mb4_unicode_ci (based on these docs).
If you want to migrate to utf8mb4, which is recommended, you'll need to follow the four steps in that link: 1) check the database configuration, 2) make any needed database configuration changes, 3) run Moodle's mysql_collation.php script, and 4) change 'dbcollation' in config.php.
If you try this and there are problems, you can post in the forums and we'll try to help.
