I did Softaculous one click backup and update, but also full backup with Cpanel. Moodle was on Maintenance during this process.
I did not make the Standard procedure install package for Moodle. I installer new files over the old.
All my Environment is ok with green, except https. Other warning was utf8, but I changed it in
SQL with no problem.
As the email seems to be the problem, I checked configuration and was ok, but when traying to send an auto-email to check operation, I had this message:
Información de depuración: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'
SELECT * FROM mdl_user WHERE LOWER(email) COLLATE utf8mb4_bin = LOWER(?) AND deleted <> 1 AND mnethostid = ? AND id IN (SELECT id FROM mdl_user WHERE email = ?)
[array (
0 => 'name@hotmail.com',
1 => '1',
2 => 'name@hotmail.com',
)]
Error code: dmlreadexception
Trazado de la pila (stack):
line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1273 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1671 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1643 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 4979 of /lib/moodlelib.php: call to moodle_database->get_record_select()
line 387 of /login/lib.php: call to get_complete_user_data()
line 85 of /login/forgot_password_form.php: call to core_login_validate_forgot_password_data()
line 615 of /lib/formslib.php: call to login_forgot_password_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 47 of /login/lib.php: call to moodleform->get_data()
line 78 of /login/forgot_password.php: call to core_login_process_password_reset_request()
I chaged utf8 to utf8mb4_bin in SQL but seems that there are some problem in Moodle. I do not know how to change it in Moodle and did not found any explanation about.