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

Quiz Report: the quiz report do not find the first attempt

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9.1
    • Component/s: Quiz
    • Labels:
      None
    • Environment:
      WAMP + vista
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      Create a user
      Create a quiz
      Realise an attempt for this quiz
      Create another quiz (set grade on first attempt)
      Realise three attempts for this second quiz
      Display the second quiz report
      The first (neither the others) attempt is not highlighted. It should be.

      The executed request is (mod/quiz/report/overview/report.php):

      SELECT CONCAT( u.id, '#', IFNULL( qa.attempt, 0 ) ) AS uniqueid, (
      SELECT id
      FROM mdl_quiz_attempts
      WHERE u.id = userid
      ORDER BY timestart ASC
      LIMIT 1
      ) = qa.id AS gradedattempt, qa.uniqueid AS attemptuniqueid, qa.id AS attempt, u.id AS userid, u.idnumber, u.firstname, u.lastname, u.picture, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration
      FROM mdl_user u
      LEFT JOIN mdl_quiz_attempts qa ON qa.userid = u.id
      AND qa.quiz =2
      WHERE u.id
      IN ( 6, 7, 4 )
      AND qa.preview =0
      AND qa.id IS NOT NULL
      ORDER BY uniqueid

        Attachments

          Activity

            People

            • Assignee:
              jamiesensei Jamie Pratt
              Reporter:
              jerome Jérôme Mouneyrac
              Tester:
              Jérôme Mouneyrac
              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:
                15/May/08