Hi there,

I have just updated this great module from an old dev version on my large site, however I got the following error during updating:

Update #1
ALTER TABLE {workflow_fields} ADD `rid` INT NOT NULL DEFAULT '-1'
ALTER TABLE {workflow_fields} DROP PRIMARY KEY
Failed: ALTER TABLE {workflow_fields} ADD PRIMARY KEY (sid, rid)
Update #2
ALTER TABLE {workflow_fields} ADD `visible_userref` VARCHAR(100) DEFAULT NULL
ALTER TABLE {workflow_fields} ADD `editable_userref` VARCHAR(100) DEFAULT NULL

Now, I get the following error when I go to my workflow, and all the permissions for every field have disappeared!

user warning: Unknown column 'visible' in 'field list' query: SELECT rid, visible, editable, visible_userref, editable_userref FROM workflow_fields WHERE sid=38 AND name='title' in /var/www/vhosts/euromedalex.org/httpdocs/sites/all/modules/workflow_fields/workflow_fields.module on line 92.

Any ideas if/how I rectify this and get my permissions back?

Thanks,

Adam

Comments

adshill’s picture

Title: Disaster! » Disaster Error on Update