Table Missing Issue

  • Resolved proptrading

    (@proptrading)


    2 years, 10 months ago

    I was optimizing my site using Advanced Database Clean plugin. I mistakenly deleted some tables, only for me to see that my site has been broken as it shows the following errors below:

    “Error establishing a database connection”.

    After adding the following codes “define(‘WP_ALLOW_REPAIR’, true);” to myPhpAdmin as suggested by WordPress for repair, I still got the following errors:

    The wp**_options table is not okay. It is reporting the following error: Table '____wp***.wp**_options' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp**_options table. Error: Table '___wp***.wp**_options' doesn't exist

    The wp**_postmeta table is not okay. It is reporting the following error: Table '____wp***.wp**_postmeta' doesn't exist. WordPress will attempt to repair this table…
        Failed to repair the wp**_postmeta table. Error: Table '____wp***.wp**_postmeta' doesn't exist

    How can I fix this?

    Note, I have a backup but it is a week back.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    2 years, 10 months ago

    If you deleted tables, then you can’t repair them…. you can’t repair what’s not there. You’ll need to restore your database from a week back.

    Next time ( 🙂 ) make a backup before cleaning your database.

    Thread Starter proptrading

    (@proptrading)

    2 years, 10 months ago

    That is right, thank you for the advice.

    I have been able to fix it by restoring a backup.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Table Missing Issue’ is closed to new replies.