lots of DB errors after hosting migration

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?