Advertisement:

Author Topic: How can i solve about adding ID problem for new register?  (Read 1466 times)

Offline AngelGirl

  • Semi-Newbie
  • *
  • Posts: 10
How can i solve about adding ID problem for new register?
« on: July 03, 2012, 04:29:53 AM »
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





Offline Branko.

  • SMF Hero
  • ******
  • Posts: 3,330
  • Gender: Male
  • U zemlji slijepih, jednooki je kralj
    • SATForum
Re: How can i solve about adding ID problem for new register?
« Reply #1 on: July 03, 2012, 08:25:03 AM »
 Try via phpMyAdmin> check smf_members table and repair table.
Strong people don't put others down, they lift them up.
A clever person solves a problem. A wise person avoids it.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 73,189
Re: How can i solve about adding ID problem for new register?
« Reply #2 on: July 03, 2012, 09:50:27 AM »
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.
No good deed goes unpunished
All helpful urges should be circumvented

Offline AngelGirl

  • Semi-Newbie
  • *
  • Posts: 10
Re: How can i solve about adding ID problem for new register?
« Reply #3 on: July 03, 2012, 01:01:30 PM »
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?.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 73,189
Re: How can i solve about adding ID problem for new register?
« Reply #4 on: July 03, 2012, 03:45:40 PM »
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.
No good deed goes unpunished
All helpful urges should be circumvented