WordPress Database Repair Issue

  • Resolved doozielabs

    (@doozielabs)


    4 years, 7 months ago

    My WordPress Website on local machine was working fine yesterday, Today when I just opened the localhost url, It asked me to repair database.

    following is the result:
    The wp_users table is okay.

    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 okay.

    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: Can’t read key from filepos: 34816. WordPress will attempt to repair this table…
    Failed to repair the wp_options table. Error: Can’t read key from filepos: 34816

    The wp_postmeta table is okay.

    The wp_terms table is okay.

    The wp_term_taxonomy table is okay.

    The wp_term_relationships table is okay.

    The wp_termmeta table is okay.

    The wp_commentmeta table is okay.

    The wp_woocommerce_payment_tokenmeta table is okay.

    The wp_woocommerce_order_itemmeta 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_woocommerce_order_itemmeta table. Error: 1 client is using or hasn’t closed the table properly

    The wp_wc_product_meta_lookup table is okay.

    The wp_wc_tax_rate_classes table is okay.

    The wp_yoast_seo_links table is okay.

    The wp_yoast_seo_meta table is okay.

    The wp_woocommerce_bundled_itemmeta table is okay.

    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_usermeta: 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: Can’t read key from filepos: 34816
    wp_woocommerce_order_itemmeta: 1 client is using or hasn’t closed the table properly

    • This topic was modified 4 years, 7 months ago by doozielabs.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress Database Repair Issue’ is closed to new replies.