Support » Fixing WordPress » Website showing as normal BUT only two tables in database, rest is missing

  • A friends site is showing as normal, all is working in the front end and content is showing as normal. However when someone attempted to login it said that a database repair was required. We attempted to run this but it then stated that some of the tables within the database were missing. I logged in to phpmyadmin to confirm this and there are only two tables showing.

    How is this possible? and perhaps more importantly has anyone ever encountered this and come up with a solution. I tried a restore to a previous point with her hosting but it would seem this issue has been in place a long time.

    The wp_users table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_users' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_users table. Error: Table 'kerriskl_wrdp1.wp_users' doesn't exist
    The wp_usermeta table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_usermeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: Table 'kerriskl_wrdp1.wp_usermeta' doesn't exist
    The wp_posts table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_posts' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: Table 'kerriskl_wrdp1.wp_posts' doesn't exist
    The wp_comments table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_comments' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: Table 'kerriskl_wrdp1.wp_comments' doesn't exist
    The wp_links table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_links' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_links table. Error: Table 'kerriskl_wrdp1.wp_links' doesn't exist
    The wp_options table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_options' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table 'kerriskl_wrdp1.wp_options' doesn't exist
    The wp_postmeta table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_postmeta' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: Table 'kerriskl_wrdp1.wp_postmeta' doesn't exist
    The wp_terms table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_terms' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_terms table. Error: Table 'kerriskl_wrdp1.wp_terms' doesn't exist
    The wp_term_taxonomy table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_term_taxonomy' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_taxonomy table. Error: Table 'kerriskl_wrdp1.wp_term_taxonomy' doesn't exist
    The wp_term_relationships table is not okay. It is reporting the following error: Table 'kerriskl_wrdp1.wp_term_relationships' doesn't exist. WordPress will attempt to repair this table…
    Failed to repair the wp_term_relationships table. Error: Table 'kerriskl_wrdp1.wp_term_relationships' doesn't exist
    The wp_commentmeta table is okay.
    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
Viewing 1 replies (of 1 total)
  • Please is there anyone who can offer some advice? How can someone can advice on here?? Never managed it yet 🙁

Viewing 1 replies (of 1 total)
  • The topic ‘Website showing as normal BUT only two tables in database, rest is missing’ is closed to new replies.