Support » Fixing WordPress » lots of DB errors after hosting migration

  • Resolved autumn_bliss

    (@autumn_bliss)



    Hello all, I’m having lots of issues with my blog after I changed my hosting service.

    I started out having that sql errors that required me to go to some tables and change stuff to auto_increment and now I’m trying to upload pictures to a post and here’s what happening:

    WordPress database error: [Duplicate entry ‘0’ for key 1]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, pinged, post_modified, post_modified_gmt, post_parent, menu_order, post_mime_type, guid) VALUES (‘1’, ‘2006-08-24 11:30:41’, ‘2006-08-24 14:30:41’, ”, ‘plutodog.gif’, ”, ‘attachment’, ‘open’, ‘closed’, ”, ‘plutodoggif’, ”, ”, ‘2006-08-24 11:30:41’, ‘2006-08-24 14:30:41’, ‘-1156429189’, ‘0’, ‘image/gif’, ‘http://www.infinity9.net/wp-content/uploads/2006/08/plutodog.gif’)

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 3]
    SELECT category_id FROM wp_post2cat WHERE post_id =

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ 15)’ at line 2]
    INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 15)

    WordPress database error: [Duplicate entry ‘0’ for key 1]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (”,’_wp_attached_file’,’/home/infinity/domains/infinity9.net/public_html/wp-content/uploads/2006/08/plutodog.gif’)

    WordPress database error: [Duplicate entry ‘0’ for key 1]
    INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (”,’_wp_attachment_metadata’,’a:4:{s:5:”width”;i:158;s:6:”height”;i:281;s:14:”hwstring_small”;s:22:”height=’96’ width=’53′”;s:4:”file”;s:88:”/home/infinity/domains/infinity9.net/public_html/wp-content/uploads/2006/08/plutodog.gif”;}’)

    Warning: Cannot modify header information – headers already sent by (output started at /home/infinity/domains/infinity9.net/public_html/wp-includes/wp-db.php:104) in /home/infinity/domains/infinity9.net/public_html/wp-includes/pluggable-functions.php on line 272

    I’m running WordPress 2.04 (upgraded from 2.03 using my hosting’s Instalatron) and my website is this one

    Any ideas?

Viewing 1 replies (of 1 total)
  • It’s me again. I reinstalled WordPress, imported my DB from the other server and I just can’t do anything at all. Posting entries is already a pain in the a** because either they don’t show up or I have to post 3 times or add the auto_increment thingy every once in a while, I can’t edit posts, uploading pictures is nearly impossible…

    I just CAN’T afford to lose all my blog entries so is there ANYTHING I can do?

Viewing 1 replies (of 1 total)
  • The topic ‘lots of DB errors after hosting migration’ is closed to new replies.