Hi,
We have a ton of users reporting they get an error stating "error reading from database" when attempting to use the duplicate item function to
duplicate an assignment as well as when archiving a course. It happens in any course. The item does not appear until the users refreshes the screen but when doing so the screen freezesand the user is forced to leave the course and re-open it.
This all seemed to surface after upgrading from 2.7 to 3.1.19
Any help someone could provide would be greatly appreciated.
Thank you,
See additional details below:
Also when looking at the error logs we see the following:
Debug
info: Unknown column 't.intro' in 'field list' SELECT
t.id, t.intro FROM mdl_tab t JOIN mdl_backup_ids_temp b
ON b.newitemid = t.id WHERE b.backupid = ? AND
b.itemname = ? [array ( 0 =>
'5a5cd0fe64125f724465d3537cbbe3cf', 1 => 'tab', )] Error
code: dmlreadexception
Stack trace:
line 479 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 1114 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 103 of /backup/util/helper/restore_decode_content.class.php: call to mysqli_native_moodle_database->get_recordset_sql()
- line 72 of /backup/util/helper/restore_decode_content.class.php: call to restore_decode_content->get_iterator()
- line 81 of /backup/util/helper/restore_decode_processor.class.php: call to restore_decode_content->process()
- line 775 of /backup/moodle2/restore_stepslib.php: call to restore_decode_processor->execute()
- line 34 of /backup/util/plan/restore_execution_step.class.php: call to restore_decode_interlinks->define_execution()
- line 181 of /backup/util/plan/base_task.class.php: call to restore_execution_step->execute()
- line 177 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
- line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
- line 335 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
- line 3698 of /course/lib.php: call to restore_controller->execute_plan()
- line 3625 of /course/lib.php: call to duplicate_module()
- line 118 of /course/rest.php: call to mod_duplicate_activity()