Bug trying to add aicc content. I saw other posts about it in Moodle forums. Trying to add an 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(?,?,?,?,?,?,?,?)
|
[array (
|
0 => NULL,
|
1 => '47',
|
2 => '',
|
3 => NULL,
|
4 => '/',
|
5 => '',
|
6 => '',
|
7 => 1,
|
)]
|
Error code: dmlwriteexception
|
×Stack trace:
|
line 489 of /lib/dml/moodle_database.php: dml_write_exception thrown
|
line 1362 of /lib/dml/my[sql|https://moodle.org/mod/glossary/showentry.php?eid=6851&displayformat=dictionary]i_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
|
- The package itself contains the required .au, .crs, .cst and .des files. I opened and unzipped them and examined the contents
- I used scorm checker (scorm cloud) and get it to pass validation and the AICC package loads as expected. And I can work through it.
Workaround:
- If I download the AICC package, unzip it and then use notepad or a similar program to open up the .au file > there you will see these bits of info that allow me to use the direct aicc url option. If you open up the .au file you will see these bits of info spread within the contents ( filename and weblaunch were the labels of the info we used and got working for one of the AICC packages example: course.au file contents
"System_ID","Core_Vendor","File_name","Web_Launch"
"C7","","https://fakeurlhere.com","FAKE=FAKE"
So you'd copy:
https://fakeurlhere.com
and
FAKE=FAKE
put together with a ? in the middle
_https://fakeurlhere.com?FAKE=FAKE_
and then enable the direct aicc url option and then add a new SCORM package, select direct aicc url and be sure HACP setting to Yes, the package will work
due to proprietary content the package details above are similar, but not an actual link.
- is duplicated by
-
MDL-82402 AICC Package returns Column 'identifier' cannot be null
- Closed