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

Data type error when accessing SCORM Activity using MS SQL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Database SQL/XMLDB, SCORM
    • Labels:
      None
    • Environment:
      MS Windows, Apache Web Server and Microsoft SQL database
    • Database:
      Microsoft SQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      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

              Assignee:
              danmarsden Dan Marsden
              Reporter:
              richford Richard Ford
              Tester:
              Nobody Nobody
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Damyon Wiese, Dan Marsden, Matteo Scaramuccia, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                24/Nov/10