I have enabled all Workflow modules. Created and mapped workflow rules. When i try to create content i'm always getting
PDOException: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "site1_node_access_pkey": INSERT INTO site1_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); Array ( ) in node_access_write_grants() (line 3417 of /var/www/trg/modules/node/node.module).
When i disable workflow access module, im able to create content
please help
Comments
Comment #1
mmff CreditAttribution: mmff commentedHi,
@kdineshbe
I encountered exactly the same error. So, if you have found the solution, try to post it.
best regards,
Comment #2
adamtong CreditAttribution: adamtong commentedi encounter the same problem too!!!
please help
Comment #3
NancyDruIs this a duplicate of #1421518: PDOException: SQLSTATE[23000]: Duplicate entry in {node_access} table: when assigning a workflow to the node?
Comment #4
adamtong CreditAttribution: adamtong commentedI solved the problem with this patch:
http://drupal.org/node/1146244#comment-6644078
The reason of the access module break on "create" event when state change explained in the above node.
Comment #5
NancyDruSo this is a core issue?
Comment #6
adamtong CreditAttribution: adamtong commentedYes, I think so. it is mainly due to using rule to do some action and involve node_access. I am not sure whether it can be fine-tuned in the workflow access module.
from: http://drupal.org/node/1146244
Comment #7
Lostboy22 CreditAttribution: Lostboy22 commentedWas getting error w/ 7.x-1.0, was tired of "Strict warnings" so installed -dev 2013-02-06
Starting getting similar message ( PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ) to all content add (regardless of workflow and role) after adding the following rule:
Tweaked rule and error went away. Improved rule export is:
So: Don't "unpublish" a node that isn't "published".
Yes, same as #1421518: PDOException: SQLSTATE[23000]: Duplicate entry in {node_access} table: when assigning a workflow to the node
Hope this helps.
Comment #8
NancyDruThis is apparently fixed.