When using Workbench 1.4 and trying to access the /admin/content/content-revisions page, the following database error occurs:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wmh.current' in 'on clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {node} n INNER JOIN {node_revision} nr ON n.nid = nr.nid INNER JOIN {workbench_moderation_node_history} wmh ON wmh.vid = nr.vid AND wmh.current + wmh.published > 0 AND wmh.state = :state) subquery; Array ( [:state] => draft ) in PagerDefault->execute() (line 74 of /var/www/vz-portal/includes/pager.inc).
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 2627660-update-for-wb1.4-1.patch | 1.01 KB | trgreen17 |
Comments
Comment #2
trgreen17 commentedThe attached patch resolves this DB issue