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

SCORM bug - mdl_log.action cannot insert long action field

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.9.12
    • 1.9.13
    • SCORM
    • Debian lenny
    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE
    • Hide

      I don't have a SCORM package that reproduces this, but it should be sufficient to run through a standard SCORM package with developer debugging turned on on a Postgres db and make sure that no sql errors occur.

      This may need to be tested/verified by a developer.

      Show
      I don't have a SCORM package that reproduces this, but it should be sufficient to run through a standard SCORM package with developer debugging turned on on a Postgres db and make sure that no sql errors occur. This may need to be tested/verified by a developer.

    Description

      We have been seeing the following issues on our moodle 1.9.12 instance. The problem is that the "action" field of the mdl_log table is limited to 40 chars. This means that the below SQL is failing.

      Insert into log table failed at Thursday 12th of May 2011 12:00:41 PM.
      It is possible that your disk is full.

      The failed SQL is:

      INSERT INTO mdl_log (time, userid, course, ip, module, cmid, action, url, info)
      VALUES ('1305165641', '5', '1', '165.228.100.81', 'scorm', '11', 'trk: Clinical Management of the HPA Axis at: 1', 'view.php?id=11', 'cmi.core.score.raw => 0')

      We use postgres for our Moodle instances, this probably doesn't fire a bug with MySQL (which will sometimes just concatenate data to fit smaller data fields)

      Attachments

        Activity

          People

            danmarsden Dan Marsden
            andrew.boag Andrew Boag
            Sam Hemelryk Sam Hemelryk
            Rajesh Taneja Rajesh Taneja
            Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Sujith Haridasan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              1/Aug/11