when i try to add something i get this error please help quickly
Error messagePDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '109-161-1-1' for key 'PRIMARY': INSERT INTO {quiz_node_relationship} (parent_nid, child_nid, child_vid, question_status, weight, max_score, parent_vid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6), (:db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20), (:db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27), (:db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34), (:db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41); Array ( [:db_insert_placeholder_0] => 109 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 1 [:db_insert_placeholder_6] => 161 [:db_insert_placeholder_7] => 109 [:db_insert_placeholder_8] => 9 [:db_insert_placeholder_9] => 9 [:db_insert_placeholder_10] => 9 [:db_insert_placeholder_11] => 9 [:db_insert_placeholder_12] => 9 [:db_insert_placeholder_13] => 161 [:db_insert_placeholder_14] => 109 [:db_insert_placeholder_15] => 1 [:db_insert_placeholder_16] => 1 [:db_insert_placeholder_17] => 1 [:db_insert_placeholder_18] => 1 [:db_insert_placeholder_19] => 1 [:db_insert_placeholder_20] => 161 [:db_insert_placeholder_21] => 109 [:db_insert_placeholder_22] => 1 [:db_insert_placeholder_23] => 1 [:db_insert_placeholder_24] => 1 [:db_insert_placeholder_25] => 1 [:db_insert_placeholder_26] => 1 [:db_insert_placeholder_27] => 161 [:db_insert_placeholder_28] => 109 [:db_insert_placeholder_29] => 9 [:db_insert_placeholder_30] => 9 [:db_insert_placeholder_31] => 9 [:db_insert_placeholder_32] => 9 [:db_insert_placeholder_33] => 9 [:db_insert_placeholder_34] => 161 [:db_insert_placeholder_35] => 109 [:db_insert_placeholder_36] => 1 [:db_insert_placeholder_37] => 1 [:db_insert_placeholder_38] => 1 [:db_insert_placeholder_39] => 1 [:db_insert_placeholder_40] => 1 [:db_insert_placeholder_41] => 161 ) in quiz_update_quiz_question_relationship() (line 1749 of /home/ganimhas/public_html/sites/all/modules/quiz/quiz.module).
Comments
Comment #1
zuernbernhard commentedsame problem here, very annoying :( using 7.4 not 7.5
Comment #2
royerd commentedSame issue here in the 7.4 dev version of March 3. There appeared to be a report of this in another issue and a patch, but it didn't help to solve. I'm not sure what to try next.
Comment #3
JoDa commentedHi there,
I had the same problem and got is solved with the patch found here: Multiple fixes by amagdy. The basic problem was to get the patch working. Here is how I got rid of the problem:
1. Uninstall all quiz components
2. remove the entire quiz folder form your drupal installation
3. Use the 7.4 dev version and the quiz.patch provided by amagdy
4. The GIT tool is not working as posted in the abovementioned post so you get to do it manually (takes about 10 minutes)
5. Look for "quiz.module" (Master), "quiz_question.module" in the "\question_types\quiz_question\" folder and "multichoice.classes.inc" in the "\question_types\multichoice\" folder.
6. Open up all files including the patch. Look for the lines and remove all - ones in the original files and place all + ones instead.
7. Do it very carefully.
8. If you are done, move all files to your installation again and hopefully it will work.
Hope you can solve your problem this way and I hope the developers solve these issues for the future. Furhtermore I would like to include in the question sections an image field. As visual as we are I like questions derived from inages or graphs so it would be nice to save time on the workarounds and have a real good mudule that includes all basic features. Thanks.
JoDa
Comment #4
falcon commentedMultiple fixes by amagdy has been commited