Skip to:

Opened 4 years ago

Closed 4 years ago

#8299 closed defect (bug) (fixed)

Incorrect Type check in Groups generates extremely long SQL query

Reported by: comminski's profile comminski Owned by:
Milestone: 6.1.0 Priority: normal
Severity: normal Version: 5.0.0
Component: REST API Keywords: has-patch


If you have a site with a large group of users and you go to A BP Group and select Manage > Members, it triggers a sql query to return the list of members

On line 402 of buddypress/bp-core/classes/class-bp-user-query.php, there is a boolean check false !== $search_terms. For this query, $search_terms is null, not False, so the SQL query generates a AND u.ID IN statement with every user_id in the database.

This is causing an issue on WP Engine where the query can be so long, that it is Killed.

Change History (6)

#1 @r-a-y
4 years ago

  • Keywords reporter-feedback added

Thanks for the report, @comminski.

I can't verify that $search_terms is null; it's always false for me. Are you perhaps running a plugin that adds a search form to a group's "Manage > Members" page?

#2 @imath
4 years ago

@comminski thanks for reporting this issue. Could you also tell us what’s the BP Template pack you activated in Settings / BuddyPress / Options ? We are using the BP REST API in BP Nouveau while we don’t in BP Legacy.

#3 @comminski
4 years ago

Hi, thank you for looking into this, here is more detail on how to reproduce this:

  • I am using the Nouveau template
  • BuddyPress 5.1.2 (upgraded to 6.0.0 and experienced the same issue)
  • WordPress version 5.4.1
  • WordPress Theme: Twenty Nineteen
  • Tested in Chrome 81.0 & Firefox 75.0
  • BuddyPress was the only active plugin on the site

I created a new Private group called Test
I added var_dump($search_terms); die(); to line 400 of buddypress/bp-core/classes/class-bp-user-query.php
I visited the manage-members area at wordpress.lcl/groups/test/admin/manage-members/
I found $search_terms was null, not false

#4 @imath
4 years ago

  • Component changed from Groups to REST API
  • Keywords has-patch added; reporter-feedback removed
  • Milestone changed from Awaiting Review to 6.1.0
  • Version changed from 5.2.0 to 5.0.0

Thanks for these details @comminski. As @r-a-y checked everywhere in BP Core, I believe the issue is located into the BP REST API (which is maintained on GitHub). So far if there are no search terms, NULL is used as the fallback value.

I've created this PR on its GitHub repository to fix this issue asap.

#5 @comminski
4 years ago

Awesome, thanks for the fast response.

#6 @imath
4 years ago

  • Resolution set to fixed
  • Status changed from new to closed

It has been fixed into the BP REST API.

See [12658] for more details about it.

Note: See TracTickets for help on using tickets.