Hello, everybody,
I need help, cause I see this error when I want to register a new user.
Error reading from database
Debug info: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
SELECT 'x' FROM mdlp9_user WHERE LOWER(email) COLLATE utf8mb4_bin = LOWER(?) AND mnethostid = ? AND id <> ? LIMIT 0, 1
[array (
0 => 'xxx@gmail.com',
1 => '1',
2 => -1,
)]
Error code: dmlreadexception
SELECT 'x' FROM mdlp9_user WHERE LOWER(email) COLLATE utf8mb4_bin = LOWER(?) AND mnethostid = ? AND id <> ? LIMIT 0, 1
[array (
0 => 'xxx@gmail.com',
1 => '1',
2 => -1,
)]
Error code: dmlreadexception
Stack trace:
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1212 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 2002 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
- line 1987 of /lib/dml/moodle_database.php: call to moodle_database->record_exists_sql()
- line 310 of /user/editadvanced_form.php: call to moodle_database->record_exists_select()
- line 615 of /lib/formslib.php: call to user_editadvanced_form->validation()
- line 551 of /lib/formslib.php: call to moodleform->validate_defined_fields()
- line 661 of /lib/formslib.php: call to moodleform->is_validated()
- line 171 of /user/editadvanced.php: call to moodleform->get_data()
Please, I need your help.