Hi
i have to upgrade moodle 1.94+ to 2.2 and this error happens everytime, sometimes change the entry number but a cant continue
i try to delete the entries and the process continue to the next fail
on the fail 9, I´ve cancel the process, i restore the DB but the next time occurs on diffrent entry
sorry my english!!
Error writing to database
Debug info: Duplicate entry '81717-1' for key 2
INSERT INTO mdl_question_attempts (questionid,variant,behaviour,questionsummary,rightanswer,maxmark,minfraction,flagged,responsesummary,timemodified,questionusageid,slot) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => '1938',
1 => 1,
2 => 'deferredfeedback',
3 => '¿Cuál es la función del elemento de seguridad?',
4 => 'Ambas',
5 => '0.8000000',
6 => 0,
7 => 0,
8 => 'Reducir los riesgos',
9 => '1350589451',
10 => '81717',
11 => 1,
)]
INSERT INTO mdl_question_attempts (questionid,variant,behaviour,questionsummary,rightanswer,maxmark,minfraction,flagged,responsesummary,timemodified,questionusageid,slot) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)
[array (
0 => '1938',
1 => 1,
2 => 'deferredfeedback',
3 => '¿Cuál es la función del elemento de seguridad?',
4 => 'Ambas',
5 => '0.8000000',
6 => 0,
7 => 0,
8 => 'Reducir los riesgos',
9 => '1350589451',
10 => '81717',
11 => 1,
)]
Stack trace:
- line 397 of \lib\dml\moodle_database.php: dml_write_exception thrown
- line 973 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1015 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 300 of \question\engine\upgrade\upgradelib.php: call to mysqli_native_moodle_database->insert_record()
- line 254 of \question\engine\upgrade\upgradelib.php: call to question_engine_attempt_upgrader->insert_record()
- line 222 of \question\engine\upgrade\upgradelib.php: call to question_engine_attempt_upgrader->save_usage()
- line 177 of \question\engine\upgrade\upgradelib.php: call to question_engine_attempt_upgrader->convert_quiz_attempt()
- line 132 of \question\engine\upgrade\upgradelib.php: call to question_engine_attempt_upgrader->update_all_attempts_at_quiz()
- line 1112 of \mod\quiz\db\upgrade.php: call to question_engine_attempt_upgrader->convert_all_quiz_attempts()
- line 540 of \lib\upgradelib.php: call to xmldb_quiz_upgrade()
- line 271 of \lib\upgradelib.php: call to upgrade_plugins_modules()
- line 1437 of \lib\upgradelib.php: call to upgrade_plugins()
- line 269 of \admin\index.php: call to upgrade_noncore()