ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Reset auto increment URL

October 04, 2012 8:23am

Subscribe [2]
  • #1 / Oct 04, 2012 8:23am

    amityweb

    162 posts

    Hi

    I have been experimenting with importing over 5000 records into a channel entry. I have had to do this a number if times.

    It means the first entry ID is like 15000

    I know it probably does not matter that much, but I do like to be clean and tidy. I want to reset this back, I know how to do it in Phpmyadmin but wondered if anyone knows if any other tables will reference it. If its a couple of tables, fine, if its loads then it could be an issue!

    Thanks

  • #2 / Oct 05, 2012 4:51pm

    Dan Decker

    7338 posts

    Hi amityweb,

    Everything start with exp_channel_titles - you can delete all of the entries in the Control Panel, then TRUNCATE exp_channel_titles and it will reset entry ID at 1.

    Let me know if you have any questions!

    Cheers,

  • #3 / Oct 05, 2012 5:27pm

    amityweb

    162 posts

    thanks a lot I will give it a go (after a db backup of course!). I am up to about 30000 now! Although I dont think I need to import again after this.

  • #4 / Oct 08, 2012 12:57pm

    Shane Eckert

    7174 posts

    Hi amityweb,

    Did you get a chance to try this? How is it going?

    Cheers,

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases