Moodle Version 2.4, Win2003
We are getting this error and cannot seem to get rid of it. Unfortunately, we do not understand the Moodle schema completely to take concrete actions. It has temporarily worked when I removed some rows from mdl_question_attempt_steps but the error is back again so I need a permanent fix from someone who understands the DB schema. It looks like Moodle is trying to enter a duplicate index but w/o understanding of scehma, we are hesitant to take further actions.
The problem is probably a residue from our upgrade to 2.0 which went horribly. I read some forums but no one has good solution on how to fix it. Help please!
Debug info: Duplicate entry '9408-0' for key 'mdl_quesattestep_queseq_uix'
INSERT INTO mdl_question_attempt_steps (questionattemptid,sequencenumber,state,fraction,timecreated,userid) VALUES(?,?,?,?,?,?)
0 => 9408,
1 => 0,
2 => 'todo',
3 => NULL,
4 => 1362674639,
5 => '557',