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

SCORM AICC HACP package Exitau triggers warning when updating total_time

    XMLWordPrintable

Details

    • 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.

    Description

      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

      Attachments

        1. scorm.webm
          7.71 MB
          Ilya Tregubov

        Issue Links

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Clockify

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