Our new Moodle 2.2.3 server looks and behaves nicely. But something happened that makes it impossible to restore any course backup archive or import content from an existing course.
We turned on Developer Debugging and consistently see the same error message whether we restore an archive or try importing content into an empty course shell:
=========================
Error writing to database
More information about this error
Debug info: Duplicate entry '841' for key 'mdl_qtypessaopti_que_uix'
INSERT INTO mdl_qtype_essay_options (responseformat,responsefieldlines,attachments,graderinfo,graderinfoformat,questionid) VALUES(?,?,?,?,?,?)
[array (
0 => 'editor',
1 => '15',
2 => '0',
3 => '',
4 => '0',
5 => 841,
)]
Stack trace:
- line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown
- line 893 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 935 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 63 of /question/type/essay/backup/moodle2/restore_qtype_essay_plugin.class.php: call to mysqli_native_moodle_database->insert_record()
- line 131 of /backup/util/plan/restore_structure_step.class.php: call to restore_qtype_essay_plugin->process_essay()
- line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
- line 125 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 169 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser_processor->receive_chunk()
- line 253 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->publish()
- line ? of unknownfile: call to progressive_parser->end_tag()
- line 158 of /backup/util/xml/parser/progressive_parser.class.php: call to xml_parse()
- line 137 of /backup/util/xml/parser/progressive_parser.class.php: call to progressive_parser->parse()
- line 105 of /backup/util/plan/restore_structure_step.class.php: call to progressive_parser->process()
- line 153 of /backup/util/plan/base_task.class.php: call to restore_structure_step->execute()
- line 148 of /backup/util/plan/base_plan.class.php: call to base_task->execute()
- line 157 of /backup/util/plan/restore_plan.class.php: call to base_plan->execute()
- line 315 of /backup/controller/restore_controller.class.php: call to restore_plan->execute()
- line 147 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
- line 46 of /backup/restore.php: call to restore_ui->execute()
============================================
We'd appreciate it very much if someone might suggest: (1) what this means, and (2) how do we fix it.
Thanks for your consideration.
Bob Blomeyer