Database Error - Tables don't exist anymore

Hi

For some reason, on one of my websites, my tables seem to have just disappeared. The error I get is pasted below.

wpt5_users: Table 'qtsgloba_wp465.wpt5_users' doesn't exist
wpt5_usermeta: Table 'qtsgloba_wp465.wpt5_usermeta' doesn't exist
wpt5_posts: Table 'qtsgloba_wp465.wpt5_posts' doesn't exist
wpt5_comments: Table 'qtsgloba_wp465.wpt5_comments' doesn't exist
wpt5_links: Table 'qtsgloba_wp465.wpt5_links' doesn't exist
wpt5_options: Table 'qtsgloba_wp465.wpt5_options' doesn't exist
wpt5_postmeta: Table 'qtsgloba_wp465.wpt5_postmeta' doesn't exist
wpt5_terms: Table 'qtsgloba_wp465.wpt5_terms' doesn't exist
wpt5_term_taxonomy: Table 'qtsgloba_wp465.wpt5_term_taxonomy' doesn't exist
wpt5_term_relationships: Table 'qtsgloba_wp465.wpt5_term_relationships' doesn't exist
wpt5_commentmeta: Table 'qtsgloba_wp465.wpt5_commentmeta' doesn't exist

Is there a simple enough fix for this?

Thanks
Farzan

  • Nastia
    • Support Rock Star

    Hello Farzan,

    I'm sorry to hear you have this issue!

    Please let me know what changes you made to tables disappeared? These tables are the core fo the WordPress site installation. Have you edited the wp-config.php file or migrated your site to another location?

    Would you please access phpMyAdmin and check if actually, these tables do not exist?

    If you have a good backup of a database, try restoring it to resolve this issue. Because from the look of it something has deleted these tables.

    Please advise,

    Kind regards,
    Nastia

  • Sajid
    • DEV MAN’s Sidekick

    Hello Farzan Ahmed :slight_smile:

    Thanks for updated information but I don't think www could cause this issue except one thing that you are not using a different version of your site for www than non-www.

    That means, you may have two sites one for non-www that works fine and one for www that does not.

    If that is not the case, then I don't think we can do much here except advising you restoring to a reliable database backup.

    Best Regards,
    Sajid - WPMU DEV Support

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.