PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '50-53-4-4' 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] => 50 [:db_insert_placeholder_1] => 5 [:db_insert_placeholder_2] => 5 [:db_insert_placeholder_3] => 5 [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => 5 [:db_insert_placeholder_6] => 53 [:db_insert_placeholder_7] => 50 [:db_insert_placeholder_8] => 4 [:db_insert_placeholder_9] => 4 [:db_insert_placeholder_10] => 4 [:db_insert_placeholder_11] => 4 [:db_insert_placeholder_12] => 4 [:db_insert_placeholder_13] => 53 [:db_insert_placeholder_14] => 50 [:db_insert_placeholder_15] => 4 [:db_insert_placeholder_16] => 4 [:db_insert_placeholder_17] => 4 [:db_insert_placeholder_18] => 4 [:db_insert_placeholder_19] => 4 [:db_insert_placeholder_20] => 53 [:db_insert_placeholder_21] => 50 [: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] => 53 [:db_insert_placeholder_28] => 50 [: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] => 53 [:db_insert_placeholder_35] => 50 [:db_insert_placeholder_36] => 5 [:db_insert_placeholder_37] => 5 [:db_insert_placeholder_38] => 5 [:db_insert_placeholder_39] => 5 [:db_insert_placeholder_40] => 5 [:db_insert_placeholder_41] => 53 ) in quiz_update_quiz_question_relationship() (line 1749 of /public_html/sites/all/modules/quiz/quiz.module).

Comments

falcon’s picture

Priority: Critical » Major
Status: Active » Postponed (maintainer needs more info)

I'm not able to reproduce this one on the latest release

shaun873’s picture

Component: Miscellaneous » Code - Quiz core

I'm also getting this error on 7.x-4.x-dev

1) Create a new quiz
2) "Manage Questions"
3) Add an existing question to the quiz
4) "Submit"
5) Remove a question from quiz
6) "Submit" - gives error as below.

Please supply a valid date.
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '344-361-3-3' 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,

344 is my quiz node id. 361 I guess is the quiz vid. Not sure about the 3-3.

falcon’s picture

Priority: Major » Normal
Status: Postponed (maintainer needs more info) » Active
djdevin’s picture

Issue summary: View changes
Status: Active » Closed (cannot reproduce)