Hey, I'm testing the workflow module on my site, and I'm having a problem with it that I hope one of you can help me with.

I'm using Drupal 5.6 , Workflow 5.x-2.3, Workflow access 5.x-2.3, Actions 5.x-2.6, Trigger Unlock 6.x-1.0 (which can supposedly work with Drupal 5).

I set up five workflow states for one of my content types, called "Press Releases". The assigned actions for each transition is to change the workflow state, and to publish or unpublish the node.

When I try to create a new Press Release, it hangs after I hit Submit. If I go look at the content menu, I see that it's created the node, but only the title is there. The rest of the content is missing. If I try to update that node, I get the same problem when I hit Submit. When I try to delete that incomplete node, it'll allow me to delete, but I get the following error message:

user warning: Out of range value adjusted for column 'sid' at row 1 query: _workflow_write_history INSERT INTO workflow_node_history (nid, old_sid, sid, uid, comment, stamp) VALUES (17074, 11, -1, 8, 'Node deleted', 0) in F:\Program Files\Apache Software Foundation\Apache2.2\htdocs\includes\database.mysql.inc on line 172.

This problem didn't exist before I set up the workflow, and it doesn't exist for any other content type. I disabled and uninstalled Workflow, Workflow Access, Actions, and Trigger Unlock, yet I'm still unable to create any Press Release content.

I would appreciate any help you can provide.

Thanks
David

Comments

jvandyk’s picture

jvandyk commented

Go to your database. Change the attribute of the sid column of the workflow_node_history table so that it is no longer "unsigned".

dwhite10701’s picture

dwhite10701 commented

Thank you jvandyk. I made that change, and while I no longer get an error when deleting a Press Release node, I still have the same problem with the page hanging when I try to create a node.

hanat’s picture

hanat commented

We are experiencing something similar with getting the blank page after submitting. We are on Drupal 5-3 with Actions 5.x-1.x-dev and Workflow 5.x-1.1. I tried upgrading TO Drupal 5-12 with Actions 5.x-2.6 and Workflow 5.x-2.3, the same modules as you. After the upgrade, when I create a new content page and press Submit, the page is blank but the content is still saved though. When I edit an existing page, it works fine.

I then decided to go back to my original Drupal 5-3 and then upgrade the modules in baby steps. Upgraded Actions to 5.x-2.6 (also installed the node.module.patch). Creating a new content page works. I do not get the blank page. All is well.

So I proceed to upgrade Workflow to 5.x-2.3. It's after this that the new contact page's submit is blank. (but the content is saved) I have cleared cache and deleted the blank extra line in the template.php file for Garland theme, just in case it makes a difference.

While I am not actually receiving an error message when I submit the Content Page, when I go to the main page (or just another page), I will receive this error message:

warning: array_merge() [function.array-merge]: Argument #2 is not an array in /users/iststafft/apache2/https-ist-staff-test/drupal-5.3new/sites/all/modules/actions/actions.inc on line 98.

If I hit refresh on that main page (or whatever page I am on), the error does not appear again.

Bastlynn’s picture

Bastlynn commented
Status: Active » Closed (won't fix)

Hi,

With the release of Drupal 7, Drupal 5 is no longer receiving security updates, reviews, or development from many contributed modules. Since 5 is now considered a depreciated version, you really should seriously look into upgrading to Drupal 6 or 7. The newer versions of Drupal work better, have more support, and will be safer (literally! security patches!) for your website. We are currently working on a new release for Workflow to Drupal 7. In light of that, further support for Drupal 5 issues is infeasible at the moment. Please consider upgrading to Drupal 6 or 7 in the near future - you'll be glad you did.

- Bastlynn