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
No members found
Avatar
Blaise
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Nov 20, 2017 - 3:48 am

Hi,

In the SP admin panel, under Users / Member information I see no members found despite having 30K+ members:

http://prntscr.com/hcr137

Clicking on any of the member groups (Moderators, Donateurs) also results in "No Members found". 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 20, 2017 - 4:50 am

Odd. What versions are you using (WP and SP)?

I certainly can not replicate nor have we had any other reports of such behaviour.

Could you go the toolbox and open the error log. Empty it using the button at the bottom. Open the forum admin > Users page again and then go back to the errort log to see if anything gets reported.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Blaise
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Nov 20, 2017 - 9:24 am

Hi,

Error Log is empty.

I'm using WP 4.9

Simple Press 5.7.5.2

Latest versions AFAIK.

 

The other items in the Users tab display correct information. 

Not a huge issue really as I never used this up to now: it's more FYI. I can live without this menu 🙂

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 20, 2017 - 10:08 am

quite strange... that table just lists any users in the wp_users database table... so special sauce per se...  can you also check the php error log on the server?  and do you run special registration, membership or user plugin?

Avatar
Blaise
Member
Pro Subscribers
sp_UserOfflineSmall Offline
Nov 21, 2017 - 6:34 pm

You were right: I looked at my PHP log and found this relevant error after loading the SP member list page 

Column 'moderator' in field list is ambiguous

I have a var "moderator" in my wp_users table and you have the same var in your wp_sfmembers table: hence the ambiguous. 

No deal: I can live without this screen 🙂 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 21, 2017 - 6:40 pm

So must have been added by another plugin as its not part of standafs wp. 

We normally try to prefix columns with table name when using non simple press tables but obviously didn't here. And only issue when added by this other plugin. Will see if we can clean it up it next version 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 21, 2017 - 6:41 pm

Worth adding we csn give you a simple code change to fix if you like. 

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: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17357
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10123
Posts: 79616