-
Bug
-
Resolution: Fixed
-
Minor
-
2.1.3
-
Windows server 2008 R2, SQL Server 2005, IIS 7.5, Zend PHP 5.3.5
-
Microsoft SQL
-
MOODLE_21_STABLE
-
MOODLE_20_STABLE, MOODLE_21_STABLE, MOODLE_22_STABLE
-
-
Clicking the "Question" sort header in the list of questions while adding to a quiz causes Error reading from database.
using DB module sqlserv, debug message:
Question bank contents [Hide]
Category: Relational
Select a category:
Error reading from database
More information about this error
Debug info: SQLState: 42000<br>
Error Code: 169<br>
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.<br>
SELECT TOP 20 q.hidden, q.category, q.id, q.qtype, q.name, q.questiontext, q.questiontextformat FROM mdl_question q WHERE parent = 0 AND hidden = 0 AND q.category = '17' ORDER BY q.name ASC, q.qtype ASC, q.name ASC
[array (
0 => '17',
)]
Stack trace:
line 394 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 368 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
line 773 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
line 1135 of \question\editlib.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
line 1330 of \question\editlib.php: call to question_bank_view->load_page_questions()
line 1156 of \mod\quiz\editlib.php: call to question_bank_view->display_question_list()
line 458 of \mod\quiz\edit.php: call to quiz_question_bank_view->display()
- caused a regression
-
MDL-32168 Problem displaying the question bank
-
- Closed
-