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

ludo.r’s picture

I just had the same issue after adding a second question to my quiz.

catproject’s picture

Version: 7.x-4.x-dev » 7.x-5.x-dev

i 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 .

zeezhao’s picture

Version: 7.x-5.x-dev » 7.x-4.x-dev

Please leave on 7.x-4.x-dev since that is current version with issue. Thanks

joemaine’s picture

...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).

joemaine’s picture

...has anyone tried the patch at http://drupal.org/node/1467754

joemaine’s picture

The patch at http://drupal.org/node/1467754 does appear to work against the dev release (2012-Mar-03)

kudos to amagdy

falcon’s picture

Status: Active » Fixed
ludo.r’s picture

Status: Fixed » Active

I 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.

zeezhao’s picture

Thanks for patch. Tried latest quiz & getting these errors against existing quizzes:

Notice: Undefined variable: data in include() (line 24 of ....\quiz\theme\quiz-results-browser-body.tpl.php). [when viewed]

Notice: Undefined index: #header in quiz_results_manage_results_form() (line 2137 of ...\quiz\quiz.admin.inc). [when looking at results]
ludo.r’s picture

No more luck after a new try.

This is how to reproduce :

  1. Install Quiz, Quiz Question and Quiz Multichoice
  2. Create a Quiz node
  3. Create a first multichoice question and attach it to the quiz we created in step 2
  4. Create a scond multichoice question and attach it to the quiz we created in step 2
  5. Error : PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '28-32-2-2' for key 'PRIMARY'
missym’s picture

I'm having the same issue.

Subscribe

spykid’s picture

subscribe

falcon’s picture

Status: Active » Postponed (maintainer needs more info)

I 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.

falcon’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)