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

SCORM modules dies when scorm_scoes empty

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9.1
    • Component/s: SCORM
    • Labels:
      None
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      Tracking down error:

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND attempt=1 ORDER BY element ASC' at line 1

      SELECT * FROM mdl7_scorm_scoes_track WHERE userid=1 AND scoid= AND attempt=1 ORDER BY element ASC

      • line 686 of lib/dmllib.php: call to debugging()
      • line 609 of lib/dmllib.php: call to get_recordset_sql()
      • line 930 of lib/dmllib.php: call to get_recordset_select()
      • line 263 of mod/scorm/locallib.php: call to get_records_select()
      • line 605 of mod/scorm/locallib.php: call to scorm_get_tracks()
      • line 59 of mod/scorm/view.php: call to scorm_simple_play()

      Notice: Trying to get property of non-object in /var/www/moodle/mod/scorm/locallib.php on line 606

      Warning: Cannot modify header information - headers already sent by (output started at /var/www/moodle/mod/scorm/locallib.php:604) in /var/www/moodle/mod/scorm/locallib.php on line 606

        Gliffy Diagrams

          Activity

          Hide
          poltawski Dan Poltawski added a comment -

          There was a bad check on the result of get_records_select (which was returning FALSE when empty). This then caused the bad sql. Now it displays fine

          Show
          poltawski Dan Poltawski added a comment - There was a bad check on the result of get_records_select (which was returning FALSE when empty). This then caused the bad sql. Now it displays fine
          Hide
          skodak Petr Skoda added a comment -

          verified closing

          Show
          skodak Petr Skoda added a comment - verified closing

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                15/May/08