What Should I do Next after Database Repair Results?

  • Resolved oreamnos

    (@oreamnos)


    9 years, 1 month ago

    Two question now:
    1. Should I now revert to my back up of the config file/remove the line of code I added?
    2. What does this result below mean, and do I need to take further action?

    My installation suddenly gave a database error, so I followed instructions to add line to config file, and ran the database repair and got this output, which it told me to come and post here. The site seems to be working despite the error messages below.

    wp_usermeta: 8 clients are using or haven’t closed the table properly
    wp_posts: 12 clients are using or haven’t closed the table properly
    wp_comments: 368 clients are using or haven’t closed the table properly
    wp_links: 2 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 4 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: 3 clients are using or haven’t closed the table properly
    wp_term_relationships: 4 clients are using or haven’t closed the table properly
    wp_commentmeta: 516 clients are using or haven’t closed the table properly

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    9 years, 1 month ago

    Would you please quote the database error you initially received?

    Thread Starter oreamnos

    (@oreamnos)

    9 years, 1 month ago

    “Error establishing a database connection”

    Then I tried to go to /wp-admin, it gave me instructions to modify the config file. So I did that, ran the repair as instructed and it resulted in the messages above.

    Then the site worked for a bit. Then got the same error again later, I repeated the process, and site worked again.

    I logged into cpanel and ran checks and repairs on both databases for the installation.

    Thanks for any help!

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    9 years, 1 month ago

    Ok, something is tanking the database.

    First, remove the modification you made to wp-config.php. Then, access your WordPress database via phpMyAdmin (most hosting providers offer this in their control panel), check all of the tables, and choose “Repair tables” from the pull-down menu.

    Once you’re back in, try deactivating all plugins for maybe the night (or however long it takes for the problem to usually re-appear). If that resolves the issue, reactivate each one individually until you find the cause.

    Thread Starter oreamnos

    (@oreamnos)

    9 years, 1 month ago

    Thank you for these troubleshooting steps!

    Thread Starter oreamnos

    (@oreamnos)

    9 years, 1 month ago

    I ran the repair table command on both databases, all tables selected, and the result was just OK for everything.

    I see that the plug-in Social Media Feather had an update available, I wonder if this related to the errors I posted above which seem to be about posts and comments…

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    9 years, 1 month ago

    That’s possible, maybe let the site run for the day without that plugin.

    Thread Starter oreamnos

    (@oreamnos)

    9 years, 1 month ago

    Thanks again! I’ll start a new thread if I can’t resolve with these tips.

    Moderator James Huff

    (@macmanx)

    Volunteer Moderator

    9 years, 1 month ago

    You’re welcome!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘What Should I do Next after Database Repair Results?’ is closed to new replies.