Crashed Tables

  • sharc316

    (@sharc316)


    12 years ago

    Hi,

    My blog has been heavily spammed by comments and I think that’s what caused it to crash.

    I ran a data base repair wordpress tool and here are the errors that could not be resolved:

    wp_comments: Table is marked as crashed
    wp_options: Table is marked as crashed
    wp_postmeta: 2 clients are using or haven’t closed the table properly
    wp_commentmeta: Table is marked as crashed

    At this point I cant even log into the wordpress admin. The page is just blank white.

    Can someone please help me?

Viewing 9 replies - 1 through 9 (of 9 total)
  • esmi

    (@esmi)

    12 years ago

    Try:
    – switching to the default theme automatically by renaming your current theme’s folder inside wp-content/themes and adding “-old” to the end of the folder name using FTP or whatever file management application your host provides.

    – resetting the plugins folder by FTP or phpMyAdmin.

    – re-running repair on all tables.

    Thread Starter sharc316

    (@sharc316)

    12 years ago

    Hi Esmi,

    Thanks for the help.

    How do I reset the plugin folder?

    Thread Starter sharc316

    (@sharc316)

    12 years ago

    NVM I see the instructions

    Thread Starter sharc316

    (@sharc316)

    12 years ago

    Hey

    So I followed the steps above but still same thing.

    The theme I’m using is called fixed-blix so i renamed it: fixed-blixold.

    Then I renamed the plugins folder to: plugins.hold

    Still a blank page.

    Anything else I can try?

    esmi

    (@esmi)

    12 years ago

    Did you repair all database tables again?

    Thread Starter sharc316

    (@sharc316)

    12 years ago

    Yes, I checked all the boxes in the blog folder and selected repair.

    According to the instructions i should be able to log into admin when renaming plugins folder.

    But it’s still blank.

    Please let me know if there is something else i can do?

    esmi

    (@esmi)

    12 years ago

    Try checking your site’s error logs for messages. Your hosts should be able to help you accessing your site’s error logs.

    Thread Starter sharc316

    (@sharc316)

    12 years ago

    Yes, I’ve accessed that. The log has almost 700,000 errors in it.

    Anything I can look for there?

    Sample from error log:

    10-May-2014 12:40:56] WordPress database error MySQL server has gone away for query INSERT INTOwp_options(option_name,option_value,autoload) VALUES ('cron', 'a:2:{i:1399725656;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}', 'yes') ON DUPLICATE KEY UPDATEoption_name= VALUES(option_name),option_value= VALUES(option_value),autoload= VALUES(autoload`) made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option, add_option
    [10-May-2014 12:40:56] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = ‘timezone_string’ LIMIT 1 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, get_option, apply_filters(‘pre_option_gmt_offset’), call_user_func_array, wp_timezone_override_offset, get_option
    [10-May-2014 12:40:56] WordPress database error MySQL server has gone away for query SELECT option_value FROM wp_options WHERE option_name = ‘gmt_offset’ LIMIT 1 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, wp_schedule_update_checks, get_option
    [10-May-2014 12:40:56] WordPress database error MySQL server has gone away for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘cron’, ‘a:2:{i:1399751880;a:1:{s:20:\”wp_maybe_auto_update\”;a:1:{s:32:\”40cd750bba9870f18aada2478b24840a\”;a:3:{s:8:\”schedule\”;s:10:\”twicedaily\”;s:4:\”args\”;a:0:{}s:8:\”interval\”;i:43200;}}}s:7:\”version\”;i:2;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload) made by require(‘wp-load.php’), requir`

    esmi

    (@esmi)

    12 years ago

    I think you need to have a word with your hosts about this. It sounds like their database server is crashing.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Crashed Tables’ is closed to new replies.