database problem cannot be repaired

  • Hi, my website faced an “Error Establishing a Database Connection” issue suddenly. I am trying to use built-in way to repair my database, and I got the information as blew:

    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.

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 2 clients are using or haven’t closed the table properly
    wp_posts: 2 clients are using or haven’t closed the table properly
    wp_comments: 1 client is using or hasn’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 2 clients are using or haven’t closed the table properly
    wp_terms: 1 client is using or hasn’t closed the table properly
    wp_term_taxonomy: 2 clients are using or haven’t closed the table properly
    wp_term_relationships: 2 clients are using or haven’t closed the table properly

    Could someone help me with this? Thanks a lot!

    • This topic was modified 8 years, 6 months ago by Jan Dembowski.
Viewing 2 replies - 1 through 2 (of 2 total)

  • I couldn’t find that error in WordPress core, so it looks like it may be a plugin issue.

    Try manually resetting your plugins (no Dashboard access required). If that resolves the issue, reactivate each one individually until you find the cause.

    If that does not resolve the issue, access your server via SFTP or FTP, or a file manager in your hosting account’s control panel, navigate to /wp-content/themes/ and rename the directory of your currently active theme. This will force the default theme to activate and hopefully rule-out a theme-specific issue (theme functions can interfere like plugins).

    To fix this

    I accessed phpMyAdmin, Selected the database, Selected the table that needed repairing and at the bottom it asks “With selected:” Just select repair.

    I did this with all of the table entries mentioned and all is working again.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘database problem cannot be repaired’ is closed to new replies.