[wp-trac] [WordPress Trac] #3112: Upload bugs

WordPress Trac wp-trac at lists.automattic.com
Wed Sep 6 10:50:29 GMT 2006


#3112: Upload bugs
----------------------------+-----------------------------------------------
 Reporter:  kakingho        |       Owner:  anonymous
     Type:  defect          |      Status:  new      
 Priority:  normal          |   Milestone:           
Component:  Administration  |     Version:           
 Severity:  normal          |    Keywords:           
----------------------------+-----------------------------------------------
 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~!!

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3112>
WordPress Trac <http://wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list