avdesigns Posted December 14, 2011 Report Share Posted December 14, 2011 Hi I am experiencing some problems with ids if the next available Id is 2 it gives the user 4 this happend after I deleted 2 users, thanks in advance Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted December 14, 2011 Report Share Posted December 14, 2011 ID is an auto-increment. If you delete a an ID you would need to modify the table to reset the auto increment. This should only be done if you know what you are doing. Quote Link to comment Share on other sites More sharing options...
avdesigns Posted December 14, 2011 Author Report Share Posted December 14, 2011 ID is an auto-increment. If you delete a an ID you would need to modify the table to reset the auto increment. This should only be done if you know what you are doing. Please can you help me do this? Quote Link to comment Share on other sites More sharing options...
Jeff Posted December 14, 2011 Report Share Posted December 14, 2011 It is best to leave this function alone. It will only continue to skip ID's when you delete members you already approved (for membership). It does not skip rejected members ID's (unless there are more than one (registrations) at the same time). Changing Pilot ID's can really mess your system up. I had stated in several posts about this subject "People will always join and leave your site. You will never be able to keep up with pilot ID's when you get a substantial amount of members". Quote Link to comment Share on other sites More sharing options...
avdesigns Posted December 14, 2011 Author Report Share Posted December 14, 2011 Thanks lorathon and Jeff got it sorted now, it was acctually really easy thanks to one.com but I suppose not all providers make it easy. Thanks Again Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.