After i did add my workflow state to some existing content types i want to assign workflow triggers but then i get the following error:

user warning: Duplicate entry 'workflow-workflow-nieuwsbericht_algemeen--node_publish_action' for key 'PRIMARY' query: INSERT INTO trigger_assignments values ('workflow', 'workflow-nieuwsbericht_algemeen-16', 'node_publish_action', 1) in /modules/trigger/trigger.admin.inc on line 205.
user warning: Duplicate entry 'workflow-workflow-nieuwsbericht_algemeen--node_save_action' for key 'PRIMARY' query: INSERT INTO trigger_assignments VALUES ('workflow', 'workflow-nieuwsbericht_algemeen-16', 'node_save_action', 2) in /modules/trigger/trigger.admin.inc on line 215.

The weird thing is that the content type i tested with is working fine...Now i'm really confused!

Best regards,
Henk

Comments

henkit’s picture

henkit commented

yes yes yes....found it :)

Short version: the content type i tested with has a very short name, the other content types have much longer names...in the database i noticed that he table "trigger_assignments" was a varchar 32 type...i changed that to 255 and now the triggers do work!

johnv’s picture

johnv
Primary language Dutch
commented
Title: Duplicate entry » Duplicate entry in {trigger_assignments} when content type has long name.
Component: Miscellaneous » Workflow Actions
Issue summary: View changes
Status: Active » Closed (works as designed)

The problem you describe is explained in the README.txt file:
http://drupalcode.org/project/workflow.git/blob/d5390050098e4620b904b0f7...