1146 Table 'website_drupal.background_image' doesn't exist

Created on 1 April 2021, about 3 years ago
Updated 29 May 2024, 25 days ago

Problem/Motivation

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'website_drupal.background_image' doesn't exist: SELECT "base_table"."bid" AS "bid", "base_table"."bid" AS "base_table_bid" FROM {background_image} "base_table" INNER JOIN {background_image_field_data} "background_image_field_data" ON [background_image_field_data].[bid] = [base_table].[bid] WHERE ("background_image_field_data"."type" IN (:db_condition_placeholder_0)) AND ("background_image_field_data"."default_langcode" IN (:db_condition_placeholder_1)); Array ( [:db_condition_placeholder_0] => -1 [:db_condition_placeholder_1] => 1 ) in Drupal\Core\Entity\EntityStorageBase->loadByProperties() (line 572 of core/lib/Drupal/Core/Entity/EntityStorageBase.php).

Steps to reproduce

Drupal 9.1.5

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Postponed: needs info

Version

2.0

Component

Code

Created by

🇮🇹Italy dantesp

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 rex.barkdoll

    We're on D10 and are getting this error too. It's crashed the site.

    In order to temporarily fix the problem, I had to go into PHPmyadmin, add a table to my database named 'background_image' with an INT column named 'bid'

    At that point, I could use Drush to uninstall the module and my website went back to being functional.

  • Status changed to Postponed: needs info 25 days ago
  • 🇦🇺Australia Nigel Cunningham Geelong

    Thanks for the report and sorry that it has taken so long to respond.

    Were you able to identify a set of steps to reproduce the issue?

Production build 0.69.0 2024