carlr

I’m getting this issue too with mysql 5.0.0.22 and WordPress 2.3.3 on CentOS release 5 (Final) on an intel Dell server.

I seem to be able to create one draft with an id 0. I can’t create any more after that. If I publish rather than save, the article appears to publish, but again still with an id of 0. Second and third published articles don’t appear in the manage list even though they appear to publish OK in the editor.

There is now error wordpress install, and when saving a draft I get

14 Query INSERT IGNORE INTO wp_posts
14 Query SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type = ‘post’ AND term_taxonomy_id = ‘1’
14 Query UPDATE wp_posts SET guid = ” WHERE ID = ‘0’
15 Query SELECT ID, post_title FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘draft’ AND post_author = 1 ORDER BY post_modified DESC
15 Query SELECT ID, post_title, post_author FROM wp_posts WHERE post_type = ‘post’ AND [strong]post_status = ‘pending’ AND post_author IN (1,2) AND post_author != ‘1’ ORDER BY post_modified ASC
15 Query SELECT ID, post_title, post_author FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘draft’ AND post_author IN (1,2) AND post_author != ‘1’ ORDER BY post_modified DESC
17 Query SELECT COUNT(*) FROM wp_posts WHERE post_type = ‘attachment’
17 Query SELECT COUNT(*) FROM wp_posts WHERE post_type = ‘attachment’ AND post_parent = ‘-1203501828’

When I try to edit that draft and the wordpress error message about delete post, there is no mysql output.

If I create and publish a new post I get an ID of 0 and cannot create and further new posts.
mysql log of the publish is

53 Query SELECT post_name FROM wp_posts WHERE post_name = ‘test2’ AND post_type = ‘post’ AND ID != ” AND post_parent = ‘0’ LIMIT 1
53 Query INSERT IGNORE INTO wp_posts
53 Query SELECT COUNT(*) FROM wp_term_relationships, wp_posts WHERE wp_posts.ID = wp_term_relationships.object_id AND post_status = ‘publish’ AND post_type = ‘post’ AND term_taxonomy_id = ‘1’
53 Query UPDATE wp_posts SET guid = ” WHERE ID = ‘0’
53 Query UPDATE wp_posts SET guid = ” WHERE ID = ”
54 Query SELECT ID, post_title FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘draft’ AND post_author = 1 ORDER BY post_modified DESC
54 Query SELECT ID, post_title, post_author FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘pending’ AND post_author IN (1,2) AND post_author != ‘1’ ORDER BY post_modified ASC
54 Query SELECT ID, post_title, post_author FROM wp_posts WHERE post_type = ‘post’ AND post_status = ‘draft’ AND post_author IN (1,2) AND post_author != ‘1’ ORDER BY post_modified DESC

You cannot view or edit the published post with id=0