Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago [How To?] Merge posts by guest with new account? [Happily Resolved]
#1
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
I accidentally deleted a member during an anti-spam spree and so their post(s) are now on the db as by an 'Unregistered' user.

I know it is possible to merge two accounts, but is it possible to merge post(s) by this 'guest/unregistered' account to a new 'registered' account please?

ThanksBlush
Current motto: Cross referencing threads by providing links is a good idea!
Back-on Online - Back-on Fansite
http://www.backon-online.com/

WordPress Snippets
http://www.wpsnippets.com/
#2
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
Hmm... are there any posts that are by 'Unregistered' that weren't made by this user?? I.e. if something like this happened before and there are a few other 'Unregistered' posts.

We can reassign all the posts that are 'Unregistered' to this user but we wouldn't be able to tell what posts were theirs and what ones could have been made by somebody else, if you see what I mean.
Can you still feel the butterflies?

Free never tasted like pudding.
#3
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
(08-07-2010, 10:46 AM)flick Wrote:  I accidentally deleted a member during an anti-spam spree and so their post(s) are now on the db as by an 'Unregistered' user.

I know it is possible to merge two accounts, but is it possible to merge post(s) by this 'guest/unregistered' account to a new 'registered' account please?

ThanksBlush

That would be possible as well. Run this query at your phpmyadmin

PHP Code:
UPDATE mybb_posts SET uid x WHERE username 'deleted_user_username'

Replace x with the user id of the new registered user whom you want to attribute the posts of the deleted user and replace deleted_user_username with the username that your deleted user used to have before he deleted his account.

It will work. As it happens, I did it only yesterday at my own forum too for a couple of deleted users who came back.

If you want to restore back the deleted threads too, run this query

PHP Code:
UPDATE mybb_threads SET uid x WHERE username 'deleted_user_username'

And replace accordingly the values as explained above. Also if your db tables use another prefix other than the default mybb_ then you should use that instead when running the queries.

Then go to your Admin Panel->Tools & Maintenance->Recount & Rebuild and run the first 4 options there.
#4
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
Oh yeah, it still stores the username doesn't it.
Can you still feel the butterflies?

Free never tasted like pudding.
#5
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
@MattRogowski & Bubulang: Thank you for your help! I'm going to try out the phpMyadmin query method and hope I don't mess up further along the way - am so glad that MyBB stores usernames Big Grin
Current motto: Cross referencing threads by providing links is a good idea!
Back-on Online - Back-on Fansite
http://www.backon-online.com/

WordPress Snippets
http://www.wpsnippets.com/
#6
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
If you backup your database in the MyBB ACP or phpMyAdmin you'll be fine in case something goes wrong; not that this query should do anything it shouldn't just in general.
Can you still feel the butterflies?

Free never tasted like pudding.
#7
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
MattRogowski is right. You should make a backup first of your posts and threads table before running the queries, just in case.
#8
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
Thank you both again! Heart

I saved a copy of the db using MyBB ACP to select the mybb_ tables, and have just finished following bubulang's guide step-by-step - everything is back to normal.

* flick is v. happy! Blush
Current motto: Cross referencing threads by providing links is a good idea!
Back-on Online - Back-on Fansite
http://www.backon-online.com/

WordPress Snippets
http://www.wpsnippets.com/
#9
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
(08-07-2010, 07:29 PM)flick Wrote:  Thank you both again! Heart

I saved a copy of the db using MyBB ACP to select the mybb_ tables, and have just finished following bubulang's guide step-by-step - everything is back to normal.

* flick is v. happy! Blush

I am glad to hear that you got it back to normal. And thank you for the rep you gave me Smile
#10
Solved: 4 Years, 1 Month, 4 Weeks, 2 Days, 2 Hours, 6 Minutes, 36 Seconds ago
ok i mean thank you for sharing, but i dont know where to go to do this like where do i go to upldate it i cant even find th update and x y and all that so could you please please tell me stem by stem please......]

Thank yu


Forum Jump:


Users browsing this thread: 1 Guest(s)