WordPress.org

Support

Support » How-To and Troubleshooting » WP 2.0: datetime errors when saving post

WP 2.0: datetime errors when saving post

  • 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

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WP 2.0: datetime errors when saving post’ is closed to new replies.
Skip to toolbar