WP User Search Not Working

I saw this thread on the topic, but see that it was really never addressed: http://www.s2member.com/forums/topic/cant-search-for-s2member-users-within-wp/

Recently updated to the newest version of S2Member Pro on a multisite install and now every time I search for a user, I get the following message: “No matching users were found.” Same thing happens when I search for a user from the main Admin page. These users are definitely in the system, as you can page through all users and find them…but they do not show up when I search for their email or whatnot.

Any help would be huge on this, many thanks in advance!

James, are you using the latest s2Member? One of the latest releases improved the users search. http://www.s2member.com/changelog/

If that doesn’t help, could you try these? Knowledge Base » Common Troubleshooting Tips

Thanks for your response, Cristian. Yes, using the latest version of S2Member on a multisite install. When I deactivate S2Member, my user search works just fine. When I reactivate it, the user search no longer works. Can’t find any plugins that are conflicting with S2Member at this point.

Okay. Could you submit your site’s info so I show it to Jason to investigate? s2Member® » Private Contact Form

I am having the same issue. Although I have 8,000 members, and it is taking down our whole server when we do a search. It locks the wp_usermeta table so that no other query can run. The only way to bring the server back is to kill the query.

We have a dedicated server with 32 G of RAM, so it definitely isn’t the server.

Here is the query that locks:

SELECT SQL_CALC_FOUND_ROWS wp_users.ID  
FROM `wp_users` 
INNER JOIN `wp_usermeta` ON `wp_users`.`ID` = `wp_usermeta`.`user_id`  
WHERE '1' = '1' AND ( 
(`wp_usermeta`.`meta_key` = 'wp_s2member_subscr_id' AND `wp_usermeta`.`meta_value` LIKE '%SEARCH-STRING%') OR 		(`wp_usermeta`.`meta_key` = 'wp_s2member_custom' AND `wp_usermeta`.`meta_value` LIKE '%SEARCH-STRING%') OR (`wp_usermeta`.`meta_key` = 'wp_s2member_custom_fields' AND `wp_usermeta`.`meta_value` LIKE '%SEARCH-STRING%') OR (`wp_usermeta`.`meta_key` = 'wp_s2member_notes' AND `wp_usermeta`.`meta_value` LIKE '%SEARCH-STRING%') OR (`wp_usermeta`.`meta_key` LIKE '%_name' AND `wp_usermeta`.`meta_value` LIKE '%SEARCH-STRING%') OR 
`user_login` LIKE '%SEARCH-STRING%' OR 
`user_nicename` LIKE '%SEARCH-STRING%' OR 
`user_email` LIKE '%SEARCH-STRING%' OR 
`user_url` LIKE '%SEARCH-STRING%' OR 
`display_name` LIKE '%SEARCH-STRING0%'
) AND `wp_users`.`ID` IN(
	SELECT DISTINCT(`user_id`) FROM `wp_usermeta` WHERE `meta_key` = 'wp_capabilities'
) 
ORDER BY user_login ASC LIMIT 20 

Please advise.

As soon as I posted, I realized we might need to upgrade – we have v130513, so there is a newer version that hopefully solves this. Stay tuned.

Yup, now it works great – sorry for all that!

Thanks for the update! I’m glad you sorted it out. :)

~ AUTO-GENERATED NOTICE

Action taken: I posted a private contact form and referenced this Topic.

Thanks for sending the Private Contact Form request.

We are aware that there is a bug with the User Search in a certain situation in WordPress Multisite, which appears to be affecting your installation. In the last release of s2Member (130802) we addressed an issue with User Pagination in the WordPress Dashboard, and our test installation didn’t show any problems. Sorry about that.

We will have a new version of s2Member and s2Member Pro released within the next couple days with a fix. In the mean time, there is a patch file here:

http://www.s2member.com/forums/topic/user-search-no-longer-working/#post-55778