WordPress.org

Ready to get started?Download WordPress

Forums

Upgrade to 2.9: Database error (5 posts)

  1. Ivan
    Member
    Posted 4 years ago #

    When i tried to update de database (2.8.6 to 2.9) i have the following error .message Any ideas? Thanks:

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = '_transient_timeout_random_seed'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('_transient_random_seed', '56682cd72cbde9a3be1bcfba45dd1a90', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '7bf0dfd6aa919731431b32ac24b0b7d3' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = 'b18af3343c682a55148b143a8ca0c27b' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '147059c2fffea18b19097eb35ec0c6a2' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '42c6d7bd455f0facbc975175543d399e' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    SELECT option_name FROM wp_options

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('siteurl', 'http://u2fanlife.com', 'yes'), ('blogname', 'Mi sitio', 'yes'), ('blogdescription', 'Otro sitio creado con WordPress', 'yes'), ('users_can_register', '0', 'yes'), ('admin_email', 'you@example.com', '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', 'login@example.com', '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'), ('default_post_edit_rows', '10', 'yes'), ('posts_per_page', '10', 'yes'), ('date_format', 'j F, Y', 'yes'), ('time_format', 'G:i', 'yes'), ('links_updated_date_format', 'j F, Y G:i', '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://u2fanlife.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'), ('use_linksupdate', '0', 'yes'), ('template', 'default', 'yes'), ('stylesheet', 'default', 'yes'), ('comment_whitelist', '1', 'yes'), ('blacklist_keys', '', 'no'), ('comment_registration', '0', 'yes'), ('rss_language', 'en', 'yes'), ('html_type', 'text/html', 'yes'), ('use_trackback', '0', 'yes'), ('default_role', 'subscriber', 'yes'), ('db_version', '12329', 'yes'), ('uploads_use_yearmonth_folders', '1', 'yes'), ('upload_path', '', 'yes'), ('secret', 'ASDkIIMlE$mU9eJF!ArbD&qBKZ2DG9GtfP4Tzk35@vI#kHv!ySNMbEg0mFxH$6@2', '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'), ('enable_app', '0', 'yes'), ('enable_xmlrpc', '0', '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', '0', 'yes'), ('thread_comments_depth', '5', 'yes'), ('page_comments', '1', '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'), ('timezone_string', '', 'yes'), ('embed_autourls', '1', 'yes'), ('embed_size_w', '', 'yes'), ('embed_size_h', '600', 'yes')

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'home'

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'siteurl'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('home', 'http://u2fanlife.com', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'blodotgsping_url'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'bodyterminator'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'emailtestonly'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'phoneemail_separator'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'smilies_directory'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'subjectprefix'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_bbcode'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_blodotgsping'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_phoneemail'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_quicktags'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_weblogsping'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'weblogs_cache_file'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_preview'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_htmltrans'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'smilies_directory'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'fileupload_allowedusers'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_phoneemail'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'default_post_status'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'default_post_category'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'archive_mode'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'time_difference'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_minadminlevel'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_use_adminlevels'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_type'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_char'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_ignore_zero'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_single_image'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image0'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image1'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image2'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image3'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image4'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image5'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image6'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image7'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image8'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'links_rating_image9'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'weblogs_cacheminutes'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'comment_allowed_tags'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'search_engine_friendly_urls'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'default_geourl_lat'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'default_geourl_lon'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'use_default_geourl'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'weblogs_xml_url'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'new_users_can_blog'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = '_wpnonce'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = '_wp_http_referer'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'Update'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'action'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'rich_editing'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'autosave_interval'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'deactivated_plugins'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'can_compress_scripts'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'page_uris'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'update_core'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'update_plugins'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'update_themes'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'doing_cron'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'random_seed'

    WordPress database error: [MySQL server has gone away]
    SELECT autoload FROM wp_options WHERE option_name = 'rss_excerpt_length'

    WordPress database error: [MySQL server has gone away]
    DELETE FROM wp_options WHERE option_name REGEXP '^rss_[0-9a-f]{32}(_ts)?$'

    WordPress database error: [MySQL server has gone away]
    SELECT ID, post_title, post_name FROM wp_posts WHERE post_name = ''

    WordPress database error: [MySQL server has gone away]
    SELECT cat_ID, cat_name, category_nicename FROM wp_categories

    WordPress database error: [MySQL server has gone away]
    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: [MySQL server has gone away]
    SELECT DISTINCT post_id FROM wp_post2cat

    WordPress database error: [MySQL server has gone away]
    SELECT ID, post_category FROM wp_posts WHERE post_category != '0'

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_posts ADD INDEX ( post_name )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_posts ADD INDEX ( post_status )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_categories ADD INDEX ( category_nicename )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_comments ADD INDEX ( comment_approved )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_comments ADD INDEX ( comment_post_ID )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_links ADD INDEX ( link_category )

    WordPress database error: [MySQL server has gone away]
    ALTER TABLE wp_links ADD INDEX ( link_visible )

    WordPress database error: [MySQL server has gone away]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    WordPress database error: [MySQL server has gone away]
    SELECT ID, user_pass from wp_users

    WordPress database error: [MySQL server has gone away]
    SELECT option_name, option_value FROM wp_options

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('gmt_offset', '0', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    SELECT MAX(post_date_gmt) FROM wp_posts

    WordPress database error: [MySQL server has gone away]
    SELECT ID, post_title, post_content, post_excerpt, guid, post_date, post_name, post_status, post_author FROM wp_posts

    WordPress database error: [MySQL server has gone away]
    SELECT comment_ID, comment_author, comment_content FROM wp_comments

    WordPress database error: [MySQL server has gone away]
    SELECT link_id, link_name, link_description FROM wp_links

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'active_plugins'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('active_plugins', 'a:1:{i:0;s:0:\"\";}', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_optionvalues

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_optiontypes

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_optiongroups

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_optiongroup_options

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_comments SET comment_type='trackback', comment_content = REPLACE(comment_content, '<trackback />', '') WHERE comment_content LIKE '<trackback />%'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_comments SET comment_type='pingback', comment_content = REPLACE(comment_content, '<pingback />', '') WHERE comment_content LIKE '<pingback />%'

    WordPress database error: [MySQL server has gone away]
    SELECT option_name, COUNT(option_name) AS dupes FROM wp_options GROUP BY option_name

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'blogname'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('wp_user_roles', 'a:6:{s:13:\"administrator\";a:2:{s:4:\"name\";s:13:\"Administrator\";s:12:\"capabilities\";a:64:{s:13:\"switch_themes\";b:1;s:11:\"edit_themes\";b:1;s:16:\"activate_plugins\";b:1;s:12:\"edit_plugins\";b:1;s:10:\"edit_users\";b:1;s:10:\"edit_files\";b:1;s:14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6:\"import\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:8:\"level_10\";b:1;s:7:\"level_9\";b:1;s:7:\"level_8\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;s:12:\"delete_users\";b:1;s:12:\"create_users\";b:1;s:12:\"manage_email\";b:1;s:15:\"Unfiltered Html\";b:1;s:12:\"manage_polls\";b:1;s:15:\"manage_database\";b:1;s:15:\"premium_content\";b:1;s:15:\"democracy_admin\";b:1;s:8:\"exec_php\";b:1;s:17:\"unfiltered_upload\";b:1;s:16:\"manage_downloads\";b:1;s:11:\"simple_tags\";b:1;s:14:\"edit_dashboard\";b:1;s:14:\"update_plugins\";b:1;s:14:\"delete_plugins\";b:1;s:15:\"edit_others_php\";b:1;s:15:\"install_plugins\";b:1;s:13:\"update_themes\";b:1;s:14:\"install_themes\";b:1;}}s:6:\"editor\";a:2:{s:4:\"name\";s:6:\"Editor\";s:12:\"capabilities\";a:36:{s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;s:15:\"democracy_admin\";b:1;s:8:\"exec_php\";b:1;}}s:6:\"author\";a:2:{s:4:\"name\";s:6:\"Author\";s:12:\"capabilities\";a:10:{s:12:\"upload_files\";b:1;s:10:\"edit_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;s:22:\"delete_published_posts\";b:1;}}s:11:\"contributor\";a:2:{s:4:\"name\";s:11:\"Contributor\";s:12:\"capabilities\";a:5:{s:10:\"edit_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;}}s:10:\"subscriber\";a:2:{s:4:\"name\";s:10:\"Subscriber\";s:12:\"capabilities\";a:2:{s:4:\"read\";b:1;s:7:\"level_0\";b:1;}}s:18:\"premium_subscriber\";a:2:{s:4:\"name\";s:18:\"Premium Subscriber\";s:12:\"capabilities\";a:2:{s:15:\"premium_content\";b:1;s:4:\"read\";b:1;}}}', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_users

    WordPress database error: [MySQL server has gone away]
    SELECT comment_post_ID, COUNT(*) as c FROM wp_comments WHERE comment_approved = '1' GROUP BY comment_post_ID

    WordPress database error: [MySQL server has gone away]
    SELECT ID, post_status FROM wp_posts

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_posts SET post_status = 'future' WHERE post_status = 'publish' AND post_date_gmt > '2009-12-23 14:26:59'

    WordPress database error: [MySQL server has gone away]
    SELECT ID, post_date FROM wp_posts WHERE post_status ='future'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_postmeta SET meta_key = '_wp_old_slug' WHERE meta_key = 'old_slug'

    WordPress database error: [MySQL server has gone away]
    SELECT * FROM wp_categories ORDER BY cat_ID

    WordPress database error: [MySQL server has gone away]
    SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

    WordPress database error: [MySQL server has gone away]
    SELECT cat_id, cat_name FROM wp_linkcategories

    WordPress database error: [MySQL server has gone away]
    SELECT link_id, link_category FROM wp_links

    WordPress database error: [MySQL server has gone away]
    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: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_linkcategories

    WordPress database error: [MySQL server has gone away]
    SELECT term_taxonomy_id, taxonomy FROM wp_term_taxonomy

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_categories

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_link2cat

    WordPress database error: [MySQL server has gone away]
    DROP TABLE IF EXISTS wp_post2cat

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '2ee1496ea012cf475d429223a5b087c2' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '4c1e8e3de15774659871546204d53926' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '98144880aa930c0c8bc092f2675c3396' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '91f91f74d497a7aecff15a8282f6d1bf' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_options SET option_value = '48774e9afebc8eee11b48582e6979309' WHERE option_name = '_transient_random_seed'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('secret', 'mR7)yLAN7u5*7WMgenCp^xwGe&o635D4UzJpBLK4KibOwiEfKzGtAU0lB66eF&YE', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_users SET user_activation_key = ''

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('enable_app', '1', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('enable_xmlrpc', '1', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    UPDATE wp_posts SET post_date = post_modified WHERE post_date = '0000-00-00 00:00:00'

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'active_plugins'

    WordPress database error: [MySQL server has gone away]
    INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('db_version', '12329', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

    WordPress database error: [MySQL server has gone away]
    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: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'home'

    WordPress database error: [MySQL server has gone away]
    SELECT option_value FROM wp_options WHERE option_name = 'siteurl'

  2. esmi
    Forum Moderator
    Posted 4 years ago #

    WordPress database error: [MySQL server has gone away]

    Your site couldn't contact the MySQL server that hosts your database. If this persists, contact your hosting provider.

  3. Ivan
    Member
    Posted 4 years ago #

    I'm not sure if that is the problem. I updated several blogs in same server and i don't have problems...

    More ideas?

    Thanks!!

  4. dannoll
    Member
    Posted 4 years ago #

    calvin13: I had similar "MySQL gone away" issues prior to 2.9. I reset the MySQL timeout threshold using this approach, and it seemed to work:
    http://www.robsnotebook.com/wordpress-mysql-gone-away

    Note: there are no workaround files posted specifically for WordPress v2.9. But I plan on adding these lines around line 387:

    $this->initialquery=1;
    $this->query("set session wait_timeout=600");

    Hope this helps,
    Dan
    Uncornered Market
    http://www.uncorneredmarket.com/

  5. Matthew
    Member
    Posted 4 years ago #

    I also encountered this error and have written up a step-by-step post on how to resolve it http://thesocialmediaguide.com.au/2010/07/31/solution-for-wordpress-database-error-mysql-server-has-gone-away-for-query/

Topic Closed

This topic has been closed to new replies.

About this Topic