-
Bug
-
Resolution: Fixed
-
Critical
-
2.0
-
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()