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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 1.9.1
    • 1.9
    • Quiz
    • None
    • WAMP + vista
    • MOODLE_19_STABLE
    • 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

            jamiesensei Jamie Pratt
            jerome Jérôme Mouneyrac
            Jérôme Mouneyrac Jérôme Mouneyrac
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              15/May/08