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

Data type error when accessing SCORM Activity using MS SQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 2.0
    • 2.0
    • Database SQL/XMLDB, SCORM
    • None
    • MS Windows, Apache Web Server and Microsoft SQL database
    • Microsoft SQL
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE

    Description

      Having added a SCORM item to a course the following error occurs when that item is accessed.

      Error reading from database

      More information about this error

      Debug info: SQLState: 42000<br>
      Error Code: 402<br>
      Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The data types ntext and nvarchar are incompatible in the not equal to operator.<br>

      SELECT id FROM mdl_scorm_scoes WHERE scorm = 1 AND launch <> N'' ORDER BY id
      [array (
      0 => '1',
      1 => '',
      )]
      Stack trace:
      line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 252 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
      line 363 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
      line 757 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
      line 834 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
      line 1069 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_records_sql()
      line 818 of \mod\scorm\locallib.php: call to moodle_database->get_records_select()
      line 56 of \mod\scorm\view.php: call to scorm_simple_play()

      Attachments

        Issue Links

          Activity

            People

              danmarsden Dan Marsden
              richford Richard Ford
              Nobody Nobody
              David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo, Dan Marsden, Matteo Scaramuccia, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                24/Nov/10