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
What happens to attributed forum posts when a user is deleted?
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 7, 2014 - 9:55 pm

well, figured there were some gotchas... ;)

before trying any of this, please make a db backup in case things go wrong and you need to restore...

easy enough to change the poster...  this query:

UPDATE wp_sfppost SET user_id=xxxx where guest_name='yyyy'

replace xxxx with user id you want to own the post and yyyy is the old display name of the user that was turned into a guest (leave the quotes in there)...

but unfortunately, no easy way via simple query to fix the topic starter... not sure you would even notice it though... so might be worth trying just changing the post owner...

then go to forum - toolbox - housekeeping and:

reset each forum index
clean up post counts
flush the general cache

and see how that does for you...

Avatar
Jan Bosman
Member
Free Members
sp_UserOfflineSmall Offline
Oct 8, 2014 - 4:30 am

Thanks, Papa! 

That did it. 

Avatar
Ike
Sawtry, UK
Member
Free Members
sp_UserOfflineSmall Offline
Oct 8, 2014 - 4:35 am

Glad we could help.

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