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

SCORM AICC HACP package Exitau triggers warning when updating total_time

XMLWordPrintable

    • MOODLE_403_STABLE
    • MOODLE_403_STABLE
    • Hide

      MAKE SURE YOUR SERVER ALLOWS OUTGOING HTTP AND YOUR SITE USES A PUBLIC URL (not localhost or 192.168.x.x etc)

      NOTE: testing this requires access to a restricted AICC package which also needs your Moodle testing site added to a whitelist for it to function. (Ilya has this package and an internal HQ site that has been added to the allowlist, but Dan can organise further access if required.)

      Note: testing this requires developer debugging to be enabled and direct access to web server error logs (the error is not visible in the UI, only web server error logs.)

      go to admin > plugins > activity modules > SCORM
      make sure the setting "Enable direct AICC url" is set to "yes"
      make sure the setting "Enable external AICC HACP" is set to "yes"

      Create a new SCORM in your site - select the scormtype "external AICC URL" and use the private AICC testing url (ask Dan Marsden via chat for this detail)

      Login as a student and enter the SCORM package.
      Click on the "exit activity" link within the scorm to exit the activity
      Check the web server error logs and ensure you don't see the error ": ERROR: null value in column "userid" of relation "mdl_scorm_attempt" violates not-null constraint" in the error logs.

      Show
      MAKE SURE YOUR SERVER ALLOWS OUTGOING HTTP AND YOUR SITE USES A PUBLIC URL (not localhost or 192.168.x.x etc) NOTE: testing this requires access to a restricted AICC package which also needs your Moodle testing site added to a whitelist for it to function. (Ilya has this package and an internal HQ site that has been added to the allowlist, but Dan can organise further access if required.) Note: testing this requires developer debugging to be enabled and direct access to web server error logs (the error is not visible in the UI, only web server error logs.) go to admin > plugins > activity modules > SCORM make sure the setting "Enable direct AICC url" is set to "yes" make sure the setting "Enable external AICC HACP" is set to "yes" Create a new SCORM in your site - select the scormtype "external AICC URL" and use the private AICC testing url (ask Dan Marsden via chat for this detail) Login as a student and enter the SCORM package. Click on the "exit activity" link within the scorm to exit the activity Check the web server error logs and ensure you don't see the error ": ERROR: null value in column "userid" of relation "mdl_scorm_attempt" violates not-null constraint" in the error logs.

      When using an AICC HACP package and exiting the AICC package, the following warning is shown in the logs.
      default exception handler: Error writing to database Debug: ERROR: null value in column "userid" of relation "mdl_scorm_attempt" violates not-null constraint

      looks like an incorrect use of "userid" which should be $aiccuser->id instead.

      hard to test - we don't have any public HACP packages we can use for testing, but I'll see if I bundle this fix in with the work I'm doing on MDL-63539

            danmarsden Dan Marsden
            danmarsden Dan Marsden
            Jun Pataleta Jun Pataleta
            Andrew Lyons Andrew Lyons
            Ilya Tregubov Ilya Tregubov
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 50 minutes
                50m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.