I've dug around the fourms but can't find an answer.
I've recently moved a number of WP blogs from one host to a new host, and on the WP2.0 installs I'm getting this error when going to post:
WordPress database error: [Duplicate entry '0' for key 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',]
and it continues after this. Odd thing is though, it's only the WP 2.0 blogs, not the WP 1.5 blogs???
any ideas. I've checked .htaccess, it's writable and the permalinks structure is setup to include the date etc to avoid duplicates.