Assing user ID

[Eagle Creek]

Hi!

When I go to:
member.php?u=2
I get:
Invalid User specified. If you followed a valid link, please notify the administrator

And that's correct. I made the user, didn't do anything with it and then deleted it.
But I want to have a user, using that ID.
So can I just make a new user, and then go into the dbase and change his ID to 2?

[Floris]

Nope, you have to run a bunch of queries because posts, privmsgs, threads, etc are all linked to the userid. Changing it might change a lot of things. We don't give support for this as it falls outside of the defaultl vBulletin functionality. The userid field is auto increment.

[Eagle Creek]

Nope, you have to run a bunch of queries because posts, privmsgs, threads, etc are all linked to the userid. Changing it might change a lot of things. We don't give support for this as it falls outside of the defaultl vBulletin functionality. The userid field is auto increment.

I understand it's auto and linked to many things.
But, the user 2 didn't had PB's, or posts or whatsoever.. It was just a user, who doesn't excist anymore.

[Eagle Creek]

I just changed, only the ID field, to 2 and it seems to be working..

Is there any change for big problems? Because I don't see problems atm. (going go try something out)

[Colin F]

You'll have to update the userfield and usertextfield rows as well, possibly also others.

[Eagle Creek]

Owh ok..

And could I just run a query where user ID = xxx, change it to 2?

I understand you don't advice it. But when the account is empty, no settings or whatsoever are made.

[Colin F]

Try running the 'Repair broken user profiles' function in your
AdminCP -> Maintenance -> Update Counters

That should add a row to either table.

[Eagle Creek]

So just change the ID and run that script.

Thank you mister Colin sir!

[Colin F]

I don't know if that will fix everything, but it'll help for sure.