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

Data type error when accessing SCORM Activity using MS SQL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 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

      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()

            danmarsden Dan Marsden
            richford Richard Ford (Inactive)
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.