We have dev and prod environments. I just cloned prod into dev so ideally the two would be almost identical.
But a content creator could neither create a single activity scorm course nor a scorm activity in a course in our production environment. So I asked her to try in our dev environment. She was able to successfully create the SCORM activity/single activity course there. I was able to replicate this--could not create it in prod but could in dev.
So I looked at the files that were printed out in the error message on prod on the server--their last update date. They had not been updated on prod or dev recently. But I went ahead and copied the ones from dev to prod as dev was "working" but prod "was not working".
I still could not create the SCORM course on prod. I've cleared out the cache. I have made sure I could create another type of course with a file attachment. I have looked in the files table to see if there is a duplicate/orphaned file there of the same namae. There isn't one. I made sure that the slashes name setting was set.
The content creator said that when she originally tried to create the course it said the SCORM didn't have a manifest file. So she sent it back to the content developer to add one. She then tried again which is when she and I are now.
This is not a PHP max_upload_file error. We can upload the file and set the settings on that page. It is when we try to return to the course that it errors out and actually create the scorm by clicking the button at the bottom of the page that we get the error.
The error is :
Error writing to database
More information about this error
Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'manifest,organization,parent,identifier,launch,scormtype,title,sortorder,scorm) ' at line 1
INSERT INTO mdl_scorm_scoes (manifest,organization,parent,identifier,launch,scormtype,title,sortorder,scorm) VALUES(?,?,?,?,?,?,?,?,?)
[array (
0 => '_45YTIxIO_course_id',
1 => '',
2 => '/',
3 => 'My_Course_name',
4 => '',
5 => '',
6 => 'My_Course_name',
7 => '1',
8 => 441,
)]
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 86 of /mod/scorm/backup/moodle2/restore_scorm_stepslib.php: call to mysqli_native_moodle_database->insert_record()
line 137 of /backup/util/plan/restore_structure_step.class.php: call to restore_scorm_activity_structure_step->process_scorm_sco()
line 103 of /backup/util/helper/restore_structure_parser_processor.class.php: call to restore_structure_step->process()
line 178 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 198 of /backup/moodle2/restore_activity_task.class.php: call to base_task->execute()
line 177 of /backup/util/plan/base_plan.class.php: call to restore_activity_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 224 of /backup/util/ui/restore_ui.class.php: call to restore_controller->execute_plan()
line 111 of /backup/restore.php: call to restore_ui->execute()
Any ideas on what to look for? What to test for? What the problem would be? Thanks