It says my database needs an update, but then it crashed. What happened?

  • Unknown's avatar

    My blog was perfectly fine a couple days ago, but then I tried to post something and I came to a screen that says this.

    Database Update Required

    WordPress has been updated! Before we send you on your way, we have to update your database to the newest version.

    The update process may take a little while, so please be patient.

    So I clicked the update button, waited a while, and then it brings me to a screen that has all this.

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_name FROM wp_options WHERE option_name in ( ‘siteurl’, ‘blogname’, ‘blogdescription’, ‘users_can_register’, ‘admin_email’, ‘start_of_week’, ‘use_balanceTags’, ‘use_smilies’, ‘require_name_email’, ‘comments_notify’, ‘posts_per_rss’, ‘rss_use_excerpt’, ‘mailserver_url’, ‘mailserver_login’, ‘mailserver_pass’, ‘mailserver_port’, ‘default_category’, ‘default_comment_status’, ‘default_ping_status’, ‘default_pingback_flag’, ‘posts_per_page’, ‘date_format’, ‘time_format’, ‘links_updated_date_format’, ‘links_recently_updated_prepend’, ‘links_recently_updated_append’, ‘links_recently_updated_time’, ‘comment_moderation’, ‘moderation_notify’, ‘permalink_structure’, ‘gzipcompression’, ‘hack_file’, ‘blog_charset’, ‘moderation_keys’, ‘active_plugins’, ‘home’, ‘category_base’, ‘ping_sites’, ‘advanced_edit’, ‘comment_max_links’, ‘gmt_offset’, ‘default_email_category’, ‘recently_edited’, ‘template’, ‘stylesheet’, ‘comment_whitelist’, ‘blacklist_keys’, ‘comment_registration’, ‘html_type’, ‘use_trackback’, ‘default_role’, ‘db_version’, ‘uploads_use_yearmonth_folders’, ‘upload_path’, ‘blog_public’, ‘default_link_category’, ‘show_on_front’, ‘tag_base’, ‘show_avatars’, ‘avatar_rating’, ‘upload_url_path’, ‘thumbnail_size_w’, ‘thumbnail_size_h’, ‘thumbnail_crop’, ‘medium_size_w’, ‘medium_size_h’, ‘avatar_default’, ‘large_size_w’, ‘large_size_h’, ‘image_default_link_type’, ‘image_default_size’, ‘image_default_align’, ‘close_comments_for_old_posts’, ‘close_comments_days_old’, ‘thread_comments’, ‘thread_comments_depth’, ‘page_comments’, ‘comments_per_page’, ‘default_comments_page’, ‘comment_order’, ‘sticky_posts’, ‘widget_categories’, ‘widget_text’, ‘widget_rss’, ‘uninstall_plugins’, ‘timezone_string’, ‘page_for_posts’, ‘page_on_front’, ‘default_post_format’, ‘link_manager_enabled’, ‘initial_db_version’ )

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘siteurl’, ‘http://evanbremer.com’, ‘yes’), (‘blogname’, ‘My Site’, ‘yes’), (‘blogdescription’, ‘Just another WordPress site’, ‘yes’), (‘users_can_register’, ‘0’, ‘yes’), (‘admin_email’, ‘(email visible only to moderators and staff)’, ‘yes’), (‘start_of_week’, ‘1’, ‘yes’), (‘use_balanceTags’, ‘0’, ‘yes’), (‘use_smilies’, ‘1’, ‘yes’), (‘require_name_email’, ‘1’, ‘yes’), (‘comments_notify’, ‘1’, ‘yes’), (‘posts_per_rss’, ’10’, ‘yes’), (‘rss_use_excerpt’, ‘0’, ‘yes’), (‘mailserver_url’, ‘mail.example.com’, ‘yes’), (‘mailserver_login’, ‘(email visible only to moderators and staff)’, ‘yes’), (‘mailserver_pass’, ‘password’, ‘yes’), (‘mailserver_port’, ‘110’, ‘yes’), (‘default_category’, ‘1’, ‘yes’), (‘default_comment_status’, ‘open’, ‘yes’), (‘default_ping_status’, ‘open’, ‘yes’), (‘default_pingback_flag’, ‘1’, ‘yes’), (‘posts_per_page’, ’10’, ‘yes’), (‘date_format’, ‘F j, Y’, ‘yes’), (‘time_format’, ‘g:i a’, ‘yes’), (‘links_updated_date_format’, ‘F j, Y g:i a’, ‘yes’), (‘links_recently_updated_prepend’, ‘‘, ‘yes’), (‘links_recently_updated_append’, ‘‘, ‘yes’), (‘links_recently_updated_time’, ‘120’, ‘yes’), (‘comment_moderation’, ‘0’, ‘yes’), (‘moderation_notify’, ‘1’, ‘yes’), (‘permalink_structure’, ”, ‘yes’), (‘gzipcompression’, ‘0’, ‘yes’), (‘hack_file’, ‘0’, ‘yes’), (‘blog_charset’, ‘UTF-8’, ‘yes’), (‘moderation_keys’, ”, ‘no’), (‘active_plugins’, ‘a:0:{}’, ‘yes’), (‘home’, ‘http://evanbremer.com’, ‘yes’), (‘category_base’, ”, ‘yes’), (‘ping_sites’, ‘http://rpc.pingomatic.com/’, ‘yes’), (‘advanced_edit’, ‘0’, ‘yes’), (‘comment_max_links’, ‘2’, ‘yes’), (‘gmt_offset’, ‘0’, ‘yes’), (‘default_email_category’, ‘1’, ‘yes’), (‘recently_edited’, ”, ‘no’), (‘template’, ‘twentythirteen’, ‘yes’), (‘stylesheet’, ‘twentythirteen’, ‘yes’), (‘comment_whitelist’, ‘1’, ‘yes’), (‘blacklist_keys’, ”, ‘no’), (‘comment_registration’, ‘0’, ‘yes’), (‘html_type’, ‘text/html’, ‘yes’), (‘use_trackback’, ‘0’, ‘yes’), (‘default_role’, ‘subscriber’, ‘yes’), (‘db_version’, ‘25824’, ‘yes’), (‘uploads_use_yearmonth_folders’, ‘1’, ‘yes’), (‘upload_path’, ”, ‘yes’), (‘blog_public’, ‘1’, ‘yes’), (‘default_link_category’, ‘2’, ‘yes’), (‘show_on_front’, ‘posts’, ‘yes’), (‘tag_base’, ”, ‘yes’), (‘show_avatars’, ‘1’, ‘yes’), (‘avatar_rating’, ‘G’, ‘yes’), (‘upload_url_path’, ”, ‘yes’), (‘thumbnail_size_w’, ‘150’, ‘yes’), (‘thumbnail_size_h’, ‘150’, ‘yes’), (‘thumbnail_crop’, ‘1’, ‘yes’), (‘medium_size_w’, ‘300’, ‘yes’), (‘medium_size_h’, ‘300’, ‘yes’), (‘avatar_default’, ‘mystery’, ‘yes’), (‘large_size_w’, ‘1024’, ‘yes’), (‘large_size_h’, ‘1024’, ‘yes’), (‘image_default_link_type’, ‘file’, ‘yes’), (‘image_default_size’, ”, ‘yes’), (‘image_default_align’, ”, ‘yes’), (‘close_comments_for_old_posts’, ‘0’, ‘yes’), (‘close_comments_days_old’, ’14’, ‘yes’), (‘thread_comments’, ‘1’, ‘yes’), (‘thread_comments_depth’, ‘5’, ‘yes’), (‘page_comments’, ‘0’, ‘yes’), (‘comments_per_page’, ’50’, ‘yes’), (‘default_comments_page’, ‘newest’, ‘yes’), (‘comment_order’, ‘asc’, ‘yes’), (‘sticky_posts’, ‘a:0:{}’, ‘yes’), (‘widget_categories’, ‘a:0:{}’, ‘yes’), (‘widget_text’, ‘a:0:{}’, ‘yes’), (‘widget_rss’, ‘a:0:{}’, ‘yes’), (‘uninstall_plugins’, ‘a:0:{}’, ‘no’), (‘timezone_string’, ”, ‘yes’), (‘page_for_posts’, ‘0’, ‘yes’), (‘page_on_front’, ‘0’, ‘yes’), (‘default_post_format’, ‘0’, ‘yes’), (‘link_manager_enabled’, ‘0’, ‘yes’), (‘initial_db_version’, ‘25824’, ‘yes’)

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_value FROM wp_options WHERE option_name = ‘home’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘blodotgsping_url’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘bodyterminator’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ’emailtestonly’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘phoneemail_separator’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘smilies_directory’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘subjectprefix’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_bbcode’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_blodotgsping’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_phoneemail’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_quicktags’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_weblogsping’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘weblogs_cache_file’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_preview’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_htmltrans’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘smilies_directory’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘fileupload_allowedusers’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_phoneemail’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_post_status’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_post_category’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘archive_mode’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘time_difference’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_minadminlevel’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_use_adminlevels’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_type’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_char’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_ignore_zero’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_single_image’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image0’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image1’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image2’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image3’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image4’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image5’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image6’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image7’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image8’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘links_rating_image9’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘weblogs_cacheminutes’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘comment_allowed_tags’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘search_engine_friendly_urls’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_geourl_lat’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_geourl_lon’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_default_geourl’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘weblogs_xml_url’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘new_users_can_blog’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘_wpnonce’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘_wp_http_referer’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘Update’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘action’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘rich_editing’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘autosave_interval’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘deactivated_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘can_compress_scripts’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘page_uris’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘update_core’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘update_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘update_themes’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘doing_cron’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘random_seed’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘rss_excerpt_length’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘secret’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘use_linksupdate’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_comment_status_page’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘wporg_popular_tags’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘what_to_show’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘rss_language’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘language’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘enable_xmlrpc’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘enable_app’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ’embed_autourls’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘default_post_edit_rows’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    DELETE FROM wp_options WHERE option_name REGEXP ‘^rss_[0-9a-f]{32}(_ts)?$’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE ‘_transient_%’ AND a.option_name NOT LIKE ‘_transient_timeout_%’ AND b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) ) AND b.option_value < 1385227948

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    DELETE a, b FROM wp_options a, wp_options b WHERE a.option_name LIKE ‘_site_transient_%’ AND a.option_name NOT LIKE ‘_site_transient_timeout_%’ AND b.option_name = CONCAT( ‘_site_transient_timeout_’, SUBSTRING( a.option_name, 17 ) ) AND b.option_value < 1385227948

    WordPress database error: [Table ‘evanbre1_wordpress.wp_categories’ doesn’t exist]
    SELECT cat_ID, cat_name, category_nicename FROM wp_categories

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    UPDATE wp_options SET option_value = REPLACE(option_value, ‘wp-links/links-images/’, ‘wp-images/links/’) WHERE option_name LIKE ‘links_rating_image%’ AND option_value LIKE ‘wp-links/links-images/%’

    WordPress database error: [Table ‘evanbre1_wordpress.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT post_id FROM wp_post2cat

    WordPress database error: [Unknown column ‘post_category’ in ‘field list’]
    SELECT ID, post_category FROM wp_posts WHERE post_category != ‘0’

    WordPress database error: [Table ‘evanbre1_wordpress.wp_categories’ doesn’t exist]
    ALTER TABLE wp_categories ADD INDEX ( category_nicename )

    WordPress database error: [Key column ‘link_category’ doesn’t exist in table]
    ALTER TABLE wp_links ADD INDEX ( link_category )

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_name, option_value FROM wp_options

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_value FROM wp_options WHERE option_name = ‘active_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    UPDATE wp_options SET option_value = ‘a:1:{i:0;s:0:””;}’ WHERE option_name = ‘active_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_name, COUNT(option_name) AS dupes FROM wp_options GROUP BY option_name

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_value FROM wp_options WHERE option_name = ‘blogname’

    WordPress database error: [Table ‘evanbre1_wordpress.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories ORDER BY cat_ID

    WordPress database error: [Table ‘evanbre1_wordpress.wp_post2cat’ doesn’t exist]
    SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

    WordPress database error: [Table ‘evanbre1_wordpress.wp_linkcategories’ doesn’t exist]
    SELECT cat_id, cat_name FROM wp_linkcategories

    WordPress database error: [Unknown column ‘link_category’ in ‘field list’]
    SELECT link_id, link_category FROM wp_links

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘default_link_category’, ‘0’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT autoload FROM wp_options WHERE option_name = ‘uninstall_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    UPDATE wp_options SET option_value = ‘1’ WHERE option_name = ‘link_manager_enabled’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_value FROM wp_options WHERE option_name = ‘active_plugins’

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘db_version’, ‘25824’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES (‘db_upgraded’, ‘1’, ‘yes’) ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [Table ‘./evanbre1_wordpress/wp_options’ is marked as crashed and should be repaired]
    SELECT option_value FROM wp_options WHERE option_name = ‘home’

    Update Complete

    Your WordPress database has been successfully updated!

    Of course, nothing has been updated and when I click the continue button, it just brings me to the previous screen. I really don’t know what to do.

    The blog I need help with is: (visible only to logged in users)

  • Unknown's avatar

    The site you are asking about does not seem to be hosted on WordPress.COM so you need to make friends over at WordPress.ORG the keepers of the software you are using.

    https://en.forums.wordpress.com/topic/7-things-to-know-before-posting-in-wordpresscom-forums?replies=1

    This site is for support of sites hosted on WordPress.COM. You should address your questions to WordPress.ORG the keepers of the software you are using: http://wordpress.org/support/

    For more on the difference: http://support.wordpress.com/com-vs-org/

  • The topic ‘It says my database needs an update, but then it crashed. What happened?’ is closed to new replies.