How can i solve about adding ID problem for new register?

[AngelGirl]

I am use SMF v2.02
After i delete about 19,xxx member of my forum
and then i register for new  member (zz) 

The ID not be No.3 but be No.19,347

Can i solve it for the new register in future?

ps. in this case , i can accept if must to delete another member post

[Branko.]

 Try via phpMyAdmin> check smf_members table and repair table.

[Arantor]

Repairing the table will do nothing, the table isn't broken.

It would be possible to modify this number through going into the table's options in phpMyAdmin and adjusting the auto-increment column in smf_members but this is really not recommended as it can cause issues elsewhere down the line.

[AngelGirl]

Thanks for your reply.

I try to set "auto-increment". and It 's work!

but i don't know how it can cause issues elsewhere down the line?.

[Arantor]

It can cause issues elsewhere given that there are other things which depend on the behaviour of id_member. But you've done it anyway so now all we can do is sit and wait and hope nothing goes wrong.