Database Error (List of errors)

  • Resolved drinxx

    (@drinxx)


    5 years, 10 months ago

    The repair process said to paste the following list of errors on this forum for possible help. Two days ago the website went offline with a Database Error message. I restored the database from a backup from several days earlier. Today again, I checked on the website and it says Database Error. I tried doing the “Repair database” option in WP this time and it gave lots of errors in trying to repair the database. I have posted the output below. Any help would be appreciated, as I am not familiar with much in the way of coding. Thank you.

    WordPress
    Database repair results

    The wp_users table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_users table. Error: 1 client is using or hasn’t closed the table properly

    The wp_usermeta table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_usermeta table. Error: 1 client is using or hasn’t closed the table properly

    The wp_posts table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_posts table. Error: 1 client is using or hasn’t closed the table properly

    The wp_comments table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_comments table. Error: 1 client is using or hasn’t closed the table properly

    The wp_links table is okay.

    The wp_options table is not okay. It is reporting the following error: Table is marked as crashed. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Table is marked as crashed

    The wp_postmeta table is not okay. It is reporting the following error: 3 clients are using or haven’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_postmeta table. Error: 3 clients are using or haven’t closed the table properly

    The wp_terms table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_terms table. Error: 1 client is using or hasn’t closed the table properly

    The wp_term_taxonomy table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_term_taxonomy table. Error: 1 client is using or hasn’t closed the table properly

    The wp_term_relationships table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_term_relationships table. Error: 1 client is using or hasn’t closed the table properly

    The wp_termmeta table is okay.

    The wp_commentmeta table is not okay. It is reporting the following error: 1 client is using or hasn’t closed the table properly. WordPress will attempt to repair this table…
    Failed to repair the wp_commentmeta table. Error: 1 client is using or hasn’t closed the table properly

    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.

    Warning: htmlspecialchars(): charset `ANSI_X3.4-1968′ not supported, assuming utf-8 in /home/antarctica/public_html/wp-includes/formatting.php on line 4002

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 1 client is using or hasn’t closed the table properly
    wp_posts: 1 client is using or hasn’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: 3 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: 1 client is using or hasn’t closed the table properly
    wp_term_relationships: 1 client is using or hasn’t closed the table properly
    wp_commentmeta: 1 client is using or hasn’t closed the table properly

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Moderator t-p

    (@t-p)

    5 years, 10 months ago

    Start by reviewing: http://dev.mysql.com/doc/refman/5.7/en/myisam-table-close.html

    Thread Starter drinxx

    (@drinxx)

    5 years, 10 months ago

    I tried the “Repair Database” link again, and it seems to have been successful the 2nd time. The website came back up and seems to be functioning normally.

    I have never had issues with this website before. However, we just recently added an ssl and updated the website to https. I wonder if this could be causing an issue within the database.

    • This reply was modified 5 years, 10 months ago by drinxx.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 10 months ago

    No. The issue occurs because your database server crashed or was shut down incorrectly.

    Thread Starter drinxx

    (@drinxx)

    5 years, 10 months ago

    Everything seems to be working for now. Except I am unable to add an image to a pre-crash post. So I just deleted that post for now. Thanks for the input. Hopefully I won’t need further assistance.

    Thread Starter drinxx

    (@drinxx)

    5 years, 10 months ago

    Everything working fine still. Thanks again. 🙂

    drmacenstein

    (@drmacenstein)

    5 years, 10 months ago

    i just got all the same errors.
    I reported the database, it works for maybe 2 hours, then it happens agin.
    any ideas?
    thanks!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    5 years, 10 months ago

    Contact your host. If they can’t fix the DB server, find another host.

    Thread Starter drinxx

    (@drinxx)

    5 years, 10 months ago

    Try running the repair option of wp using the “open in a new window” option from the error page. I ran it several times, each time it seemed to fix another part of the error. Hope this helps.

    Note: I encountered the issue shortly after updating the site to https.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Database Error (List of errors)’ is closed to new replies.