-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
2.0
-
None
-
Windows 2003, IIS, PHP, MSSQL 2005
-
Microsoft SQL
-
MOODLE_20_STABLE
I uploaded a new SCORM package, then it redirects to the display and shows this error.
Error reading from database
More information about this error
Debug info: The data types ntext and nvarchar are incompatible in the equal to operator.
SELECT id,title FROM mdl_scorm_scoes WHERE scorm = ? AND organization = ? AND launch = ? ORDER BY id
[array (
0 => '1',
1 => '',
2 => '',
)]
Stack trace:
- line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
- line 247 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
- line 699 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
- line 728 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
- line 1075 of \lib\dml\moodle_database.php: call to mssql_native_moodle_database->get_records_sql()
- line 1024 of \lib\dml\moodle_database.php: call to moodle_database->get_records_select()
- line 1115 of \lib\dml\moodle_database.php: call to moodle_database->get_records()
- line 727 of \mod\scorm\locallib.php: call to moodle_database->get_records_menu()
- line 89 of \mod\scorm\view.php: call to scorm_view_display()
To work around it i changed the column dbo.[mdl_scorm_scoes].[launch] from ntext to nvarchar(4000)
- duplicates
-
MDL-24027 Data type error when accessing SCORM Activity using MS SQL
-
- Closed
-