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.