Database errors and missing content after upgrade

  • Resolved buksida

    (@buksida)


    14 years, 5 months ago

    I have transferred my hosting server and upgraded WP from version 2 to the current (3.0.1) following this guide:
    https://www.dollarshower.com/move-wordpress-blog-to-another-host-server/

    Most of the process went ok and the site and content was viewable on the new host.

    First problem was that I couldn’t login as admin on the new host, the password resets didnt work so I changed it manually using phpMyAdmin.

    Once I could login it propmted me to upgrade the database which I did. This went through with the following errors:

    WordPress database error: [Duplicate entry '1' for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (1, 'Hua Hin', 'hua-hin', 0)

WordPress database error: [Duplicate entry '1-category' for key 2]
INSERT INTO wp_term_taxonomy (term_id, taxonomy, description, parent, count) VALUES ( 1, 'category', 'General topics on Hua Hin and the area.', 0, 106)

WordPress database error: [Duplicate entry '2' for key 1]
INSERT INTO wp_terms (term_id, name, slug, term_group) VALUES (2, 'Expats', 'expats', 0)

WordPress database error: [Duplicate entry '2-link_category' for key 2]
INSERT INTO <code>wp_term_taxonomy</code> (<code>term_id</code>,<code>taxonomy</code>,<code>description</code>,<code>parent</code>,<code>count</code>) VALUES ('2','link_category','','0','0')
Upgrade Complete

Your WordPress database has been successfully upgraded!

    Then it took me to the new 3.0.1 admin panel. All seemed ok until I viewed the site and tried to click on an article, it gave me a 404 error stating that the article does not exist.

    Any help would be appreciated.

Viewing 5 replies - 16 through 20 (of 20 total)
  • Moderator James Huff

    (@macmanx)

    If you rename the .htaccess file, does the blank page problem go away? If so, can you paste the contents of your .htaccess file here?

    Thread Starter buksida

    (@buksida)

    Ok, wasn’t that then – just deleted it and am still getting a blank page.

    The admin panel all works ok though.

    Moderator James Huff

    (@macmanx)

    Try deactivating all plugins. If that resolves the issue, reactivate each one individually until you find the cause.

    If that does not resolve the issue, try switching to the Default theme (WordPress 1.5 – 2.9.2) or the Twenty Ten theme (WordPress 3.0 and higher) to rule-out a theme-specific issue.

    Thread Starter buksida

    (@buksida)

    Only two plugins, both inactive.

    Went into themes, it told me the default was broken so tried to install another but there were none listed. Back to default which seemed to have fixed itself and the front page came up (with a new header).

    Re-sent .htaccess and content links now work!

    I think we’re there, just need to create a new header.

    Thanks so much for all the help, will post back if I have any more problems.

    Moderator James Huff

    (@macmanx)

    You’re welcome!

Viewing 5 replies - 16 through 20 (of 20 total)
  • The topic ‘Database errors and missing content after upgrade’ is closed to new replies.