- 🇺🇸United States amaisano Boston
Having the same problem with D10 Core Moderation module "Moderated Content" view, which is a Views revisions table. Same error.
Enabling TCA Node breaks the workbench landing page with an exception error
The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Workbench: Edits by user[workbench_edited]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'node_field_revision.tca_active' in 'where clause': SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "node_field_revision" "node_field_revision" LEFT JOIN "users_field_data" "users_field_data_node_field_revision" ON node_field_revision.uid = users_field_data_node_field_revision.uid LEFT JOIN "node_field_data" "node_field_data_node_field_revision" ON node_field_revision.vid = node_field_data_node_field_revision.vid AND node_field_data_node_field_revision.langcode = node_field_revision.langcode INNER JOIN "node_field_revision" "node_field_data_node_field_revision__node_field_revision" ON node_field_data_node_field_revision.vid = node_field_data_node_field_revision__node_field_revision.vid WHERE ((node_field_data_node_field_revision.uid = :node_field_data_uid_revision OR ((SELECT COUNT(DISTINCT vid) FROM "node_revision" nr WHERE nr.revision_uid = :node_field_data_uid_revision AND nr.nid = node_field_data_node_field_revision.nid) > 0))) AND (("node_field_revision"."tca_active" IS NULL) OR ("node_field_revision"."tca_active" = :db_condition_placeholder_0) OR ("node_field_revision"."type" IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5, :db_condition_placeholder_6, :db_condition_placeholder_7, :db_condition_placeholder_8, :db_condition_placeholder_9, :db_condition_placeholder_10, :db_condition_placeholder_11, :db_condition_placeholder_12, :db_condition_placeholder_13, :db_condition_placeholder_14, :db_condition_placeholder_15, :db_condition_placeholder_16))) AND ("node_field_data_node_field_revision"."type" IS NOT NULL)) "subquery"; Array ( [:node_field_data_uid_revision] => 411 [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => article [:db_condition_placeholder_2] => backgrounder [:db_condition_placeholder_3] => blog [:db_condition_placeholder_4] => data_chat [:db_condition_placeholder_5] => data_user_profile [:db_condition_placeholder_6] => event [:db_condition_placeholder_7] => external_resource [:db_condition_placeholder_8] => media [:db_condition_placeholder_9] => news_page [:db_condition_placeholder_10] => page [:db_condition_placeholder_11] => pathfinder_page [:db_condition_placeholder_12] => program [:db_condition_placeholder_13] => resource_spotlight [:db_condition_placeholder_14] => top_level_landing [:db_condition_placeholder_15] => tutorial [:db_condition_placeholder_16] => worldview_image_of_the_week ) in main() (line 19 of index.php).
Drupal\views\ViewExecutable->execute(NULL) (Line: 1454)
Drupal\views\ViewExecutable->render() (Line: 2460)
Drupal\views\Plugin\views\display\DisplayPluginBase->preview() (Line: 1662)
Drupal\views\ViewExecutable->preview('block_1', Array) (Line: 66)
Drupal\views\Element\View::preRenderViewElement(Array)
call_user_func_array(Array, Array) (Line: 101)
Drupal\Core\Render\Renderer->doTrustedCallback(Array, Array, 'Render #pre_render callbacks must be methods of a class that implements \Drupal\Core\Security\TrustedCallbackInterface or be an anonymous function. The callback was %s. See
https://www.drupal.org/node/2966725 →
', 'exception', 'Drupal\Core\Render\Element\RenderCallbackInterface') (Line: 772)
Drupal\Core\Render\Renderer->doCallback('#pre_render', Array, Array) (Line: 363)
Drupal\Core\Render\Renderer->doRender(Array) (Line: 435)
Drupal\Core\Render\Renderer->doRender(Array) (Line: 435)
Drupal\Core\Render\Renderer->doRender(Array, ) (Line: 201)
Drupal\Core\Render\Renderer->render(Array, ) (Line: 241)
Drupal\Core\Render\MainContent\HtmlRenderer->Drupal\Core\Render\MainContent\{closure}() (Line: 564)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 242)
Drupal\Core\Render\MainContent\HtmlRenderer->prepare(Array, Object, Object) (Line: 132)
Drupal\Core\Render\MainContent\HtmlRenderer->renderResponse(Array, Object, Object) (Line: 90)
Drupal\Core\EventSubscriber\MainContentViewSubscriber->onViewRenderArray(Object, 'kernel.view', Object)
call_user_func(Array, Object, 'kernel.view', Object) (Line: 142)
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch(Object, 'kernel.view') (Line: 163)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 80)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 46)
Drupal\redirect_after_login\RedirectMiddleware->handle(Object, 1, 1) (Line: 58)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 48)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 709)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
1. Install Workbench Module (also using workbench access on our site)
2. Navigate to /admin/workbench
3. Note the page functions
4. Install TCA Module
5. Enable TCA
6. Note that the workbench page still functions
7. Enable TCA_Node
8. Reload the page and observe the exception
No exception occurs
Postponed: needs info
1.0
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Having the same problem with D10 Core Moderation module "Moderated Content" view, which is a Views revisions table. Same error.