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

The Quiz is closed, but some student still shows "attempt still in progress"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 2.1
    • None
    • Quiz
    • None
    • Oracle
    • MOODLE_21_STABLE

    Description

      The Quiz is closed already, but some student is still attempting:

      Many days have passed since the quiz is closed, but this student is "attemptstillinprogress".
      I checked the database table, found something really odd in table quiz_attempts:

      this student's attempt in quiz_attmepts

      select id,uniqueid,attempt,sumgrades,unix_to_date(timestart) timestart,
             unix_to_date(timefinish) timefinish,unix_to_date(timemodified) timemodified
      from m_quiz_attempts
      where quiz=169 and userid=415
      /
      	ID   UNIQUEID	 ATTEMPT  SUMGRADES TIMESTART		TIMEFINISH	    TIMEMODIFIED
      ---------- ---------- ---------- ---------- ------------------- ------------------- -------------------
             989	 1029	       2	  0 2011-10-21 09:20:28 1970-01-01 08:00:00 2011-10-21 09:30:01
             983	 1023	       1	  2 2011-10-21 08:15:42 2011-10-21 08:40:03 2011-10-26 09:07:29

      In fact, this student's second attempt has timefinish value equals 0. It seems when the quiz closed, is forget update some student's timefinish field. Why this will happen, I cann't figure out. Meanwhile, I found many other record that has timefinish equals 0. I think this is a bug.

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              luyanfei Yanfei Lu
              Tim Hunt, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: