XF 2.1 How to change UID?

Status
Not open for further replies.
KateAwpton

KateAwpton

Member
Hello! I was wondering how to change the uid of a new registered account. my user id is 4 but 2 and 3 are deleted accounts, how would i go about either restoring those accounts or creating a new account in their place?
 
Sort by date Sort by votes
Brogan said:
Deleting all members and posts won't reset the increment.

It would require direct DB manipulation to re-use IDs and it's not something we would condone or be able to support.
Click to expand...
I’ve seen it done before, if I permanently delete an account I should be able to use the uid again for another account, or at least restore the accounts... is any of this possible?
 
Upvote 0 Downvote
Make a fresh install and then never delete a user would solve it or try to live with gaps in the UID list.
For a new forum it should be a smaller problem than getting users and content.
 
Upvote 0 Downvote
KateAwpton said:
No way I could specifically delete a user db or anything and just reinstall that?
Click to expand...
A lot of things you could do. I think, if you have phpMyAdmin or something, you can delete all users except for 1. As it's auto-increment, the next member that joins should be 2. Or, rebuild the entire table from scratch (though, the UID's are linked elsewhere, such in posts... so you'd have to modify them too).

Then, just change the post content ownership when the new members join to match who posted what.

Otherwise, start from scratch.

It's a little OCD to be thinking that missing a UID is important unless you just want the top 25-100 to have a claim to being that user ID down the line. If you think UID is important, wait until you get into having 10+nodes and then finding out you need the 11th node, but in the 1st category so it goes node id 1, 2, 11 (you can remove node ID in the URL portion), but, the IDs are irrelevant IMO. You're going to have UID gaps, I believe when it comes to profiles when it comes to banned/unconfirmed/unregistered or something because I have X users, but UIDs are 35+ more than actual members and I never deleted any.

The easiest, and probably recommended way, would do a fresh install as you have so few members, and likely few posts too. Save all posts (if necessary) and then repost them under in admin in a private node, reassign them to the new accounts with an add on after they rejoin, then move them to the new forums created.
 
Upvote 0 Downvote
frm said:
A lot of things you could do. I think, if you have phpMyAdmin or something, you can delete all users except for 1. As it's auto-increment, the next member that joins should be 2. Or, rebuild the entire table from scratch (though, the UID's are linked elsewhere, such in posts... so you'd have to modify them too).

Then, just change the post content ownership when the new members join to match who posted what.

Otherwise, start from scratch.

It's a little OCD to be thinking that missing a UID is important unless you just want the top 25-100 to have a claim to being that user ID down the line. If you think UID is important, wait until you get into having 10+nodes and then finding out you need the 11th node, but in the 1st category so it goes node id 1, 2, 11 (you can remove node ID in the URL portion), but, the IDs are irrelevant IMO. You're going to have UID gaps, I believe when it comes to profiles when it comes to banned/unconfirmed/unregistered or something because I have X users, but UIDs are 35+ more than actual members and I never deleted any.

The easiest, and probably recommended way, would do a fresh install as you have so few members, and likely few posts too. Save all posts (if necessary) and then repost them under in admin in a private node, reassign them to the new accounts with an add on after they rejoin, then move them to the new forums created.
Click to expand...
what table are users stored in?
 
Upvote 0 Downvote
I have locked this thread as nothing good is going to come from this (based on the posts).

Either accept that there will be gaps in the IDs or reinstall XF.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

L
  • Question Question
XF 2.3 How to change cookies for GDPR?
Replies
0
Views
18
Lucandi
L
D
  • Question Question
XF 2.3 How to change website icon in search engines?
Replies
2
Views
70
Dinsavar
D
D
  • Question Question
XF 2.3 How to change sub-forum title colors?
Replies
0
Views
48
Doruk
D
biafraland
  • Question Question
XF 2.3 How to Change Default Style From Database
Replies
0
Views
37
biafraland
biafraland
securedme
  • Question Question
XF 2.3 How to change background color of a particular node？
Replies
3
Views
48
Mr Lucky
Mr Lucky
Back
Top Bottom