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
Cache or Clear User Post Count
Avatar
salp
Member
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 11:36 am

I recently had gConverter, merge two users together in SP (and WP) and all the post correctly merged, but the post count and the user that should be gone, is still showing up on Top Posters and with all post counts.  But If I click on this user, his profile says hes a guest.

 

Any help?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 1:35 pm

sorry, merge two users???  there are not wp users and sp users... only wp users... we just use the wp users...

so not sure what you did...

but for every user entry (ie row) in the wp users table, there will be corresponding entry in the sfmembers table... this is not different users, but additional forum data...  do you have a 1 to 1 mapping?

Avatar
salp
Member
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 1:55 pm

Both user in WP were merged together all post going to one  If you click on Sal(12) from the Administrators menu at the bottom and View Profile and select topics I have posted in it will show 89.  If you select salpst(242) from top posters it now shows this user as a guest with no posts.  The merged worked, but some how the user post count has not updated.

 

Check it out --> http://www.poolservicestech.com/forum

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 2:20 pm

No, cant look... you dont allow guests to view profiles...

but you didnt answer my questions either...  I have no idea what you did in merging two users...  did the sp data get merged too?

Avatar
salp
Member
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 2:28 pm

PM sent with log in info, As far as I know they did,  gConverter converted over, they new what I wanted.  Like I said, it lookl like it worked, but the post count has not updated.  

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 9:59 pm

is it really the post count?  or the stats?  are your stats updating?

Avatar
salp
Member
Free Members
sp_UserOfflineSmall Offline
Apr 24, 2013 - 10:23 pm

Stats are updating, yes!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 25, 2013 - 2:11 am

Well 5.3 when released (when WP 3.6 finally does) will have a toolbox housekeeping task to enable the rebuild of user post counts. Until then the only option is to to manually change it in the database ('sfmembers' table, 'posts' column).

andy-signature.png
YELLOW
SWORDFISH
Avatar
salp
Member
Free Members
sp_UserOfflineSmall Offline
Apr 25, 2013 - 11:07 am

Bingo!  That fixed it!!!  Thats what I was looking for!

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 25, 2013 - 11:15 am

OK - good to know.

andy-signature.png
YELLOW
SWORDFISH
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