WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] mysql shows error (2 posts)

  1. tmsajin
    Member
    Posted 7 years ago #

    i installed wordpress 204 version but when i try to upload files, it shows problems. it uploads to server path but not inserting to DB , this is the error message. i am using mysql version 5.0.22.

    below is the error message

    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-10-07 23:40:27', '2006-10-07 19:40:27', '', 'test', '', 'attachment', 'open', 'open', '', 'test', '', '', '2006-10-07 23:40:27', '2006-10-07 19:40:27', '5', '0', 'image/bmp', 'http://localhost/wordpress204/wp-content/uploads/2006/10/dhl.bmp')

    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:\AppServ\www\wordpress204/wp-content/uploads/2006/10/dhl.bmp')

    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:200;s:6:\"height\";i:158;s:14:\"hwstring_small\";s:23:\"height=\'96\' width=\'121\'\";s:4:\"file\";s:62:\"C:\\AppServ\\www\\wordpress204/wp-content/uploads/2006/10/dhl.bmp\";}')

    Warning: imageantialias(): supplied argument is not a valid Image resource in C:\AppServ\www\wordpress204\wp-admin\admin-functions.php on line 731

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

  2. tmsajin
    Member
    Posted 7 years ago #

    i tested with mysql version 4.1 and it works fine in that. so wordpress doesnt support mysql latest versions.
    hope the next version of wordpress will support that too.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags