Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Duplicate
-
Affects Version/s: 2.1
-
Fix Version/s: None
-
Component/s: Quiz
-
Labels:None
-
Database:Oracle
-
Affected Branches: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.
Issue Links
| This issue duplicates: | ||||
| MDL-3030 | Late quiz attempts should be closed automatically |
|
|
|
By the way, what is the uniqueid mean in quiz_attempts, Tim?