Table doesn't exist Print

  • troubleshooting, wordpress, database, phpmyadmin, backup, restore, plugins, woocommerce, errors
  • 0

A table is missing from the database.

WHAT IT MEANS

The database exists and connects, but a table the application needs is absent.

THE COMMON CAUSES

An incomplete import, frequently from a timed-out export A table prefix mismatch between the configuration and the actual tables An incomplete installation A table dropped in error

CHECKING THE PREFIX

In phpMyAdmin, look at the actual table names. In WordPress they typically begin wp_ but the prefix is configurable.

Compare against the prefix in the configuration file. A mismatch produces this on every table.

CHECKING FOR AN INCOMPLETE IMPORT

Count the tables. A WordPress site has a known minimum; considerably fewer suggests the import stopped partway.

Open the SQL file and check it ends cleanly rather than stopping mid-statement.

RE-IMPORTING

Drop all tables and import again, using the command line for anything large. phpMyAdmin times out on big files.

IF ONE TABLE IS MISSING

A plugin may recreate its own table on reactivation. Try deactivating and reactivating it.

Otherwise restore from a backup.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot