Forums

can not upload any files (7 posts)

  1. stefan21
    Member
    Posted 3 years ago #

    hello,

    my wordpress 2.0 installation works, but i can not upload any files when writing a new post.

    the following error occurs:

    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-01-03 10:05:53', '2006-01-03 09:05:53', '', 'wegbeschreibung.GIF', '', 'attachment', 'open', 'open', '', 'wegbeschreibunggif', '', '', '2006-01-03 10:05:53', '2006-01-03 09:05:53', '4', '0', 'image/gif', 'http://localhost/_sonabiles/wordpress/wp-content/uploads/2006/01/wegbeschreibung.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_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\_sonabiles\wordpress/wp-content/uploads/2006/01/wegbeschreibung.GIF')

    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:398;s:6:\"height\";i:515;s:14:\"hwstring_small\";s:22:\"height=\'96\' width=\'74\'\";s:4:\"file\";s:112:\"C:\\Program Files\\Apache Group\\Apache2\\htdocs\\_sonabiles\\wordpress/wp-content/uploads/2006/01/wegbeschreibung.GIF\";}')

    Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\Apache Group\Apache2\htdocs\_sonabiles\wordpress\wp-includes\wp-db.php:102) in C:\Program Files\Apache Group\Apache2\htdocs\_sonabiles\wordpress\wp-admin\inline-uploading.php on line 99

  2. stefan21
    Member
    Posted 3 years ago #

    Could please anybody help me with that?

  3. mniepert
    Member
    Posted 3 years ago #

    Could be a problem with your (individual) database. I tested your MySQL query on two different databases (Versions 3.23.58 and 4.1.14, both MyISAM) without any problems. What's your MySQL version and type?

  4. stefan21
    Member
    Posted 3 years ago #

    I use MySQL version 5.0, i am not sure whether wordpress uses InnoDB or MyISAM,...

    so you think I should try an older version of mysql?

  5. mniepert
    Member
    Posted 3 years ago #

    I would give it a try.

  6. mniepert
    Member
    Posted 3 years ago #

    Indeed, it seems to be a DB problem:

    http://wordpress.org/support/topic/52753?replies=10

  7. stefan21
    Member
    Posted 3 years ago #

    Ok... now I have installed MySQL 4.1 and everything works...
    perhaps the wordpress-guys will realease a 2.1 version soon that will as well work with the latest version of mysql

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.