We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Re-Index document id's

    • 18436
    • 135 Posts
    Marschant Reply #1, 18 years, 2 months ago
    Is there a way to re-index the document id’s? Through all the testing my id values have grown quite high, while not being a major problem I was wondering if we could re-index the primary keys?
    • sottwell Reply #2, 18 years, 2 months ago
      For one thing, that would break any [~xx~] links you have.

      If it’s a test installation, and you are willing to empty out the table, you can trucate the table then set its auto_increment value (at the bottom of the "operations" tab in phpmyadmin) to 1. Then it will start all over.

      The sql for that is 

      ALTER TABLE table_name SET auto_increment=1


      I’m not positive, but I think that TRUNCATE table_name will automatically set the auto-increment back to 1.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org