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 15 replies - 1 through 15 (of 20 total)
  • Thread Starter buksida

    (@buksida)

    Any way to fix this?

    If not how can I achieve the following:

    1) Move my WP blog to a new host/server.
    2) Upgrade from version 2 to 3 without losing content.

    Not Found

    The requested URL /blog/wp-login.php was not found on this server.

    Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

    Is that the error you get trying to login into WordPress?

    Thread Starter buksida

    (@buksida)

    I can login to admin no problem, the site looks fine but when we click on the headline of a published article it gives a 404:

    Not Found

The requested URL /2010/09/02/hua-hin-hot-topics-murder-rate-climbing/ was not found on this server.
Apache/2.0.52 (CentOS) Server at www.huahinblog.com Port 80

    It seems that something screwed up when the database updated – any one know how to fix?

    Thread Starter buksida

    (@buksida)

    So this cant be fixed then?

    Moderator James Huff

    (@macmanx)

    I thought the problem was gone. I’m having no trouble navigating your blog at https://www.huahinblog.com

    Thread Starter buksida

    (@buksida)

    I’ve switched the DNS back to the old server – I cant have it live on the new one with no content linking!

    Moderator James Huff

    (@macmanx)

    Ok, well keep in mind that DNS changes can take up to 48 hours to propagate to all ISPs, so that could be the cause or part of your problem.

    Try re-saving your permalink structure at Settings/Permalinks in your admin panel. If WordPress cannot automatically edit the .htaccess file, it will provide manual instructions after saving.

    Thread Starter buksida

    (@buksida)

    Ok will have a go at that.

    Surely though if the content has been duplicated onto both databases it should show regardless of the IP address as it is on both servers?

    Thread Starter buksida

    (@buksida)

    Ok, thats done, edited .htaccess but now all I am getting is a blank page!

    Moderator James Huff

    (@macmanx)

    Generate the blank page again, note the date and time, and check your server error log for any entries around that time.

    Thread Starter buksida

    (@buksida)

    Now we’re just getting this “Error establishing a database connection”

    Will check logs …

    Moderator James Huff

    (@macmanx)

    Actually, that’s probably connected to the blank page. I’m guessing your database server went offline.

    Thread Starter buksida

    (@buksida)

    Here are the latest entries:

    [Fri Oct 08 07:52:12 2010] [error] [client 193.47.80.39] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/robots.txt
[Fri Oct 08 07:52:48 2010] [error] [client 173.192.238.39] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/feed
[Fri Oct 08 07:53:29 2010] [error] [client 58.181.183.4] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/favicon.ico
[Fri Oct 08 07:53:58 2010] [error] [client 58.181.183.4] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/2010, referer: https://www.huahinblog.com/
[Fri Oct 08 07:54:07 2010] [error] [client 58.181.183.4] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/wp-admin/wp-admin.css, referer: https://www.huahinblog.com/wp-login.php
[Fri Oct 08 07:54:55 2010] [error] [client 58.181.183.2] File does not exist: /var/www/vhosts/huahinblog.com/httpdocs/favicon.ico
[Fri Oct 08 08:02:15 2010] [error] [client 58.181.183.2] PHP Warning: Invalid argument supplied for foreach() in /home/vhosts/huahinblog.com/httpdocs/wp-admin/edit-comments.php on line 41, referer: https://www.huahinblog.com/wp-admin/edit-comments.php?comment_status=spam
    Moderator James Huff

    (@macmanx)

    They all seem normal, except for that last one, which shouldn’t have caused a blank page. Is your database server back online, and has the “Error establishing a database connection” gone away yet? If so, are you still getting the blank page?

    Thread Starter buksida

    (@buksida)

    Yes, still getting the blank page – which started as soon as i edited .htaccess

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