After updating from 7.x-1.3 to 7.x-3.0 i receive the following errors:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm.is_current' in 'where clause': SELECT m.*, r.title AS title, r.timestamp AS timestamp FROM {node_revision} r LEFT OUTER JOIN {workbench_moderation_node_history} m ON r.vid = m.vid WHERE (r.nid = :db_condition_placeholder_0) AND (m.is_current = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 108 [:db_condition_placeholder_1] => 1 ) in workbench_moderation_node_data() (line 1236 of /sites/all/modules/contrib/workbench_moderation/workbench_moderation.module).

Comments

blu_regard created an issue. See original summary.

daniel.rolls@flightcentre.com.au’s picture

Status: Active » Closed (works as designed)

Thought I'd close this off as this is just a case of needing to run updates, either:

Visiting:
/update.php

or running:

drush updb

When you do one of the updates will fix this (7010):

 ...
 Workbench_moderation  7010  Comply with SQL-99:  Rename the 'current' column to 'is_current'.
 Workbench_moderation  7300  Enable the Drafty module, a new dependency.
Vardhan400’s picture

Running /update.php resulting in the following error

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.name' in 'field list': SELECT t.from_name AS from_name, t.to_name AS to_name, t.name AS name FROM {workbench_moderation_transitions} t WHERE (from_name = :db_condition_placeholder_0) AND (to_name = :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => draft [:db_condition_placeholder_1] => needs_review ) in workbench_moderation_transitions_features_export_render() (line 127 of /Users/var/Desktop/workbench/test/docroot/sites/all/modules/contrib/workbench_moderation/workbench_moderation.features.inc).

Any Solution on this?