Recently I was moving a large member list from phpBB to bbPress, and installed the Member list plugin as it was looking nice in another site. After the intial css work, I realised that something was wrong, that out of 4000 members only 2 was getting displayed in the list.
I decided to make this article as many or probably most of you in my situation will come across this situation.
To understand the problem, let’s analyse their query.
1 2 3 4 5 6 7
select distinct a.ID from wp_users as a, wp_usermeta as b where 1=1 and b.user_id = a.ID and a.ID NOT IN (0) and b.meta_key = 'last_name' order by b.meta_value asc
I got this by doing
In your case, it may be something else in the
b.meta_key field depending on what is selected in your settings page.
How to fix this :
Check the page MemberList > Settings in your dashboard.
Under Sort the members list originally by, chose something more neutral, like user name.