Support Forum

Deleted 'ex-admin' WP user still shows as 'Guest' in SP members?

DN David Norman
David Norman
Member
Member since Feb 2014
107 posts
Jan 11, 2015 · 6:23 pm · Edited

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 smile

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.

SP-Members-List.jpg

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

SP-admin-options.jpg

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.

SP-Guest-Profile.jpg

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
www.alcohemy.com

SP-Members-List.jpg SP-admin-options.jpg SP-Guest-Profile.jpg

8 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 11, 2015 · 7:16 pm

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…

DN David Norman
David Norman
Member
Member since Feb 2014
107 posts
Jan 11, 2015 · 7:57 pm

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

SP-spMembersList.jpg
SP-spMembersList.jpg
DN David Norman
David Norman
Member
Member since Feb 2014
107 posts
Jan 11, 2015 · 9:16 pm

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,
DavidSPalco_-sfmembers-table.jpg

SPalco_-sfmembers-table.jpg
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Jan 11, 2015 · 11:03 pm

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…

DN David Norman
David Norman
Member
Member since Feb 2014
107 posts
Jan 12, 2015 · 12:00 am

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

DN David Norman
David Norman
Member
Member since Feb 2014
107 posts
Jan 12, 2015 · 2:37 am

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

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jan 12, 2015 · 3:36 am

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.