Error saving attachment to database

  • shadowxj5

    (@shadowxj5)


    20 years ago

    I have recently installed WordPress 2.0.3, but I am unable to upload images to a post, pokeing around the code and stopping the inline uploading form displaying, allowed me to see the errors I was getting:


    WordPress database error: [Field 'post_content_filtered' doesn't have a default value]
    INSERT INTO tbg_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 ('2', '2006-06-13 00:49:42', '2006-06-12 23:49:42', '', 'whatistbg110.jpg', '', 'attachment', 'open', 'open', '', 'whatistbg110jpg', '', '', '2006-06-13 00:49:42', '2006-06-12 23:49:42', '1', '0', 'image/jpeg', 'http://localhost/tBG/wp-content/uploads/2006/06/whatistbg110.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 tbg_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 tbg_post2cat (post_id, category_id) VALUES (, 1)


    WordPress database error: [Out of range value adjusted for column 'post_id' at row 1]
    INSERT INTO tbg_postmeta (post_id,meta_key,meta_value) VALUES ('','_wp_attached_file','c:InetpubwwwroottBG/wp-content/uploads/2006/06/whatistbg110.jpg')

    The last few errors are a result of the first error where the fuction wp_insert_attachment isn’t returning any postid due to the mysql error.

    “[Field ‘post_content_filtered’ doesn’t have a default value]” – this field is a text/blob type it can’t have a default value, mysql will not allow it.

    (I tried anyway…)

    #1101 - BLOB/TEXT column 'post_content_filtered' can't have a default value

    When I try and insert a row into this table via mysql, I do not get any problems. I only get the error noted above from within WordPress.

    Now I’m stuck as to what the problem is, any help would be appericated.

    Platform: Windows XP Pro using its built in IIS5.5
    PHP Version: 5.1.4
    Mysql Build: 5.0.21-community-nt

Viewing 1 replies (of 1 total)
  • paradox_wp

    (@paradox_wp)

    19 years, 10 months ago

    Hello Shadowxj5

    I did have the same problem, seems to be how WordPress creates the fields in MySQL 5. It seems to be a bug in WordPress.

    It’s the database structure, that causes the problem, when it is initially created by WordPress. You need to alter the table structure once.

    Found it on a similar thread here:
    http://wordpress.org/support/topic/49232

    Solution:
    enable “Allow Nulls” for three fields in the database.
    The fields are in table “wp_posts“:
    – to_ping
    – pinged
    – post_content_filtered
    (I think for your problem, it’s only the last one).

    To do that, you need to alter the database. You can do it with the MySQL Command Line, but I preferred the MySQL Administrator graphical tool. So how to do that:

    – Open MySQL Administrator
    – Connect to your database server (localhost?)
    – Select Catalogs
    – Select your database (wordpress?)
    – Select table “wp_posts“
    – Select “Edit table” below
    – Unselect the tickmark at column “Not Null” for the three fields
    – Select “Apply Changes“

    When using text mode, this also should work, but is untested!

    mysql -u root -p wordpress

    ALTER TABLE wp_posts MODIFY COLUMN to_ping TEXT CHARACTER SET latin1 COLLATE latin1_bin, MODIFY COLUMN pinged TEXT CHARACTER SET latin1 COLLATE latin1_bin, MODIFY COLUMN post_content_filtered TEXT CHARACTER SET latin1 COLLATE latin1_bin;

Viewing 1 replies (of 1 total)

The topic ‘Error saving attachment to database’ is closed to new replies.