After updating to 7.x-1.5 got the following when validating a webform:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'weight' in 'field list': SELECT ruleid, rulename, nid, validator, data, error_message, negate, weight FROM {webform_validation_rule} WHERE nid = :nid ORDER BY weight ASC, ruleid DESC; Array ( [:nid] => 11 ) in webform_validation_get_node_rules()(line 24 of /srv/bindings/268f9ed5eb2b47a4b1c40d75af4ec1ea/code/sites/all/modules/webform_validation/webform_validation.rules.inc).

Comments

Liam Morland’s picture

Please visit update.php to ensure that all update hooks have been run.

sbgranny’s picture

I think that was the issue. The error went away.

Liam Morland’s picture

Category: Bug report » Support request
Status: Active » Fixed

Great!

Status: Fixed » Closed (fixed)

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

helonaut’s picture

This didn't solve the problem for me. The update.php script says that there are no updates pending. I can see in the install file that there are two patches being executed: one for adding the weight field and one for adding an extra validator "someofseveral". But when I disable & enable the module, it shows an error that there's already a table in the database and that no modifications could be made.

The only approach that worked, was to apply the patch(es) manually. So for the weight field I executed the SQL:
ALTER TABLE `webform_validation_rule` ADD `weight` INT UNSIGNED NOT NULL DEFAULT '0'