Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-67466

AICC package gives error Error writing to database." ×Debug info: Column 'identifier' cannot be null

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.6.5
    • Fix Version/s: None
    • Component/s: SCORM
    • Labels:
    • Affected Branches:
      MOODLE_36_STABLE

      Description

      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. 

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            jlooney jenna
            Participants:
            Component watchers:
            Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated: