Merge posts deleted user with existing user

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
new777
Registered User
Posts: 94
Joined: Thu Oct 03, 2013 6:51 am

Merge posts deleted user with existing user

Post by new777 »

Title should explain the question, but,

I have a deleted user, who rejoined and would like all her old posts and topics/post counts merge into the existing new (hers) members name.

I have full access to the database, just not sure which fields to edit.

Now the old topics/posts show the old DELETED username.

Thanks for any help
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Merge posts deleted user with existing user

Post by Oyabun1 »

Not sure how you can have posts from a deleted user showing their username, but install the Support Toolkit and use the USER/GROUP TOOLS > Merge users tool.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
new777
Registered User
Posts: 94
Joined: Thu Oct 03, 2013 6:51 am

Re: Merge posts deleted user with existing user

Post by new777 »

The old username just shows under the posts in non-linked gray, that needs to be changed to the new username and with full counts if possible
Oyabun1 wrote:Not sure how you can have posts from a deleted user showing their username
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Merge posts deleted user with existing user

Post by Oyabun1 »

You will need to use the Restore deleted users tool first.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Merge posts deleted user with existing user

Post by KevC »

Sounds more like the original account was merely deactivated rather than deleted. That would mean you could just look it up and turn it back on again and create a new password for the old user.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
new777
Registered User
Posts: 94
Joined: Thu Oct 03, 2013 6:51 am

Re: Merge posts deleted user with existing user

Post by new777 »

No the user does NOT show up anywhere in the ACP members or members list anymore.

Was deleted and not the posts, which keeps the posts and the username in grey, but dead
Locked

Return to “[3.0.x] Support Forum”