Post_ID Auto_Increment Out of Whack!
-
I used this plugin to import some test products which we are porting over from another site. Since we’re synchronizing our products with another piece in our project, the product IDs (post_id) had to be predictable upon import (versus the auto_increment simply grabbing the next available one).
As a test, I set one of the IDs to 1000000 (1 million), and imported it. It was a success! It imported with the product ID of 1000000. After I was done with my test, I deleted the post and all instances in the database of the post_id of 1000000. However… when I created a post of any kind (page, product, etc) the next incremented post_id was 1000001, and so on.
I’ve tried resetting this… using…
ALTER TABLE 'wp_posts' AUTO_INCREMENT=2179
That didn’t work, neither did:
ALTER TABLE wp_posts MODIFY COLUMN ID bigint(20) unsigned NOT NULL auto_increment;
ALTER TABLE wp_postmeta MODIFY COLUMN meta_id bigint(20) unsigned NOT NULL auto_increment;
…and I even tried this:
https://github.com/arminrosu/WP-Reset-Post-IDsNothing is working! I am hoping there is a solution you might know and may be able to share. Thank you!
- The topic ‘Post_ID Auto_Increment Out of Whack!’ is closed to new replies.
