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).
CommentFileSizeAuthor
#2 2627660-update-for-wb1.4-1.patch1.01 KBtrgreen17

Comments

trgreen17 created an issue. See original summary.

trgreen17’s picture

Status: Active » Needs review
StatusFileSize
new1.01 KB

The attached patch resolves this DB issue