Title: Created Posts don’t exist Last modified: August 19, 2016 --- # Created Posts don’t exist * [uta](https://wordpress.org/support/users/uta/) * (@uta) * [18 years, 4 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/) * I have my WordPress installed on my XAMPP server on my Mac, OS 10.4. The install was without error, I have created users but when I go to post it “appears” to save my post and display it on the front page, but if I click on the post I get the error message, “Sorry, no posts matched your criteria. Wanna search instead?” Also if I try to edit the post I get the error message, “You attempted to edit a post that doesn’t exist. Perhaps it was deleted?” What I have noticed is that it’s getting a “large” number assigned as a page ID. * 2147483647 2008-01-16 1:22:08 pm Ne Sachant Pas Uncategorized 0 magritte * If I go into myphpadmin and change the page ID to something smaller (like 4) then the page exist and performs normally. Why is this happening? Why would WordPress assign a page ID number like “2147483647”? Also of note that the default post that exists “Hello World” was also assigned a large page ID and exhibited the same issues previously stated. Help would be appreciated. Thanks in advance! Viewing 5 replies - 1 through 5 (of 5 total) * [carlr](https://wordpress.org/support/users/carlr/) * (@carlr) * [18 years, 2 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682499) * 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 * [eigho](https://wordpress.org/support/users/eigho/) * (@eigho) * [18 years, 2 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682500) * my guess, by reading the subject of your post, is that u may forgot CHMOD sumthin 🙂 * [narcisgarcia](https://wordpress.org/support/users/narcisgarcia/) * (@narcisgarcia) * [18 years, 2 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682509) * 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. * [evandonovan](https://wordpress.org/support/users/evandonovan/) * (@evandonovan) * [17 years, 11 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682544) * 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. * [evandonovan](https://wordpress.org/support/users/evandonovan/) * (@evandonovan) * [17 years, 11 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682545) * I found a workaround for this issue at the XAMPP forum ([http://www.apachefriends.org/f/viewtopic.php?t=29577&sid=8455d392b6a4c21a9d3e96141cbf914a](http://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 Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Created Posts don’t exist’ is closed to new replies. ## Tags * [mac](https://wordpress.org/support/topic-tag/mac/) * [xampp](https://wordpress.org/support/topic-tag/xampp/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 5 replies * 5 participants * Last reply from: [evandonovan](https://wordpress.org/support/users/evandonovan/) * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/created-posts-dont-exist/#post-682545) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics