UBB.Developers Forums UBB.threads 7 Development How Do I? another member number question..

I am not real sure how to ask this, but I'll give it a shot. Is there a way to start the Member Number over in MySQL?

When I first setup the new forum, 6.2.3, I pre-registered everyone from the previous forum software we were using. It sent out the activation email as it's suppose to, but not everyone verified the account within the 24 hour period and the pre-registration was deleted. The member number was jumped over to the next. A few people went in and re-regitered after figuring out what happened. I went into the MySQL database and changed the number to their origional number and it worked fine.

The problem I am having now is that the next member number is in the 80's where the true members numbers ae in the 50's. Is there a way to delete those numbers in the middle and move everyone up?

Thanks,

BWilliams

If I understand you, you have some users with low numbers, some with high numbers, a gap in between, and you want to remove that gap?

The user numbers are stored in many database tables. There's no easy way to get rid of that gap.

I'd recommend leaving it as it is. You'll probably get additional gaps over time, anyway.

That is the exact problem. I don't mind small gaps in the future as I know it is going to happen, but I only have 50 or so registered right now and wanted to fix it before it got in the thousands.

The gap is like 35...

Thanks,

BWilliams