Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Delete article and reset ID
I’ve been creating several dummy articles to test certain facilities within textpattern. Now that I have deleted them, can I reset the ID’s back to the lowest value? For instance, I have two genuine articles with ID’s 1 and 2. When I create a new article it is now giving it an ID of 6, however I wish to reset this to 3.
I’ve checked the forum but couldn’t find anything!
Saj
Offline
#2 2006-12-16 19:10:30
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Delete article and reset ID
You can only do that in the database. In phpMyAdmin, open the textpattern table and go to ‘Operations’. At the bottom of the page, under ‘Table options’, you see a field ‘auto_increment’. The value in there is the next id that will be used, you can change that. (But be careful, I don’t know what would happen if you’d set it to a value that’s already been used.)
Offline
Pages: 1