Support Forum
Support Forum
Offline
Hi team
Hope you all had a Merry Christmas and pleasant start to the new year. I see from the forum posts you have been pretty busy with some... 'interesting' posts 
Now for mine...
I deleted my previous website developer from WP last year as she no longer needs access to my site or forum. She was previously a site and forum 'Admin'. However, I noticed she is still listed at the very bottom of my SP forum members list in the No Memberships section, now as a guest (see capture). I believe I had changed her to a Guest (no forum access), for the iterim period between when she didn't need access and when I decided I would not need her 'fallback' support anymore and deleted her from WP.
I have checked my WP, WLM (Wishlist Member) and SP user's lists and she is not shown on any of these lists. The only other place I can still see reference to her is in the list of possible SP admin options (see capture).
When I click on her 'Non-Member' listing at the botom of my member's list (top capture), to view her profile, I get a 'Guests' profile (see capture). When I click that Edit Profile link it just takes me to my own profile.
This isn't a big deal to me as no one can see who she is, though have finally gotten around to see if I can get her listing removed. I had a search of your SP forum without success so hope you can point me in the right direction.
Cheers,
David
http://www.alcohemy.com
Offline
you say you checked you sp user list? does this mean you checked your sfmembers table and the user is not listed there?
how did you delete the user? if from forum - users - member list, the user would have been deleted by wp, but any posts would have been converted to be by a guest...
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi Steve
I haven't checked sfmembers table. Not sure how to do this. The capture below shows the entry when I use the Data Inspector to view spMemberList.
I can't clearly recall how I deleted her (about mid last year), though suspect I changed her from Admin to a Guest in SP first, then deleted her from WP some months later after I knew i wouldn't need her to log in again.
She had only made a few forum 'test posts' in the development and testing months, though these were always deleted out afterwards. She has no existing posts to my knowledge.
Cheers,
David
Offline
Hi again
I managed to access the alc_sfmembers table on my server and her enrty is in there (see capture). It is not in the alc_users table on the server which appears to be the WP equivalent. I can't find an alc_wpmembers or wpmembers table.
Should I just delete her record from this server table?
Cheers,
David
Offline
are all the posts from this person showing up as guest? if so, yes, think you can delete the entry in the sfmembers table...
curious on the delete... because if you delete from wp user admin panel, it deletes from sfmembers too... but if you deleted from database, it wouldnt...
just to be safe, make a db backup before removing the entry... should be fine, but prefer having backup...
Visit Cruise Talk Central and Mr Papa's World
Offline
Thanks for that. I will delete her entry from the table after doing a db backup.
As mentioned in post #3 of this thread, she has no forum current posts to preserve.
Thanks for your asistance,
David
Offline
please let us know how you make out....
Visit Cruise Talk Central and Mr Papa's World
Offline
Yes her 'No Memberships' listing is now gone from the bottom of the Members List page.
I am pretty sure (not 100%) that originally did her deletion via WP, not SP.
Anyway all good now and thanks for your help.
Cheers,
David
Offline
Unusual for one to be orphaned like that. Deleting a user via WP - or SP - fires a standard WP hook to ensure the user is removed from all data places. Something must have interrupted the process here. Glad you were able to sort it out.
 |
YELLOW
SWORDFISH
|
All RSS1 Guest(s)