Announcement

Collapse
No announcement yet.

Member ID Number Problem

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • Steve Machol
    replied
    Originally posted by Hawk2 View Post
    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.

    Leave a comment:


  • we_are_borg
    replied
    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.

    Leave a comment:


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

    Leave a comment:


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

    Leave a comment:


  • Trevor Hannant
    replied
    Originally posted by Hawk2 View Post
    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.

    Leave a comment:


  • Hawk2
    replied
    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
    Last edited by Hawk2; Fri 19th Aug '11, 8:55am.

    Leave a comment:


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

    Leave a comment:


  • we_are_borg
    replied
    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.

    Leave a comment:


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

    Leave a comment:


  • Avare
    replied
    So it means there is no solution for this problem ?

    Leave a comment:


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

    Leave a comment:


  • we_are_borg
    replied
    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.

    Leave a comment:


  • Avare
    started a topic [Forum] Member ID Number Problem

    Member ID Number Problem

    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 ?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X