-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 3.6
-
Fix Version/s: 3.6.2
-
Component/s: Questions
-
Testing Instructions:
-
Affected Branches:MOODLE_36_STABLE
-
Fixed Branches:MOODLE_36_STABLE
-
Pull from Repository:
-
Pull 3.6 Branch:
MDL-64332_36 -
Pull 3.6 Diff URL:
-
Pull Master Branch:
-
Pull Master Diff URL:
Starting with Moodle 3.6, questions can have an ID number (which must be unique within a given category). This results in a bug when duplicating a question with an ID if the user forgets to give the duplicated question a different ID. I would have reported this in the tracker, but I've lost touch with it for a few years. I hope the info below will be useful for someone to create a bug report.
My original question had an ID number = 99.
Error writing to database
Debug info: Duplicate entry '2-99' for key 'mdl_ques_catidn_uix'
INSERT INTO mdl_question
etc.
Stack trace:
- line 489 of \lib\dml\moodle_database.php: dml_write_exception thrown
- line 1329 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 1375 of \lib\dml\mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 372 of \question\type\questiontypebase.php: call to mysqli_native_moodle_database->insert_record()
- line 273 of \question\question.php: call to question_type->save_question()
Note: First reported in the Quiz forum at https://moodle.org/mod/forum/discuss.php?d=379434#p1529695