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?
- The topic ‘WP 2.0: datetime errors when saving post’ is closed to new replies.