I’ve completed lots of testing and data imports on a new site, so my entry_id values are now up into the 10,000’s. How can I reset the “next created” entry_id back to 1, now that I have deleted all my test entries?
I understand that in EE2 it could be done by editing the exp_channel_titles database table: ALTER TABLE exp_channel_titles AUTO_INCREMENT = 1
But I can’t see that data in this table on an EE5 install.
Solved it. In phpMyAdmin, I went to the exp_channel_titles table. I then clicked on the Operations tab. The AUTO_INCREMENT value for this table is displayed and is editable here.
I just reset the value back to what I needed, for the next newly-created Entry - in this case 277, as I wanted to keep all my existing entries up to ID 276. When I created a new Entry in EE, it was given the Entry ID of 277. The AUTO_INCREMENT value in the table is showing as 278.
Packet Tide owns and develops ExpressionEngine. © Packet Tide, All Rights Reserved.