when i try to add users i get the error in the picture
Edit config.php and find the 'dbcollation' line:
$CFG->dboptions = array (
⋮
'dbcollation' => 'utf8mb4_bin',
);
Change the 'dbcollation' to 'utf8_unicode_ci'.
See this reply for more information about this problem and migrating to the recommended settings.
thank you for help me my config is
'dbport' => '',
'dbsocket' => '',
'dbcollation' => 'utf8mb4_unicode_ci'
'dbport' => '',
'dbsocket' => '',
'dbcollation' => 'utf8mb4_unicode_ci'
Sorry for the confusion. The 'dbcollation' should still be changed to 'utf8_unicode_ci' because the error indicates the Moodle database character set is utf8.
Collation utf8mb4_unicode_ci should only be used when the database character set utf8mb4.
Thank you, it is working now.
Hi.
Please can you direct me to where I can find the config.php to find the dbcollation line so I can make the change?
Do I find this in Moodle or in the cpanel at phpMyAdmin?
Please can you direct me to where I can find the config.php to find the dbcollation line so I can make the change?
Do I find this in Moodle or in the cpanel at phpMyAdmin?
When I access phpMyAdmin, which table to I go to?
Is this the correct place?
Table: mdloj_user?
Do I then change the Collation of each of the pink marked items to utf8_unicaode_ci?
And then I will be able to add a new user from within Moodle?
I have no experience with database work and am anxious to make changes at the back end where I don't understand what I am doing.
Please can you direct me to how I should make the changes to be able to add a new user?
Thank you in advance!