• Hello,
    After having some problems, I upgraded to version 2.8.4. I went to the admin page and clicked on the Upgrade WordPress Database, then a short time later my neighbourhood had a power outage.

    Now, my main page is visible, but my subpages are not. When I click on my admin page, I get the original “upgrade wordpress database” page again. But when I click on the button, I get the error message pasted below.

    I did the upgrade over again – removing all files from the server (per the detailed upgrade instructions) and uploading them again. This did not work.

    Any suggestions for a remedy? I am very discouraged as I’ve been struggling for a week. Clearly WordPress is beyond my scope. I have readers writing to me via my site and I can’t respond. I can’t do anything on it.

    Many thanks,
    Jennifer

    HTTP Error 502.2 – Bad Gateway
    The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are “WordPress database error Duplicate key name ‘comment_approved’ for query ALTER TABLE wp_comments ADD KEY comment_approved (comment_approved) made by wp_upgrade, make_db_current_silent, dbDelta WordPress database error Can’t DROP ‘option_can_override’; check that column/key exists for query ALTER TABLE wp_options DROP option_can_override made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Can’t DROP ‘option_type’; check that column/key exists for query ALTER TABLE wp_options DROP option_type made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Can’t DROP ‘option_width’; check that column/key exists for query ALTER TABLE wp_options DROP option_width made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Can’t DROP ‘option_height’; check that column/key exists for query ALTER TABLE wp_options DROP option_height made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Can’t DROP ‘option_description’; check that column/key exists for query ALTER TABLE wp_options DROP option_description made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Can’t DROP ‘option_admin_level’; check that column/key exists for query ALTER TABLE wp_options DROP option_admin_level made by wp_upgrade, upgrade_all, upgrade_230_options_table WordPress database error Duplicate entry ‘1’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (1, ‘a life’, ‘life-2’, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ‘1-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 1, ‘category’, ‘Just a journal entry.’, 0, 57) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ‘3’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (3, ‘go find yours’, ‘go-find-yours-2’, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ‘3-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 3, ‘category’, ‘Find a similar inspiration in your life.’, 0, 6) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ‘4’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (4, ‘creative play’, ‘creative-play-2’, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ‘4-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 4, ‘category’, ‘You try it!’, 0, 11) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’23’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (23, ‘lifelong learning’, ‘lifelong-learning-2′, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’23-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 23, ‘category’, ‘About lifelong learning.’, 0, 10) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’24’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (24, ‘food’, ‘food-2′, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’24-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 24, ‘category’, ”, 1, 6) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’25’ for key 1 for query INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (25, ‘friendship’, ‘friendship-2′, 1) made by wp_upgrade, upgrade_all, upgrade_230 WordPress database error Duplicate entry ’25-category’ for key 2 for query INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 25, ‘category’, ”, 1, 4) madX-Powered-By: PHP/5.2.6 Content-Type: text/html; charset=UTF-8 <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt; <html xmlns=”http://www.w3.org/1999/xhtml&#8221; dir=”ltr” lang=”en-US”> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ /> <title>WordPress › Upgrade</title> <link rel=’stylesheet’ id=’install-css’ href=’http://realia.ca/wordpress/wp-admin/css/install.css?ver=20090514&#8242; type=’text/css’ media=’all’ /> </head> <body> <h1 id=”logo”><img alt=”WordPress” src=”images/wordpress-logo.png” /></h1> <div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘1’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (1, ‘a life’, ‘life-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘1-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 1, ‘category’, ‘Just a journal entry.’, 0, 57)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘3’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (3, ‘go find yours’, ‘go-find-yours-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘3-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 3, ‘category’, ‘Find a similar inspiration in your life.’, 0, 6)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘4’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (4, ‘creative play’, ‘creative-play-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ‘4-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 4, ‘category’, ‘You try it!’, 0, 11)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’23’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (23, ‘lifelong learning’, ‘lifelong-learning-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’23-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 23, ‘category’, ‘About lifelong learning.’, 0, 10)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’24’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (24, ‘food’, ‘food-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’24-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 24, ‘category’, ”, 1, 6)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’25’ for key 1]
    INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (25, ‘friendship’, ‘friendship-2′, 1)</p> </div><div id=’error’> <p class=’wpdberror’>WordPress database error: [Duplicate entry ’25-category’ for key 2]
    INSERT INTO wp_term_taxonomy (term_id, taxonomy, descript

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator cubecolour

    (@numeeja)

    Do you have a backup of your database taken before the upgrade?

    Thread Starter jenmorrison

    (@jenmorrison)

    Yes, I have a backup.

    Moderator cubecolour

    (@numeeja)

    OK that’s good.

    If this happened to me, my plan would be to restore all the files back to how it was before the upgrade and restore the db backup.

    Then once it is back to the pre-upgrade state and tested to be working, I’d disable all the plugins, perform the upgrade & re-enable the recently active plugins.

    To be safe and not destroy the existing db in case there’s a problem with the restore, I would take the belt & braces approach & create a new database (as long as the hosting permits more than one db) to restore to and edit the wp-config to connect to that so that the original one is kept intact.

    Thread Starter jenmorrison

    (@jenmorrison)

    Tried all these options. WordPress not for me, it’s for experts. At least I could transfer my files with thanks to a techie friend. Goodbye and good luck.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘upgrade will not complete – error 502.2 bad gateway’ is closed to new replies.