WordPress.org

Support

Support » How-To and Troubleshooting » Post IDs gone wild – how to fix the auto_incremented value?

Post IDs gone wild – how to fix the auto_incremented value?

  • Hello,

    I use wordpress 1.5. I’ve just discovered that my post IDs have gone kind of wild.
    They started the normal way with 1, then 2, 3, 4 and so on up to 28.
    But suddenly, and I don’t know why, there is no 29 but wordpress numbered new posts IDs starting with 2524, 2525, 2526 up to 2533. And now, when i create a new post, the ID will auto_increment from 2533. So I have a gap between 29 and 2523 that aren’t used.

    So I’d like to ask three questions. I would be very glad if some of you experimented users could answer :
    – Do you know what could have caused that?
    – Could it become problematic? I know IDs are an internal thing of wordpress, the visitors don’t really care, but I wonder if there could be, for example, a limit, or if something could go wrong as I have such a gap in the auto_incremented values?
    – If it could turn out to become a problem, how can i *fix* this wrong auto_incrementation? How can I tell wordpress to start again from 29 ?

    Many thanks to all of you who will take some time to help me.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The post ID is a 20-bit integer field, so it’s doubtful you’ll run out anytime soon. That said, it’s very odd that they’re being auto-incremented in such a fashion. Any goofy plugins?

    There probably is a query to run on the SQL database to correct the problem but I’m not experienced enough to advise on that issue.

    Why don’t you change your permalink structure? Then you would have your entries using a url that contained the post title vice the id number?

    That would aid in search engine discovery and eliminate the skipped id numbers.

    try:

    ALTER TABLE wp_posts AUTO_INCREMENT = 29

    Lorelle had this problem a while back…. might be some further info in that thread if you can find it.

    Thank you for your answers!

    – Marc : My permalink structure is not affected by this, it’s just an internal ‘cosmetic’ issue…

    – ColdForged : My plugins are ClickCounter, WPPlugin Manager, PHPExec,GetRecentComments,CustomizablePostsListings,BackupRestore,Authimage.
    – ColdForged : What would happen if I do the “ALTER TABLE …” sql trick? I would like to be sure there won’t be any collateral damage due to this sql request… and what do I do with the already-25xx-numbered IDs?

    – Vkaryl : I’ve found the post where Lorelle had a similar problem with the categories ID : http://wordpress.org/support/topic/29489

    Thanks a lot again

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Post IDs gone wild – how to fix the auto_incremented value?’ is closed to new replies.