We are currently using the quiz to run our initial assessments for numeracy using a highly graphical drag and drop. This had been running fine in pilots. We then developed a php access violation on the server so moved moodle to a dedicated server with a clean install of IIS6, php 5 and mySQL 4.1, our moodle version is 1.6.4. The quiz tested fine and initially live until around id=1400 on the mdl_quiz_attempts table when on trying to start a quiz the users received an error that a quiz attempt could not be made. I found on the forums here a few posts and a bug on the tracker MDL-5468 with a status of closed, but I could not find any resolution for us from fixes there.
For now to get the quizzes operating, I have exported the mdl_quiz_attempts table to excel (which is a format our learning skills team can get their results) and then emptied it as there was reference to this and the uniqueid field being a problem on the forums and tracker. I have also turned on bug reporting in moodle and have the same insert error reported.
There has been 54 successful attempts on the quiz today since I took the above actions, but I have no idea if the same situation will occur
.Does anyone have any further ideas on this or any other possible fixes that I could have lined up in case this does happen again?
I would really like to get this fixed as there has been a great deal of work by teams in several departments into getting our initial assessements online and it would be a shame to have to revert to paper based at this stage. If anyone would be interested in seeing how we are using the drag and drop for this please contact me for guest access.
Thanks