When enabling the Webform Validation Module in a Drupal 7 website, the following error code was received after attempting to delete a node (page):

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] => 61 ) in webform_validation_get_node_rules() (line 24 of /home/mperform/public_html/sites/all/modules/webform_validation/webform_validation.rules.inc).

Disabling the Webform Validation module solved the problem, at least as being able to delete pages is concerned.

Comments

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland commented

Have you run update.php? You are missing a database column.

spanzers’s picture

spanzers CreditAttribution: spanzers commented

We're having the same issue and our databases are up to date. Running updatedb shows no updates needed.

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland commented

I don't know how that could happen. A fresh install should create the column or webform_validation_update_7105() should have created it. To fix it, you'll need to create the column, either manually or by running webform_validation_update_7105().

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland commented
Status: Active » Postponed (maintainer needs more info)

I cannot work on fixing this without steps to reproduce the problem.

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

If you are still having problems, please re-open and provide steps to reproduce.