2.1 Course Backup won't Restore into 2.2.3

2.1 Course Backup won't Restore into 2.2.3

by Richard MacLemale -
Number of replies: 0

I am trying to take a backup course file made in Moodle 2.1 and restore it to a Moodle 2.2.3 site. I've been restoring other courses with no issues, but with this one course it's failing.  Any help appreciated.

Here is the debug info:

Debug info: Field 'numquestions' doesn't have a default value
INSERT INTO mdl_question_match (subquestions,shuffleanswers,correctfeedback,correctfeedbackformat,partiallycorrectfeedback,partiallycorrectfeedbackformat,incorrectfeedback,incorrectfeedbackformat,shownumcorrect,question) VALUES(?,?,?,?,?,?,?,?,?,?)
[array (
0 => '1,2,3',
1 => '1',
2 => '',
3 => '0',
4 => '',
5 => '0',
6 => '',
7 => '0',
8 => '0',
9 => 3630,
)]
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 98 of /question/type/match/backup/moodle2/restore_qtype_match_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_match_plugin->process_matchoptions()
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 310 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 /Volumes/Data/Websites/elementary/backup/restore.php: call to restore_ui->execute()

Average of ratings: -