DataBase Error

I finally got the silly thing running on the new server, I transferred all the DB stuff from the old server over, however what I was finding, is that if I transferred ALL the files over, the WP on the new server would “regress” to the old version (old server is 1.52 and new is 2.02) AND would boot me over to the old server when I tried to login. *sigh* Kill me now.

So, I transferred only selected DB files (posts, comments, categories etc) and NOW….of course I get another error.

This one looks fun:

WordPress database error: [Unknown column ‘post_mime_type’ in ‘field list’]
INSERT IGNORE INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, 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) VALUES (‘1’, ”, ”, ‘Gotta weird error here. This whole thing is pissing me off royally! ? WordPress database error: [Unknown column \’post_mime_type\’ in \’field list\’] SELECT ID, post_date, post_title, post_mime_type, guid FROM wp_posts WHERE post_status = \’attachment\’ AND post_parent = \’-1142605739\’ ORDER BY post_date_gmt DESC LIMIT 0, 10 Warning: Cannot modify header information – headers already sent by (output started at /mnt/web_z/d16/s24/b0263a77/www/wp-includes/wp-db.php:102) in /mnt/web_z/d16/s24/b0263a77/www/wp-admin/inline-uploading.php on line 140 In English S\’il vous plait?’, ”, ‘testin testin testin’, ”, ‘draft’, ‘open’, ‘open’, ”, ”, ”, ”, ”, ”, ‘0’, ‘0’, ”)

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 ‘ 1)’ at line 2]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

WordPress database error: [Unknown column ‘category_count’ in ‘field list’]
UPDATE wp_categories SET category_count = ’24’ WHERE cat_ID = ‘1’

Warning: Cannot modify header information – headers already sent by (output started at /mnt/web_z/d16/s24/b0263a77/www/wp-includes/wp-db.php:102) in /mnt/web_z/d16/s24/b0263a77/www/wp-admin/post.php on line 60

So like, can I just PAY someone to do this for me? Right now I am so bloody aggravated that I’ve been tempted to toss the laptop out the window. I don’t think that would improve my disposition right now.

Help. Please!

Jennifer