Reset categories id history
By Philippe on Saturday, 29 April 2017
Posted in Technical Issues
Likes 0
Views 460
Votes 0
Hello,

If I create a new category (monday for example), its ID is equal to the previous ID +1.
If I delete this same new category (monday), and then I create a new category (Tuesday for example), its ID is curiously equal to the ID of the deleted category (monday) +1.
Instead of an ID equal to the previous ID (real) +1.

So my question is, how to reset the history of deleted ID categories ?

This question is valid for EasyDiscuss and EasyBlog.
Thank you

Philippe
Hello Philippe,

Yep, you can but you need to understand that the category table could be related to another table. For instance post assignments etc. Just make sure that the previous and current category id isn't related to any posts.
Mark
·
Sunday, 30 April 2017 01:25
·
0 Likes
·
0 Votes
·
0 Comments
·
The id's are incremental in the database schema. We don't store the count of items. Most RDBMS does this as well.
Mark
·
Sunday, 30 April 2017 00:23
·
0 Likes
·
0 Votes
·
0 Comments
·
OK thank you Mark.
So can I manually change the ID value of the category in the database?
First I will make sure that no post are either attached.
Philippe
·
Sunday, 30 April 2017 01:08
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok thank you Mark
Philippe
·
Monday, 01 May 2017 20:29
·
0 Likes
·
0 Votes
·
0 Comments
·
You are most welcome Philippe
Mark
·
Monday, 01 May 2017 21:21
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post