Moodle
  1. Moodle
  2. MDL-14050

SCORM modules dies when scorm_scoes empty

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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
    • Rank:
      30378

      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

        Activity

        Hide
        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
        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
        Petr Škoda added a comment -

        verified closing

        Show
        Petr Škoda added a comment - verified closing

          People

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

            Dates

            • Created:
              Updated:
              Resolved: