I have upgraded moodle 3.2.9 to lates 3.5+ (stabel version) however while restoring course following error has come
-----
Error reading from database
More information about this error
Debug info: COLLATION 'utf8mb4_bin' is not valid for CHARACTER SET 'utf8'SELECT COUNT(*) FROM ( SELECT c.id, c.name, c.visible, c.sortorder, c.description, c.descriptionformat , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance FROM mdl_course_categories c LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = ?) WHERE LOWER(c.name) LIKE LOWER(?) COLLATE utf8mb4_bin ESCAPE '\\' ) sel
[array (
0 => 40,
1 => '%%',
)]
Error code: dmlreadexception
------
Stack trace:
- line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1246 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1571 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
- line 1644 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
- line 1854 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
- line 190 of /backup/util/ui/restore_ui_components.php: call to moodle_database->count_records_sql()
- line 125 of /backup/util/ui/restore_ui_components.php: call to restore_search_base->search()
- line 275 of /backup/util/ui/renderer.php: call to restore_search_base->get_count()
- line 537 of /backup/util/ui/restore_ui_stage.class.php: call to core_backup_renderer->course_selector()
- line 153 of /backup/restore.php: call to restore_ui_stage_destination->display()
----------
Please help me with appropriate solution, it will be great help
Thanks in advance
