Customizing SMF > SMF Coding Discussion

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

(1/1)

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)  ;D

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.

Navigation

[0] Message Index