Advertisement:

Author Topic: How can i solve about adding ID problem for new register?  (Read 1449 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: 72,951
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.

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: 72,951
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.