WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] mysql shows error

[Resolved] mysql shows error

  • 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

Viewing 1 replies (of 1 total)
  • 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.

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] mysql shows error’ is closed to new replies.