[buddypress-trac] [BuddyPress Trac] #9291: Activating users via admin interface fails

[buddypress-trac]

#9291: Activating users via admin interface fails
--------------------------+-----------------------------
 Reporter:  scuttleclun   |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Core          |    Version:
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 When I try and activate a new user via the admin panel, the user seems to
 get removed from the system completely. The user had registered but not
 confirmed their email.
 In my web server log I see the following error, related to BuddyPress:

 WordPress database error You have an error in your SQL syntax; check the
 manual that corresponds to your MariaDB server version for the right
 syntax to use near 'WHERE activation_key =
 '5ZHLFZO8ppUGGi6W3CkvBBTtre8979R1'' at line 1 for query SELECT DISTINCT
 signup_id wp_signups WHERE activation_key =
 '5ZHLFZO8ppUGGi6W3CkvBBTtre8979R1'   made by require_once('wp-
 admin/admin.php'), do_action('load-users_page_bp-signups'),
 WP_Hook->do_action, WP_Hook->apply_filters,
 BP_Members_Admin->signups_admin_load, BP_Signup::activate,
 bp_core_activate_signup, BP_Signup::get, referer:
 https://ssrsdev.esdm.co.uk/wp-admin/users.php?page=bp-
 signups&signup_id=99&action=activate

 Wordpress version: 6.7.2
 BuddyPress Version: 14.3.4

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/9291>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac