WordPress.org

Ready to get started?Download WordPress

Forums

Post IDs gone wild - how to fix the auto_incremented value? (6 posts)

  1. IncipitBlog
    Member
    Posted 9 years ago #

    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.

  2. ColdForged
    Member
    Posted 9 years ago #

    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?

  3. Marc
    Member
    Posted 9 years ago #

    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.

  4. ColdForged
    Member
    Posted 9 years ago #

    try:

    ALTER TABLE wp_posts AUTO_INCREMENT = 29

  5. vkaryl
    Member
    Posted 9 years ago #

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

  6. IncipitBlog
    Member
    Posted 9 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic