Auto-repair tables debugging, please

  • Resolved Tim Morley

    (@tim-morley)


    10 years, 6 months ago

    My site was working for visitors, but when I tried to access /wp-admin, I got an error saying that there was a missing table.

    The message said if I add define('WP_ALLOW_REPAIR', true); to my wp-config.php it would attempt to auto-repair the problem. I did, but got these errors:

    wp_usermeta: 2 clients are using or haven’t closed the table properly
    wp_posts: 1 client is using or hasn’t closed the table properly
    wp_options: Table is marked as crashed
    wp_blogs: 1 client is using or hasn’t closed the table properly
    wp_sitemeta: 9 clients are using or haven’t closed the table properly

    For info, there is only ever one user — me?—?who edits the site.

    Two minutes later, the site works fine again, despite the above errors.

    What’s going on? Any help, or just URLs to relevant reading matter, will be much appreciated.

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

  • I would try to fully repair the database through something like phpMyAdmin if your web hosting provider includes it. Otherwise, contact them to help with this.

    Sometimes server level issues or code problems can cause issues like this.

    Thread Starter Tim Morley

    (@tim-morley)

    Thanks for the suggestion. As I said above, bizarrely the site suddenly worked again a couple of minutes later.

    I unintentionally re-visited the “table repair” URL (I closed my browser and re-launched it, which re-opened the page) and the second time it reported that all the tables were fine.

    Probably a server issue then (it’s on shared hosting, not under my control).

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Auto-repair tables debugging, please’ is closed to new replies.