I'm getting this error when i click on add to card button.

Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'barcelone.commerce_promotion' doesn't exist: SELECT "base_table"."promotion_id" AS "promotion_id", "base_table"."promotion_id" AS "base_table_promotion_i

Comments

dharmeshbarot created an issue. See original summary.

cilefen’s picture

cilefen commented
Status: Active » Postponed (maintainer needs more info)

This seems something to do with Drupal Commerce rather than Drupal Core. Drupal Core is properly reporting a missing table.

cilefen’s picture

cilefen commented
Related issues: +#3284816: Promotion table missing after install
dharmeshbarot’s picture

dharmeshbarot commented
Status: Postponed (maintainer needs more info) » Fixed

I just checked my database and a few tables are missing from the commerce_promotion module, so I made a new localhost website and install that module and exported those tables from the database, and imported them to my old website database which fixed my error.

quietone’s picture

quietone commented
Title: Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'barcelone.commerce_promotion' doesn't exist: SELECT "base_table"."promotion_id" AS "promotion_id", "base_table"."promotion_id" AS "base_table_promotion_i » Base table or view not found, Table 'barcelone.commerce_promotion' doesn't exist
Issue summary: View changes

Shortening the title

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.