Views:Base table or view not found: 1146 Table 'crm.faq_field_data' doesn't exist:

Created on 9 November 2024, about 1 month ago

1. Created a custom content entity type FAQ, used multiple versions, and did not create _field_data and _field_revision tables.
2. Add an entity reference field field_faq to the node entity and associate it with the FAQ entity.
3. In the views management interface/admin/structure/views/nojs/add-handler/content/page_1/relationship, associate the field_faq field,

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'crm.faq_field_data' doesn't exist: SELECT COUNT(*) AS "expression" FROM (SELECT 1 AS "expression" FROM "node_field_data" "node_field_data" INNER JOIN "users_field_data"

🐛 Bug report
Status

Active

Version

11.1 🔥

Component

views.module

Created by

🇨🇳China qiutuo

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @qiutuo
  • Please update the steps to reproduce starting with installing Drupal, so others can duplicate the bug, because this seems unusual and I think there are other factors leading to the bug that are not shown.

  • 🇳🇿New Zealand quietone

    Changes are made on on 11.x (our main development branch) first, and are then back ported as needed according to our policies.

Production build 0.71.5 2024