Database Error issue on several websites

  • Hello, I have been having this issue pop up randomly with several websites I manage. Where I get a database connection error and have to use the database repair function that appears on the admin login page where I have to add define(‘WP_ALLOW_REPAIR’, true); to the wp-config.php file to run the repair. After initiating the database repair I get the following message that says repairs could not be made and says to report the following in the forum.

    wp83_options: Number of rows changed from 0 to 358

    Here is a quick screenshot of this issue that occurred with another site as well.
    https://recordit.co/cw6MYeRmun

    The website comes back up after running the repair, but I am just left wondering why this is occurring, is it still a looming issue and what can I do to prevent it from happening to many of the other WordPress sites I manage as this will be the third one it has happened to since last week and all had the same results and message at the end of running the repair.

    Thank you for your time.

Viewing 1 replies (of 1 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    This usually means that your database server is crashing and corrupting open tables. You may have may sites, but do they all hit the same DB server? I’d bring this up with your host ASAP and ask them to check the database server logs.

    Usually, you can repair broken tables via PHPMYADMIN, even if WP can’t repair them itself.

Viewing 1 replies (of 1 total)
  • The topic ‘Database Error issue on several websites’ is closed to new replies.