[Forum] Member ID Number Problem

[Avare]

One of our administrators has deleted hundreds of spammers from the database,a lot of accounts have been deleted.And now when a new member joins the forum,the ID number is just as before those spammers have been deleted.I mean,when a new member joins, by viewing the profile the direction of the member is as this in the adress bar ; member.php?1068-(Nickname).It's 1068 but total number of the members are 739 (329 spammers were deleted).

Now what must I do to update this number as 740 for the latest member ? Is it possible to arrange all the ID Numbers regularly ?

[we_are_borg]

It can be done but don't if it goes wrong you will have one big problem on your hands. ID numbers that where deleted are kept and will not be used anymore this is ho the scripts work i would not tamper with that.

[Trevor Hannant]

As above, don't start playing with these auto_increment values or you could seriously screw something up in the database.

[Avare]

So it means there is no solution for this problem ?

[Trevor Hannant]

This isn't actually a problem - database records need to be kept unique so the relevant tables use auto increments to ensure this.

[we_are_borg]

Believe me when i say do not try to alter this, they way your describing it thats how it should work. ID numbers in vBulletin are auto increment this is the way its work and is programmed this goes for styles post id's, forum id's etc etc, there is no need to alter this.

[Avare]

Yes actually it doesn't effect anything technical,it's only about regularity Thank you anyway

[Hawk2]

ALTER TABLE `user`
AUTO_INCREMENT=740;


try this, change the 740 if you have more than this now remember always make it one more than you have

Note: Do this at your own risk

[Trevor Hannant]

ALTER TABLE `user`
AUTO_INCREMENT=740;


try this, change the 740 if you have more than this now remember always make it one more than you have

No DO NOT DO THIS!!!!

This will screw your database over as you will then have many other tables with incorrect IDs scattered through them.

[we_are_borg]

Well we warned that this is a bad idea and it really is.

[Hawk2]

I only put that there to give him the option should of wrote do this at your own risk

[we_are_borg]

Well the problem that you have with your solution is that you did not take in account that numbers under 740 could be deleted also if post exist you can couple old post to new users. So yes use at own risk should be included because when he does that his database will be worse just like Trevor said.

[Steve Machol]

I only put that there to give him the option should of wrote do this at your own risk

You should not give bad and damaging advice at all.

[Avare]

OK.As I see, it is not wise to play with these values.So I'll not change anything, thanks everyone