Forums

[resolved] Error when uploading an image for a post (5 posts)

  1. jcletarnec
    Member
    Posted 6 years ago #

    Hi, here is the error when i tried to upload an image for a post :

    Thank you for your help.

    ERROR : =========================
    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-11-22 13:15:21', '2006-11-22 11:15:21', '', 'phototest11.jpg', '', 'attachment', 'open', 'open', '', 'phototest11jpg', '', '', '2006-11-22 13:15:21', '2006-11-22 11:15:21', '11', '0', 'image/jpeg', 'http://localhost:8080/wordpress/wp-content/uploads/2006/11/phototest11.jpg')

    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:\Program Files\Apache Group\Apache2\htdocs\wordpress/wp-content/uploads/2006/11/phototest11.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:185;s:6:\"height\";i:245;s:14:\"hwstring_small\";s:22:\"height=\'96\' width=\'72\'\";s:4:\"file\";s:97:\"C:\\Program Files\\Apache Group\\Apache2\\htdocs\\wordpress/wp-content/uploads/2006/11/phototest11.jpg\";}')

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

  2. precneps
    Member
    Posted 6 years ago #

    Going through the threads from this search, might help.
    http://wordpress.org/search/Error+when+uploading+an+image?forums=1

  3. spencerp
    Member
    Posted 6 years ago #

    Owen Gray from the wp-hackers email list, has shared a detailed explanation of what's going on, and even provided a thread which contains "fixes" for this problem.

    Many thanks to Owen Gray.. ;) =)

    spencerp

  4. jcletarnec
    Member
    Posted 6 years ago #

    Thank You for your help. The Owen Gray solution help me.

    many Thhanks

    jcletarnec

  5. spencerp
    Member
    Posted 6 years ago #

    Awesome! Glad to hear that! ;) :)

    spencerp

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.