Hello,
When i want to add new user I get this Error in below ,how can i resolved this ?
Error reading from database
More information about this error
Debug info: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
SELECT 'x' FROM mdl_user WHERE LOWER(email) COLLATE utf8mb4_bin = LOWER(?) AND mnethostid = ? AND id <> ? LIMIT 0, 1
[array (
0 => 'monpersonemail@gmail.com',
1 => '1',
2 => -1,
)]
Error code: dmlreadexception
Stack trace:
line 494 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
line 1337 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 2015 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
line 2000 of /lib/dml/moodle_database.php: call to moodle_database->record_exists_sql()
line 313 of /user/editadvanced_form.php: call to moodle_database->record_exists_select()
line 674 of /lib/formslib.php: call to user_editadvanced_form->validation()
line 610 of /lib/formslib.php: call to moodleform->validate_defined_fields()
line 720 of /lib/formslib.php: call to moodleform->is_validated()
line 176 of /user/editadvanced.php: call to moodleform->get_data()
Thanks in advance
