Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Assigning posts from one username to another
Avatar
Eric Grey
Member
Free Members
sp_UserOfflineSmall Offline
Nov 13, 2012 - 7:24 pm

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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 13, 2012 - 9:24 pm

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...

Avatar
David Norman
Member
sp_UserOfflineSmall Offline
May 23, 2016 - 10:52 pm

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 23, 2016 - 11:06 pm

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..

Avatar
David Norman
Member
sp_UserOfflineSmall Offline
May 23, 2016 - 11:14 pm

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?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 23, 2016 - 11:35 pm

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...

Avatar
David Norman
Member
sp_UserOfflineSmall Offline
May 24, 2016 - 12:48 am

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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 24, 2016 - 1:28 am

let us know how you get along...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625