MyBB Community Forums

Hello. I wonder how the move postes from one user to another?

I made a mistake and removed one of my admins account.
I created new user with same username that i removed and was wondring how to change the posts to his new username.

I know there are SQL to run but did find it here in the forum... maybe i'm blind.

you could try
acp>users and groups>users>merge users

(2010-09-21, 11:56 AM)adbrad Wrote: [ -> ]you could try
acp>users and groups>users>merge users

But the user was removed and a created new user with same username in ACP but when i go to his posts i see his old username still there but with this text ''Unregistered'' below his username.

I think i need to update this via SQL but i could find any posts about it.

BTW
Is there no way to just change or update username in posts?

UPDATE `mybb_posts` SET uid = 'X' WHERE username = 'Y'

Replace X with the new users User ID and Y with the deleted users username.

Then Recount User Post Counts.

(2010-09-21, 05:45 PM)AJS Wrote: [ -> ]

UPDATE `mybb_posts` SET uid = 'X' WHERE username = 'Y'

Replace X with the new users User ID and Y with the deleted users username.

Then Recount User Post Counts.

Thank you