Created Posts don’t exist

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

my guess, by reading the subject of your post, is that u may forgot CHMOD sumthin ??

Take care to not export database with “–compatible=mysql40” option. It causes the ID fields to have not “auto_increment” attribute.

When posts or comments tables don’t have “auto_increment” option on their ID fields, WordPress produces registers with ID 0 because WordPress assumes that the ID is autogenerated by MySQL.

It can also affect to uploaded files.

I am also experiencing the same error as uta, who began this thread. When I try to save or edit posts, WP says they do not exist. If I edit their IDs in PHPMyAdmin, they show up. I am running XAMPP v. 0.7.2 on Mac OS X 10.4.11 & have WordPress 2.5.1 installed.

I believe this is not the same error as that experienced by carlr, since I am unable to create any posts with an ID of 0.

Here are the IDs of the posts in my wp_posts table (in order of creation):
1 Title: Welcome to WordPress (this one shows up)
72057594037927937 Title: About (doesn’t show)
72057594037927938 Title: autoincrement (first one I created & tried to publish, doesn’t show)
144115188075855874 Title: draft (tried as draft, doesn’t show)
144115188075855875 Title: draft 2 (second draft, doesn’t show)

If I look at the other tables, the same thing is happening, except for on wp_term_relationships. wp_options shows the pattern of ID incrementing to its fullest extent:
1
72057594037927937
72057594037927938
144115188075855874
144115188075855875
216172782113783811
216172782113783812
288230376151711748
288230376151711749…and so on. There the settings can be changed properly, however, despite the ridiculous ID numbers.

If anyone can determine why the autoincrement functions improperly, it would be much appreciated.

I found a workaround for this issue at the XAMPP forum (https://www.apachefriends.org/f/viewtopic.php?t=29577&sid=8455d392b6a4c21a9d3e96141cbf914a). Apparently, it’s a problem with the autoincrement in XAMPP 0.7.2’s version of MySQL. Guess I’m going to have to install it using the Mac OS version of MySQL