-
Bug
-
Resolution: Fixed
-
Blocker
-
2.0.1
-
Microsoft SQL
-
MOODLE_20_STABLE
-
MOODLE_20_STABLE
-
Moderate
Debug info: SQLState: 42S22<br>
Error Code: 207<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'name'.<br>
SELECT q.* FROM (SELECT TOP 9223372036854775806 ROW_NUMBER() OVER(ORDER BY name, concept) AS sqlsrvrownumber, q.* FROM ( SELECT gec.id AS cid, ge.*, gec.entryid, gc.name AS glossarypivot FROM mdl_glossary_entries ge,
mdl_glossary_entries_categories gec,
mdl_glossary_categories gc WHERE (ge.glossaryid = '1' OR ge.sourceglossaryid = '1') AND
ge.id = gec.entryid AND gc.id = gec.categoryid AND
(ge.approved <> 0 OR ge.userid = '4') ) AS q) AS q WHERE q.sqlsrvrownumber > 0 AND q.sqlsrvrownumber <= 10
[array (
0 => '1',
1 => '1',
2 => '4',
)]
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 761 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
line 899 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
line 276 of \mod\glossary\sql.php: call to sqlsrv_native_moodle_database->get_records_sql()
line 371 of \mod\glossary\view.php: call to require()
- has a non-specific relationship to
-
MDL-26688 Get consistent results with out-of-range limit clauses under all databases
-
- Closed
-
- is duplicated by
-
MDL-25906 Error Reading Database - When logged in as admin unable to edit User Profile or retrieve logs after upgrade
-
- Closed
-
-
MDL-26139 Enabling Site News on Front Page causes an "error reading from database" message
-
- Closed
-
-
MDL-26971 Comments Plugin error "Invalid column name 'timecreated'"
-
- Closed
-
- will help resolve
-
MDL-26638 "Error reading from database" when deleting Course Categories under Site administration / Courses / Add/edit courses
-
- Closed
-