Update Scanner settings when fields are deleted

Created on 30 August 2019, almost 5 years ago
Updated 29 April 2024, 2 months ago

I installed the module and am experiencing this error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'test_08302019.field_revision_field_learning_objectives' doesn't exist: SELECT t.field_learning_objectives_value AS content, t.delta AS delta, n.nid AS nid, n.title AS title FROM {field_revision_field_learning_objectives} t INNER JOIN {node} n ON t.revision_id = n.vid WHERE (n.type = :db_condition_placeholder_0) AND( (t.field_learning_objectives_value REGEXP :db_condition_placeholder_1) )AND (n.status = :db_condition_placeholder_2) ; Array ( [:db_condition_placeholder_0] => programs [:db_condition_placeholder_1] => www3 [:db_condition_placeholder_2] => 1 ) in scanner_execute() (line 878

The error references a table (field_revision_field_learning_objectives) that is not present in our database. I am wondering why it is expecting this table to be present? A string search of the entire database for that name returns nothing, so I can't find another table entry that references that specific table name.

✨ Feature request
Status

Active

Version

1.0

Component

User interface

Created by

πŸ‡ΊπŸ‡ΈUnited States brian_nsu

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • πŸ‡ΊπŸ‡ΈUnited States DamienMcKenna NH, USA

    It might be useful for the Scanner module to update its settings when fields are deleted, that way it doesn't try to scan tables for fields that no longer exist.

Production build 0.69.0 2024