1146 Table 'website_drupal.background_image' doesn't exist

Created on 1 April 2021, over 3 years ago
Updated 21 March 2024, 9 months 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

Active

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 7 months ago
  • 🇦🇺Australia nigelcunningham 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?

  • 🇺🇸United States rex.barkdoll

    I wasn't but we've just taken to not using the module for the time being. We may come back around to it later. I'm also not the OP, so maybe they saw something we didn't.

  • 🇦🇺Australia nigelcunningham Geelong

    Thanks!

  • 🇦🇺Australia nigelcunningham Geelong

    I have a rewrite in progress; the background image entity type won't be used when it's finished (Context reactions instead).

Production build 0.71.5 2024