Support Forum

Assigning posts from one username to another

EG Eric Grey
Eric Grey
Member

I’ve recently had to switch membership systems, which has resulted in users having to create new accounts (long story).  A handful of these users have prior posts within Simplepress.  Those users new accounts do not show those posts as being from them – which is not a HUGE deal.  But, I was wondering if there is any way to merge users or otherwise indicate that posts should be associated with another user than who posted them initially.

Thanks.

7 Answers

New Answer

MP Mr Papa
Mr Papa
Member

no afraid no way to merge users… you can reassign posts, but that would be one by one… or via php/mysql script…

as you have discovered, the posts are distinctly tied to the wp user database… if those users change, all posts will be attributed to guests…

DN David Norman
David Norman
Member

Hi guys

Has this changed in subsequent versions?
When my developer redeveloped my site and hosted on a new server, they recreated my WP User ID on the new site (User Name, Name, email etc.) and brought all the SP files across from the old site.

However, now on the new site SP shows I (as admin) have no posts assigned to me and all my old posts (71 as admin for the old site) now show my name as Guest with no Gravatar. I can see how it used to look because we have the old site restored on their test server. The SP ID number has also changed from 1 (old site) to 21 (new site).

Is there a way to have all my old posts assigned back to me?

Thanks,
David
Alcohemy.com

MP Mr Papa
Mr Papa
Member

you will have to do in the db via phpmyadmin (via mysql query) or manually (there is a reassign post in the forum tools)….  we have always maintained the there are no simple press users, only site (WP) users…  if its a simple as changing user id from 1 to 21, the former is quick and easy..

DN David Norman
David Norman
Member

OK, thanks.

From my view it looks like they have set me up in WP the same user with the same details, though I guess as it was ‘recreated’ on the new site that SP gave it a different ID to what came across with the old SP files.
Would you expect that is why and they couldn’t have done it any differently?

MP Mr Papa
Mr Papa
Member

No, we dont assign a user id… its based on the wp user id…  you would have needed both the wp users table and the wp users table for correlation…  the sp user table is relational and points to the wp user table… so if both were copied over with the group, forum, posts, etc tables, they should line up…

now…. if you created a new user in wp, then of course it wouldnt match to the relational entry in sp… when the new wp user is created, the sp data is set up to point to the new user…

DN David Norman
David Norman
Member

Ahhh… bewdy! That ties all in for me. Thanks.
I will see if my old login data is still there on the old site and get them to copy it across and see if it all correlates. No one has added any posts since the transfer so should be all good.

Cheers,
David