Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-10006

No contents for moodle/mod/quiz/report.php?mode=overview&id=xxx

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8.1, 1.9
    • Component/s: Quiz
    • Labels:
      None
    • Environment:
      Gentoo Linux, Moodle 1.8+ (20070602)
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      The report creates with
      moodle/mod/quiz/report.php?mode=overview&id=xxx
      is empty. A php error is showed:

      Unknown column 'feedback' in 'order clause'
      SELECT CONCAT(u.id,'#', IFNULL(qa.attempt, 0) ) AS uniqueid, qa.uniqueid as attemptuniqueid, qa.id AS attempt, u.id AS userid, u.firstname, u.lastname, u.picture, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration , qf.feedbacktext FROM mdl_user u JOIN mdl_role_assignments ra ON ra.userid = u.id JOIN mdl_groups_members gm ON u.id = gm.userid JOIN mdl_quiz_attempts qa ON u.id = qa.userid AND qa.quiz = 58 JOIN mdl_quiz_feedback AS qf ON qf.quizid = 58 AND qf.mingrade display()

        Attachments

          Activity

            People

            • Assignee:
              timhunt Tim Hunt
              Reporter:
              mapelo Manuel Perez Lopez
              Tester:
              Nobody
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Jun/07