Moodle 2.6.2.
When restoring an assignment activity we get this error in our debug logs. The restore fails. Is there a way to fix this? We are comfortable opening the mbz file and editing some simple XML.
[Mon Jun 22 14:11:37 2015] [error] [client 71.127.nn.nn] Default exception handler: Error writing to database Debug: Duplicate entry '25-0-0-0' for key 'mdl_assisubm_assusegroatt_uix'\nINSERT INTO mdl_assign_submission (userid,timecreated,timemodified,status,groupid,attemptnumber,assignment) VALUES(?,?,?,?,?,?,?)\n[array (\n 0 => '0',\n 1 => 1414421897,\n 2 => 1414422107,\n 3 => 'draft',\n 4 => 0,\n 5 => '0',\n 6 => 25,\n)]\nError code: dmlwriteexception\n* line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown\n* line 1080 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()\n* line 1122 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()\n* line 136 of /mod/assign/backup/moodle2/restore_assign_stepslib.php: call to mysqli_native_moodle_database->insert_record()\n* line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_assign_activity_structure_step->process_assign_submission()\n* line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()\n* line 151 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()\n* line 91 of /backup/util/helper/restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()\n* line 148 of /backup/util/xml/parser/processors/simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()\n* line 92 of /backup/util/xml/parser/processors/progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()\n* line 186 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()\n* line 233 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()\n* line ? of unknownfile: call to progressive_parser->start_tag()\n* line 175 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()\n* line 154 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()\n* line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()\n* line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()\n* line 192 of /backup/moodle2/restore_activity_task.class.php: call to base_task->execute()\n* line 177 of /backup/util/plan/base_plan.class.php: call to restore_activity_task->execute()\n* line 167 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()\n* line 328 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()\n* line 184 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()\n* line 99 of /backup/restore.php: call to restore_ui->execute()\n, referer: http://mylearning.nagc.org/backup/restore.php
[Mon Jun 22 14:11:37 2015] [error] [client 71.127.nn.nn] Potential coding error - existing temptables found when disposing database. Must be dropped!, referer: http://mylearning.example.org/backup/restore.php
Thank you
--Karl