id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
3112	Upload bugs	kakingho	anonymous	"I got WP 2  running.

It appears to work fine in all respects except for the image uploading.

After I press upload button,
it shows this error message

↓ (using windowXP, apache2 ,php5,mysql 5)

=========================================================

WordPress database error: [Field 'post_content_filtered' doesn't have a default value]
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-09-03 07:10:00', '2006-09-03 07:10:00', 'title', 'title', '', 'attachment', 'open', 'open', '', 'title', '', '', '2006-09-03 07:10:00', '2006-09-03 07:10:00', '-1157267383', '0', 'image/gif', 'http://localhost:1/wordpress/wp-content/uploads/2006/09/icon_haha.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 ' 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','C:\Apache2\htdocs\wordpress/wp-content/uploads/2006/09/icon_haha.gif')

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:18;s:6:\""height\"";i:18;s:14:\""hwstring_small\"";s:22:\""height=\'18\' width=\'18\'\"";s:4:\""file\"";s:68:\""C:\\Apache2\\htdocs\\wordpress/wp-content/uploads/2006/09/icon_haha.gif\"";}')

Warning: Cannot modify header information - headers already sent by (output started at C:\Apache2\htdocs\wordpress\wp-includes\wp-db.php:104) in C:\Apache2\htdocs\wordpress\wp-includes\pluggable-functions.php on line 272
===========================================================

I also tested WP2 at Linux

with older

PHP version 4.3.10 

MySQL version 4.0.25-standard 

Finally, it can upload perfectly and have ""browse all"" button.



*I think WP2 upload function cannot run at new stable php and mysql version.

There is difference of syntax .

Hope you can test it and fix that bug.

Thx a lot~!!


"	defect (bug)	closed	normal	2.0.6	Administration	2.0.4	normal	fixed	needs-patch