WordPress.org

Ready to get started?Download WordPress

Forums

WP 2.0: datetime errors when saving post (3 posts)

  1. Michael_
    Member
    Posted 8 years ago #

    First of all: I searched this forum and I searched the web, but did not yet find any similar problem of another user.

    I have installed WP 2.0 on a Windows XP machine, using apache 2.0.55, php 5.1.1 (module), MySQL 5.0.17. This installation works like a charm, no problem with it using other PHP/MySQL apps.
    Also, with WP 2.0 everything is working, except one issue:
    When writing a new post (Admin -> Write -> Write Post), and pushing the SAVE button, the following error message occurs:

    ==================================================
    WordPress database error: [Incorrect datetime value: '' for column 'post_date' at row 1]
    INSERT INTO wp_posts (post_author, post_date, post_date_gmt, post_content, post_content_filtered, 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) VALUES ('1', '', '', 'gfdsg', '', 'fdhg', '', 'draft', 'open', 'open', '', '', '', '', '', '', '0', '0', '')

    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)
    ==================================================

    Hmm, it appears as if there's an empty datetime value (Incorrect datetime value: '').
    If I activate the "Edit timestamp" option, the post can be saved with no error message.

    Seems being a bug, but I am not sure, since I couldn't see any more users having this problem...
    Everything else works. I already re-installed wordpress, re-installed MySQL, but the same error occurs.

    What are your thoughts on this?

    Thanks,
    Michael

  2. moshu
    Member
    Posted 8 years ago #

    It might be the same issue as in this thread:
    http://wordpress.org/support/topic/53655

  3. Michael_
    Member
    Posted 8 years ago #

    Thanks moshu. Yes it seems being the same issue.

    Michael

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags