When trying to delete a content item I keep getting this error, and can't seem to delete the content item:

user warning: Out of range value adjusted for column 'sid' at row 1 query: INSERT INTO workflow_node_history (nid, old_sid, sid, uid, comment, stamp) VALUES (0, 0, -1, 2, 'Node deleted', 0) in C:\Apache2.2\htdocs\connections\includes\database.mysql.inc on line 172.

Any idea what it means? or how to fix it? I think it's related to workflow...

Comments

hillaryneaf’s picture

hillaryneaf commented
Category: bug » support

Changing to support request... may not be a bug just yet...

jvandyk’s picture

jvandyk commented
Category: support » bug

The sid column of workflow is 'unsigned' in the database. Clearly it should not be, since we are putting an -1 into it.

hillaryneaf’s picture

hillaryneaf commented
Category: bug » support
Status: Active » Closed (fixed)

I found this to be a problem with encoding... UTF-8/Unicode issue... not relevant to workflow

hillaryneaf’s picture

hillaryneaf commented
Status: Closed (fixed) » Active

I noticed I'm still having this issue... it does seem to be related to workflow.

"The sid column of workflow is 'unsigned' in the database"
How can I fix this?

jvandyk’s picture

jvandyk commented

You can fix it by issuing the following SQL to your database. I will get this rolled into an update.

ALTER TABLE workflow_node_history CHANGE sid sid INT( 10 ) NOT NULL DEFAULT '0'

shariharan’s picture

shariharan commented

user warning: Out of range value adjusted for column 'sid' at row 1 query: INSERT INTO workflow_node_history (nid, old_sid, sid, uid, comment, stamp) VALUES (900, 0, -1, 14, 'Node deleted', 0) in C:\Apache2.2\htdocs\mySite\includes\database.mysql.inc on line 172.

This is the error that I get.

EDIT: The error was fixed with the SQL above. -Thanks

jvandyk’s picture

jvandyk commented
Status: Active » Fixed
mengweifu1985’s picture

mengweifu1985 commented
Title: Out of range error? » Out of range error
Assigned: Unassigned » mengweifu1985
Priority: Normal » Minor
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.