-
Sub-task
-
Resolution: Not a bug
-
Minor
-
None
-
2.0
-
None
-
MOODLE_20_STABLE
OU Moodle with September 2008 reports
I went to another of my test courses and it would not show any detailed responses. The error I see when selecting the Responses link is
ERROR: syntax error at or near "{" at character 941
SELECT ''||u.id||'#'||COALESCE(qa.attempt, '0') AS concattedid, (CASE WHEN qa.sumgrades = (SELECT MAX(qa2.sumgrades) FROM dev_quiz_attempts qa2 WHERE qa2.quiz = qa.quiz AND qa2.userid = qa.userid) AND qa.timestart = (SELECT MIN(qa3.timestart) FROM dev_quiz_attempts qa3 WHERE qa3.quiz = qa.quiz AND qa3.userid = qa.userid AND qa3.sumgrades = qa.sumgrades) THEN 1 ELSE 0 END) AS gradedattempt, qa.uniqueid, qa.id AS attempt, u.id AS userid, u.idnumber, u.firstname, u.lastname, u.institution, u.department, u.email, u.picture, u.imagealt, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration, qa.layout , qs299.grade AS qsgrade299, qs299.answer AS qsanswer299, qs299.event AS qsevent299, qs299.id AS qsid299, qs289.grade AS qsgrade289, qs289.answer AS qsanswer289, qs289.event AS qsevent289, qs289.id AS qsid289 FROM dev_user u LEFT JOIN dev_quiz_attempts qa ON qa.userid = u.id AND qa.quiz = 2 LEFT JOIN
{question_sessions} qns299 ON qns299.attemptid = qa.uniqueid AND qns299.questionid = 299 LEFT JOIN {question_states} qs299 ON qs299.id = qns299.newgraded LEFT JOIN {question_sessions}qns289 ON qns289.attemptid = qa.uniqueid AND qns289.questionid = 289 LEFT JOIN
{question_states}qs289 ON qs289.id = qns289.newgraded WHERE qa.id IS NOT NULL AND qa.preview = 0 ORDER BY qsanswer299 ASC, qsanswer289 ASC
- line 796 of lib/dmllib.php: call to debugging()
- line 1088 of lib/dmllib.php: call to get_recordset_sql()
- line 1812 of lib/tablelib.php: call to get_records_sql()
- line 211 of mod/quiz/report/responses/responses_table.php: call to table_sql->query_db()
- line 1832 of lib/tablelib.php: call to quiz_report_responses_table->query_db()
- line 322 of mod/quiz/report/responses/report.php: call to table_sql->out()
- line 118 of mod/quiz/report.php: call to quiz_responses_report->display()
- is duplicated by
-
MDL-16503 Error when clicking on question number at head of a column
-
- Closed
-