Not sure if this is a bug or something I have not configured properly but when applicant sends application , it creates error with this message.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5-3-acl' for key 'PRIMARY': INSERT INTO {node_access} (nid, realm, gid, grant_view, grant_update, grant_delete) 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); Array ( [:db_insert_placeholder_0] => 5 [:db_insert_placeholder_1] => acl [:db_insert_placeholder_2] => 3 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 5 [:db_insert_placeholder_7] => content_access_rid [:db_insert_placeholder_8] => 30037204 [:db_insert_placeholder_9] => 1 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 5 [:db_insert_placeholder_13] => content_access_author [:db_insert_placeholder_14] => 4 [:db_insert_placeholder_15] => 1 [:db_insert_placeholder_16] => 0 [:db_insert_placeholder_17] => 0 ) in node_access_write_grants() (line 3440 of C:\Users\me\Desktop\recruiter-7.x-1.x-dev\modules\node\node.module).
. .

Comments

mh86’s picture

Status: Active » Fixed

You need to apply all patches, especially those (taken from the build and make files):

; CORE PATCHES
; node_access integrity constraint violation on module_invoke_all('node_' . $op, $node); http://drupal.org/node/1146244
; http://drupal.org/node/1146244#comment-6492226
projects[drupal][patch][] = "http://drupal.org/files/node_insert_save_d7_0.patch"

projects[content_access][version] = "1.x-dev"
; Node Access bug if core patch is applied http://drupal.org/node/1097248#comment-6613538
projects[content_access][patch][] = "http://drupal.org/files/1097248-content-access-node-grants-24.patch"

projects[profile2][version] = "1.x-dev"
; Add ctools relationship
projects[profile2][patch][] = "http://drupal.org/files/1011370-profile2-ctools.patch"

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.