-
Bug
-
Resolution: Duplicate
-
Minor
-
None
-
2.1
-
None
-
Oracle
-
MOODLE_21_STABLE
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.
- duplicates
-
-
- Closed
-