The 'op' field in the assignment_triggers table can only hold a maximum of 32 characters. When, for example, assigning an action to a workflow state for content type named 'meeting_room_reservation', the data in 'op' field is not stored as 'workflow-meeting_room_reservation-12' but shortened to 'workflow-meeting_room_reservatio' (= 32 chars). Obviously the action will not work and database error ('duplicate entry') occurs when user tries to assign same/other action to workflow state of same content type.

In Drupal the content type name can be a maximum of 32 chars and therefore the 'op' field should allow way more than that for the add-ons (workflow, dashes, etc). My suggestion would be 48 characters.

This post discusses the same issue: http://groups.drupal.org/node/53228

Comments

vanvemden’s picture

vanvemden
Location San Francisco
commented

My bad, the 'op' field is in the 'trigger_assignments' table and not the 'assignment_triggers' table as mentioned above.

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.