Title: Database errors and missing content after upgrade
Last modified: August 19, 2016

---

# Database errors and missing content after upgrade

 *  Resolved [buksida](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/)
 * I have transferred my hosting server and upgraded WP from version 2 to the current(
   3.0.1) following this guide:
    [http://www.dollarshower.com/move-wordpress-blog-to-another-host-server/](http://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)

1 [2](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/page/2/?output_format=md)

 *  Thread Starter [buksida](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704452)
 * 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.
 *  [faheemmulla](https://wordpress.org/support/users/faheemmulla/)
 * (@faheemmulla)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704453)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704503)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704528)
 * So this cant be fixed then?
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704529)
 * I thought the problem was gone. I’m having no trouble navigating your blog at
   [http://www.huahinblog.com](http://www.huahinblog.com)
 *  Thread Starter [buksida](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704530)
 * 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](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704531)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704532)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704533)
 * Ok, thats done, edited .htaccess but now all I am getting is a blank page!
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704534)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704535)
 * Now we’re just getting this “Error establishing a database connection”
 * Will check logs …
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704536)
 * Actually, that’s probably connected to the blank page. I’m guessing your database
   server went offline.
 *  Thread Starter [buksida](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704537)
 * 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: http://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: http://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: http://www.huahinblog.com/wp-admin/edit-comments.php?comment_status=spam
       ```
   
 *  Moderator [James Huff](https://wordpress.org/support/users/macmanx/)
 * (@macmanx)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704538)
 * 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](https://wordpress.org/support/users/buksida/)
 * (@buksida)
 * [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/#post-1704539)
 * Yes, still getting the blank page – which started as soon as i edited .htaccess

Viewing 15 replies - 1 through 15 (of 20 total)

1 [2](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/page/2/?output_format=md)
[→](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/page/2/?output_format=md)

The topic ‘Database errors and missing content after upgrade’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 20 replies
 * 3 participants
 * Last reply from: [James Huff](https://wordpress.org/support/users/macmanx/)
 * Last activity: [15 years, 7 months ago](https://wordpress.org/support/topic/database-errors-and-missing-content-after-upgrade/page/2/#post-1704545)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics