Image Upload broken after upgrade

OK, I finally have a little more information. On a slower computer, a brief series of error messages pops up in the frame when I hit “upload” they go away in a flash and then the “browse” window comes back, albeit without the newly uploaded images:
—-

WordPress Database error: [Field ‘post_content_filtered’ doesn’t have a default value]
INSERT INTO wp_post (post_author, post_date, post_date gmt, post_parent, menu order, post_mime_type, guid) VALUES (‘6′, 2007-01-18 02:08:42’, ‘2007-01-17 20;08;42’, ‘ ‘,ppt5.jpg, ‘ ‘, ‘attachement’, ‘open’, ‘open’, ‘ ‘, ‘ppt5jpg’, ‘ ‘, ‘ ‘, ‘2007-01-18 02:08:42’, ‘2007-01-17 20:08:42’, ‘-1169063304’, ‘0’ ‘image/jpeg’,

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQ 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 MySQ 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: [Out of range value adjusted for column ‘post_id’ at row 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘ ‘, ‘_wp_attached_file’ , ‘W:\www\cadc.auburn.edu\soa\rural-studio\outreach2007/wp-content/uploads/2007/01/ppt5.jpg’)

WordPress database error: [Out of range value adjusted for column ‘post_id’ at row 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES
(‘ ‘ , ‘__wp_attachment_metadata’ , ‘a:4:{s:5:\”width\”;i:99;s:6\”height\”;i:101;s:14:\”hwstring_small\”;s:22:\height=\’96\’
width=\’94\’\”;s:4:\”file\”;s:88:\W:\\www\\cadc.auburn.edu\\soa\\rural-studio\\outreach2007/wp-content/uploads/2007/01/ppt5.jpg\”;}’)

—-
Again, the images actually upload fine (I can access them via ftp) but they do not show up in the “browse” window. All files that were uploaded before the server upgrade are visible in the “browse” window, just not anything that I upload now after the server upgrade. This is affecting all of the WordPress sites on this server.

Any help or observations as to what might be causing this and a possible fix is extremely welcome. And sorry if there are any typos in the above error code – It appears and disappears so quickly I hade to do a screen capture and type it in by hand….

I am experiencing the same problem. I’m going to try completely reinstalling in a new directory and rebuilding the db from a backup. Another user, whose post I can’t find now, said that this worked for him.

I’m also considering the possibility that this is a SQL error, as my host just did a mysql upgrade.

Well, I tried a completely new install of WordPress with a fresh, empty database. With just the standard installation and no plugins, I navigated to the Write–>Post area and tested the uploader and browser.

The image uploaded, and the “Browse” links popped up. But, when you click Browse… no thumbnails.

I have replicated the error on a Mac using Safari and Firefox and on a PC using IE and Firefox.

I have an older version of WordPress, 2.0.3 running on the same host, and its image browser works just fine. Is there some way I can yank the image browser code out of the 2.0.3 version and slap it into the latest version?

I have the same prob and can’t find solution did you fix that?
keith284487 [a] gmail.com

I’m also facing a serious problem like this. I believe it’s a weakness in how WP handles the URL’s of uploaded files.

When you upload a file, it stores that file’s address in the database using your current permalink setup. If you change servers or directories as part of a re-install, it may break that link- even if you change the directory names back to their originals.

Unfortunately, there is no WP database tool or plugin I can find that specifically targets this problem. Hopefully someone with some coding knowledge will create a “fix broken uploads DB” tool.