Need Some Motivation After Messing Up the User Counter

[VisEntities]

Hey everyone,

I messed up, and I need some consolation and motivation right now. While testing and preparing my site, I ended up creating a bunch of fake test accounts, and now my user counter is up to 10. Now I can't have my second serious account be user number 2 anymore (though my super admin account is still number 1 thankfully)

I'm pretty bummed about wasting 9 precious user counters during testing. There's no way to reset it, so I'm stuck with this goofup. If anyone's got some words of wisdom or a funny story to share to cheer me up, it'd be nice

 

[jeb35]

If you are that concerned, just delete the users and the member count goes back down. member id's don't change but member count does.

 

[philmckrackon]

Imo, IJDM...

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[MySiteGuy]

Just rename account #2 and set its user groups as needed.

 

[btmgreg]

Just rename account #2 and set its user groups as needed.

Good idea.

With 9 names to think of, you could have..

WalterW
WalterJR
Skyler
IfckdTed (lurker account)
SaulGood
Todd
BMXKid
Shrader
Mikey

(Triple dare you @VisEntities )

 

[VisEntities]

Just rename account #2 and set its user groups as needed.

I removed them all...

 

[VisEntities]

If you are that concerned, just delete the users and the member count goes back down. member id's don't change but member count does.

sorry, I meant the member id that comes at end /members/username.1/

 

[Old Nick]

Life is hard…

 

[Mr Lucky]

Now I can't have my second serious account be user number 2 anymore

If it is important, you could just merge user 11 into user 2. Before doing so delete all user 2 posts, then copy user 11 profile settings etc to user 2 . (Note that you won't be able copy the email address from 11 to 2 so make a note of it and change it after the merge).

Then set the account security lock to needing a reset password.

 

[VisEntities]

If it is important, you could just merge user 11 into user 2. Before doing so delete all user 2 posts, then copy user 11 profile settings etc to user 2 . (Note that you won't be able copy the email address from 11 to 2 so make a note of it and change it after the merge).

Then set the account security lock to needing a reset password.

it was too late, I deleted all these 2-9 accounts

 

[CedricV]

it was too late, I deleted all these 2-9 accounts

Wait until your site goes live and you'll end up with a few spam accounts, you'll learn it the hard way that the count does not matter.

A word of advice for the peace of mind:

 

[shri]

How to reset AUTO_INCREMENT in MySQL

How can I reset the AUTO_INCREMENT of a field? I want it to start counting from 1 again.

stackoverflow.com