WordPress.org

Support

Support » How-To and Troubleshooting » image upload error

image upload error

  • When I try to upload images, I get the error messages below. The images are in the folder on my server but never show up in WP for me to use them. I also don’t have the Browse All link like on other installations that I’ve used.

    Any help on this is appreciated. Thanks!

    WordPress database error: [Field ‘post_content_filtered’ doesn’t have a default value]
    INSERT INTO wp_rockwellcomputerlab_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-05-23 11:57:01’, ‘2006-05-23 16:57:01’, ‘test’, ‘test’, ”, ‘attachment’, ‘open’, ‘open’, ”, ‘test’, ”, ”, ‘2006-05-23 11:57:01’, ‘2006-05-23 16:57:01’, ‘3’, ‘0’, ‘image/gif’, ‘http://10.200.30.32/blogRockwellComputerLab/wp-content/uploads//2006/05/TEAMSbagGraphicCurvedYellow3.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_rockwellcomputerlab_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_rockwellcomputerlab_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_rockwellcomputerlab_postmeta (post_id,meta_key,meta_value) VALUES (”,’_wp_attached_file’,’c:\Inetpub\wwwroot\blogRockwellComputerLab/wp-content/uploads//2006/05/TEAMSbagGraphicCurvedYellow3.gif’)

    WordPress database error: [Out of range value adjusted for column ‘post_id’ at row 1]
    INSERT INTO wp_rockwellcomputerlab_postmeta (post_id,meta_key,meta_value) VALUES (”,’_wp_attachment_metadata’,’a:4:{s:5:\”width\”;i:504;s:6:\”height\”;i:432;s:14:\”hwstring_small\”;s:23:\”height=\’96\’ width=\’112\’\”;s:4:\”file\”;s:103:\”c:\\Inetpub\\wwwroot\\blogRockwellComputerLab/wp-content/uploads//2006/05/TEAMSbagGraphicCurvedYellow3.gif\”;}’)

    Warning: Cannot modify header information – headers already sent by (output started at c:\Inetpub\wwwroot\blogRockwellComputerLab\wp-includes\wp-db.php:102) in c:\Inetpub\wwwroot\blogRockwellComputerLab\wp-admin\inline-uploading.php on line 101

Viewing 1 replies (of 1 total)
  • To fix this problem, I had to change post_content_filtered in wp_posts to have a default value of null.

    I have several WP blogs running on this server and had to make the change in each of them.

    Does anyone see a problem with this? Anyone know why i have to do this manually?

Viewing 1 replies (of 1 total)
  • The topic ‘image upload error’ is closed to new replies.
Skip to toolbar