Auto repairing database results

  • Hi,

    I’ve recently installed WP (last version), and the wp_options database is crashing EVERY DAY, and a “Database Error” message is displayed to anyone who tries to access the site.

    I just attempted repair via the WP repair feature, and got the following result:

    vs_users: 1 client is using or hasn’t closed the table properly
    vs_usermeta: 4 clients are using or haven’t closed the table properly
    vs_posts: 7 clients are using or haven’t closed the table properly
    vs_comments: 1 client is using or hasn’t closed the table properly
    vs_options: Table is marked as crashed
    vs_postmeta: 9 clients are using or haven’t closed the table properly
    vs_terms: 5 clients are using or haven’t closed the table properly
    vs_term_taxonomy: 5 clients are using or haven’t closed the table properly
    vs_term_relationships: 6 clients are using or haven’t closed the table properly

    What does it all mean?
    And what should be done?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jumbo1

    (@jumbo1)

    Also, here are the 3 first error messages in my error_log file (I have a bunch of different error messages, ALL of them having to do with the vs_options table):

    [06-Jun-2014 21:54:04 UTC] WordPress database error Incorrect key file for table ‘./mysite_vids/vs_options.MYI’; try to repair it for query DELETE FROM vs_options WHERE option_name = ‘_site_transient_theme_roots’ made by do_action_ref_array, call_user_func_array, wp_maybe_auto_update, WP_Automatic_Updater->run, wp_update_themes, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_option

    [06-Jun-2014 21:54:04 UTC] WordPress database error Incorrect key file for table ‘./mysite_vids/vs_options.MYI’; try to repair it for query DELETE FROM vs_options WHERE option_name = ‘_site_transient_timeout_theme_roots’ made by do_action_ref_array, call_user_func_array, wp_maybe_auto_update, WP_Automatic_Updater->run, wp_update_themes, wp_get_themes, search_theme_directories, get_site_transient, delete_site_option, delete_option

    [08-Jun-2014 07:50:34 UTC] WordPress database error Table ‘vs_options’ is marked as crashed and should be repaired for query SELECT option_value FROM vs_options WHERE option_name = ‘adinj_options’ LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/ad-injection/ad-injection.php’), adinj_setup_hooks_and_filters, adinj_option, adinj_options, get_option

    Thread Starter jumbo1

    (@jumbo1)

    any help from the experts?

    How can I solve the options table crashing every now and then?
    Would I need to re-install WP?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Auto repairing database results’ is closed to new replies.