Members directory 0

Good morning,

I have found an issue with Paid Memberships Pro – BuddyPress addon where the members directory shows no members and a members count of 0.

I have tested this on multiple environments (client sites and local) with KLEO, SweetDate, Seeko, BuddyApp, Twenty Nineteen, Twenty Seventeen, Twenty Sixteen and Twenty Fifteen the issue is present always.

Error message from debug.log

[19-May-2019 09:43:15 UTC] 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 ') AND status = 'active'' at line 1 for query SELECT DISTINCT user_id FROM wp_pmpro_memberships_users WHERE membership_id IN () AND status = 'active' made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, pmpro_bp_directory_init, pmpro_bp_get_members_in_directory

All the best,

Kieran