There's an issue when you new questions to an already saved quiz node and click submit.
I get an PDOException:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '141-160-1-1' for key 'PRIMARY': INSERT INTO {quiz_node_relationship} (parent_nid, child_nid, child_vid, question_status, weight, max_score, parent_vid) VALUES ...
Comments
Comment #1
ludo.rI just had the same issue after adding a second question to my quiz.
Comment #2
catproject commentedi m facing the same problem as stated by you .
i need an urgent solution to this error in a day or two .
plz try n find out solution or develope a patch for the same .
Comment #3
zeezhao commentedPlease leave on 7.x-4.x-dev since that is current version with issue. Thanks
Comment #4
joemaine commented...yet another relationship error. Happens when trying to save after an edit to the quiz body or existing quiz settings. I can edit existing questions, but can't add a new one to the quiz. These are the installed quiz modules (Quiz, Quiz Question, Quiz Multichoice, True False).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '9-16-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] => 9 [:db_insert_placeholder_1] => 9 [:db_insert_placeholder_2] => 9 [:db_insert_placeholder_3] => 9 [:db_insert_placeholder_4] => 9 [:db_insert_placeholder_5] => 9 [:db_insert_placeholder_6] => 16 [:db_insert_placeholder_7] => 9 [:db_insert_placeholder_8] => 1 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => 1 [:db_insert_placeholder_13] => 16 [:db_insert_placeholder_14] => 9 [: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] => 16 [:db_insert_placeholder_21] => 9 [: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] => 16 [:db_insert_placeholder_28] => 9 [:db_insert_placeholder_29] => 0 [:db_insert_placeholder_30] => 0 [:db_insert_placeholder_31] => 0 [:db_insert_placeholder_32] => 0 [:db_insert_placeholder_33] => 0 [:db_insert_placeholder_34] => 16 [:db_insert_placeholder_35] => 9 [: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] => 16 ) in quiz_update_quiz_question_relationship() (line 1749 of /home/my site/public_html/sites/all/modules/quiz/quiz.module).
Comment #5
joemaine commented...has anyone tried the patch at http://drupal.org/node/1467754
Comment #6
joemaine commentedThe patch at http://drupal.org/node/1467754 does appear to work against the dev release (2012-Mar-03)
kudos to amagdy
Comment #7
falcon commentedhttp://drupal.org/node/1467754 has been commited
Comment #8
ludo.rI just got the same issue again, using the last dev version (2012-Apr-04).
I will give it a try again by uninstalling module and reinstall, but it seems this issue is not resolved.
Comment #9
zeezhao commentedThanks for patch. Tried latest quiz & getting these errors against existing quizzes:
Comment #10
ludo.rNo more luck after a new try.
This is how to reproduce :
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '28-32-2-2' for key 'PRIMARY'Comment #11
missym commentedI'm having the same issue.
Subscribe
Comment #12
spykid commentedsubscribe
Comment #13
falcon commentedI tried to reproduce #10 without success.
Please try again on alpha 2. (Alpha 2 is coming up soon...)
Also please provide the complete error message if you still get the error.
Comment #14
falcon commented