-
Bug
-
Resolution: Fixed
-
Blocker
-
None
-
2.0.3
-
None
-
IIS 7 running on Windows Server 2008 standard. Our database is MS SQL Server 2005. PHP version 5.3.4
-
MOODLE_20_STABLE
We have installed the community hub and have come across this problem when searching for courses to download from our hub. We have been able to register sites to our hub, upload courses to our hub and everything worked well until we search for available courses to download. The following error is returned.
Default exception handler: Error reading from database Debug: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
SELECT * FROM hubmdl_hub_course_outcomes WHERE courseid = ? ORDER BY outcome ASC
[array (
0 => '6',
)]
- line 394 of \lib\dml\moodle_database.php: dml_read_exception thrown
- line 255 of \lib\dml\mssql_native_moodle_database.php: call to moodle_database->query_end()
- line 710 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->query_end()
- line 739 of \lib\dml\mssql_native_moodle_database.php: call to mssql_native_moodle_database->get_recordset_sql()
- line 1112 of \lib\dml\moodle_database.php: call to mssql_native_moodle_database->get_records_sql()
- line 1061 of \lib\dml\moodle_database.php: call to moodle_database->get_records_select()
- line 859 of \local\hub\lib.php: call to moodle_database->get_records()
- line 570 of \local\hub\lib.php: call to local_hub->get_course_outcomes()
- line 206 of \local\hub\admin\managecourses.php: call to local_hub->get_courses()
Appreciate any help you may have.