XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Not a bug
    • Icon: Minor Minor
    • None
    • 2.0
    • Quiz
    • 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()

            jamiesensei Jamie Pratt (Inactive)
            pgb Philip Butcher (Inactive)
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.