Moodle

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0
• Fix Version/s: 2.0
• Component/s: Quiz
• Labels:

  None

It has been noted that quiz reports/statistics can generate an sql error if there is an issue attempting to store a value that is Not A Number in the database. After discussing with tim, changes made to check revelant fields for NAN and replace by null.

sql query noted causing error:

INSERT INTO mdl_quiz_statistics ( ID, QUIZID, GROUPID, ALLATTEMPTS, TIMEMODIFIED, FIRSTATTEMPTSCOUNT, ALLATTEMPTSCOUNT, FIRSTATTEMPTSAVG, ALLATTEMPTSAVG, MEDIAN, STANDARDDEVIATION, CIC, ERRORRATIO, STANDARDERROR ) VALUES ( 182, 3418, 87398, 0, 1255266520, 108, 108, 0, 0, 0, 0, 114.28571428571, NAN, NAN )

Patch attached

1. 

   quizreportstatisticspatch

   14/Oct/09 12:37 AM

   1 kB

   Derek Woolhead

• Assignee:

  Tim Hunt

  Reporter:

  Derek Woolhead

  Tester:

  Nobody

  Participants:

  Derek Woolhead, Tim Hunt

• Created:

  14/Oct/09 12:37 AM

  Updated:

  13/Dec/10 6:38 PM

  Resolved:

  23/Feb/10 1:10 AM