I'm trying to upload a AICC file from BizLibrary (see attachment) into Moodle and receiving this error
Is it something wrong with my database?
I'm on Moodle version: 3.5.3
Looks like the AICC file isn't providing an organisation field.
Try using the direct aicc url option. If you open up the .au file you will see these bits of info:
put them together (with a ? in the middle) to make this:
and then add a new SCORM package, select direct aicc url and try that url to see if it works for you.
ok thanks just seeing your response didn't get a notification that someone replied, I will try this and let you know if it worked!
Ok so I tried what you said and received this error? providing this URL:
It appears that its something wrong with the address field. Let me try figuring it out
Hi GJ - Was this error resolved? We're seeing exactly the same thing and BizLibrary are no help at all.
I am also trying to add a test AICC package, installing it via the SCORM activity type. I've tried multiple settings but always end with an "Error writing to database." ×Debug info: Column 'identifier' cannot be null
INSERT INTO mdl_scorm_scoes (identifier,scorm,organization,title,parent,launch,scormtype,sortorder) VALUES(?,?,?,?,?,?,?,?)
0 => NULL,
1 => '47',
2 => '',
3 => NULL,
4 => '/',
5 => '',
6 => '',
7 => 1,
Error code: dmlwriteexception
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
line 1362 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1408 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
line 293 of /mod/scorm/datamodels/aicclib.php: call to mysqli_native_moodle_database->insert_record()
line 306 of /mod/scorm/locallib.php: call to scorm_parse_aicc()
line 168 of /mod/scorm/lib.php: call to scorm_parse()
line 127 of /course/modlib.php: call to scorm_add_instance()
line 157 of /course/modedit.php: call to add_moduleinfo()
×Output buffer: Notice: Undefined property: stdClass::$id in /var/www/mrhosts/CURRENT_MP2/mod/scorm/datamodels/aicclib.php on line 277 Notice: Undefined property: stdClass::$title in /var/www/mrhosts/CURRENT_MP2/mod/scorm/datamodels/aicclib.php on line 280
Our packages contain links to proprietary content that does not actually belong to us. So in order to "share here" the package we replaced the propriety stuff with just a URL and added that to the attachments. Everything else is the same. It is called AICC_Test_3.ZIP. Can this be helpful for review?
Looks like Jenna has also reported this here:
Jenna - would be good if you could get someone to test that change to see if it works for you!
OK - thanks Dan. If I get a moment, will aim to figure out situation with sortorder and offer up a formal patch in that tracker ticket.