I have the newest version of workflow, and when adding a new workflow, I get these errors:

    • Warning: Duplicate entry '0' for key 1 query: INSERT INTO workflows (name, tab_roles) VALUES ('Instructor Validation', '')
      Warning: Duplicate entry '0' for key 1 query: INSERT INTO workflow_states (wid, state, weight, sysid, status) VALUES (0, '(creation)', -50, 1, 1)

    • The workflow is then not created. When the keys for the tables workflow, and workflow_states are set to AUTO_INCREMENT, then that seems to solve the problem. I used the following lines:

    ALTER TABLE workflows CHANGE wid wid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE workflow_states CHANGE sid sid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE workflow_transitions CHANGE tid tid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

    Comments

    jvandyk’s picture

    jvandyk commented
    Status: Active » Closed (duplicate)

    http://drupal.org/node/316246