Quiz

Trying to restore courses, we get "Error writing to database" Debug led me to the backup forum. They sent me to /health report which reported below and then suggested I ask here about insight on how to handle the non-zero category names./contexts. I am a total newbie in this area:

All question categories are linked to a context id, and, the context they are linked to must exist. The following categories belong to a non-existant category:

Any of these categories that contain no questions can just be deleted form the database. Other categories will require more thought.

Debug info: Duplicate entry '6467' for key 'mdl_qtypmultopti_que_uix'
INSERT INTO mdl_qtype_multichoice_options (layout,single,shuffleanswers,correctfeedback,correctfeedbackformat,partiallycorrectfeedback,partiallycorrectfeedbackformat,incorrectfeedback,incorrectfeedbackformat,answernumbering,shownumcorrect,questionid) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => '0',
1 => '1',
2 => '1',
3 => '',
4 => '1',
5 => '',
6 => '1',
7 => '',
8 => '1',
9 => 'abc',
10 => '0',
11 => 6467,
)]
Error code: dmlwriteexception

Stack trace:

• line 446 of /lib/dml/moodle_database.php: dml_write_exception thrown
• line 1164 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
• line 1210 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
• line 76 of /question/type/multichoice/backup/moodle2/restore_qtype_multichoice_plugin.class.php: call to mysqli_native_moodle_database->insert_record()
• line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_qtype_multichoice_plugin->process_multichoice()
• line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
• line 151 of /backup/util/xml/parser/processors/grouped_parser_processor.class.php: call to restore_structure_parser_processor->dispatch_chunk()
• line 91 of /backup/util/helper/restore_structure_parser_processor.class.php: call to grouped_parser_processor->postprocess_chunk()
• line 148 of /backup/util/xml/parser/processors/simplified_parser_processor.class.php: call to restore_structure_parser_processor->postprocess_chunk()
• line 92 of /backup/util/xml/parser/processors/progressive_parser_processor.class.php: call to simplified_parser_processor->process_chunk()
• line 190 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
• line 278 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
• line ? of unknownfile: call to progressive_parser->end_tag()
• line 179 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()
• line 158 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()
• line 110 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
• line 181 of /backup/util/plan/base_task.class.php: call to restore_structure_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 333 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
• line 184 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()