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

sql error when opening a scorm package

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.2.5, 2.3.1, 2.4
    • Fix Version/s: 2.2.6, 2.3.3
    • Component/s: SCORM
    • Labels:
    • Database:
      Microsoft SQL
    • Testing Instructions:
      Hide

      With an MS SQL db
      add a SCORM to your course.
      log in as a student - enter the SCORM package and make sure no errors are displayed. The above error appears on the view.php page before actually entering the scorm package by hitting the "enter" button (but it may also appear in other places before the patch)

      Show
      With an MS SQL db add a SCORM to your course. log in as a student - enter the SCORM package and make sure no errors are displayed. The above error appears on the view.php page before actually entering the scorm package by hitting the "enter" button (but it may also appear in other places before the patch)
    • Affected Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE
    • Pull Master Branch:
      master_MDL-35123

      Description

      Opening a SCORM package results in the following exception (I use MS SQL as a MoodleDB and SQLSRV30 driver):

      error/invalidsqlsrvnativetype

      More information about this error

      Debug info:
      Error code: invalidsqlsrvnativetype
      $a contents: nchar
      Stack trace:
      line 663 of \lib\dml\sqlsrv_native_moodle_database.php: dml_exception thrown
      line 529 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->sqlsrvtype2moodletype()
      line 516 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_columns()
      line 1296 of \lib\dml\moodle_database.php: call to moodle_database->where_clause()
      line 653 of \mod\scorm\locallib.php: call to moodle_database->get_record()
      line 597 of \mod\scorm\locallib.php: call to scorm_get_last_attempt()
      line 1103 of \mod\scorm\locallib.php: call to scorm_grade_user()
      line 115 of \mod\scorm\view.php: call to scorm_get_attempt_status()

        Gliffy Diagrams

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/Nov/12