Title: SQL syntax error – possibly directory.php wpdb code?
Last modified: February 6, 2019

---

# SQL syntax error – possibly directory.php wpdb code?

 *  Resolved [midway-wp](https://wordpress.org/support/users/midway-wp/)
 * (@midway-wp)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/sql-syntax-error-possibly-directory-php-wpdb-code/)
 * Immediately upon activation of this plug-in I get this error:
 * WordPress database error You have an error in your SQL syntax; check the manual
   that corresponds to your MySQL 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
 * Here is the code that I found in includes/directory.php
 * `$sql = "SELECT DISTINCT user_id FROM $wpdb->pmpro_memberships_users WHERE membership_id
   IN (" . implode(",", array_map("intval", $include_levels)) . ") AND status = '
   active'";`
 * Any help how to fix this would be greatly appreciated. I have looked everywhere
   trying to remedy this, but to no avail.
 * Thank you.

Viewing 1 replies (of 1 total)

 *  Thread Starter [midway-wp](https://wordpress.org/support/users/midway-wp/)
 * (@midway-wp)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/sql-syntax-error-possibly-directory-php-wpdb-code/#post-11180377)
 * It appears that this was a result of an update issue for some of my other out-
   dated plugins and seems to be working now.

Viewing 1 replies (of 1 total)

The topic ‘SQL syntax error – possibly directory.php wpdb code?’ is closed to new
replies.

 * ![](https://s.w.org/plugins/geopattern-icon/pmpro-buddypress_e7937d.svg)
 * [BuddyPress & BuddyBoss Private Community with PMPro - Restrict Profiles, Groups, Messaging, Forum Discussions](https://wordpress.org/plugins/pmpro-buddypress/)
 * [Support Threads](https://wordpress.org/support/plugin/pmpro-buddypress/)
 * [Active Topics](https://wordpress.org/support/plugin/pmpro-buddypress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pmpro-buddypress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pmpro-buddypress/reviews/)

## Tags

 * [SQL syntax error](https://wordpress.org/support/topic-tag/sql-syntax-error/)

 * 1 reply
 * 1 participant
 * Last reply from: [midway-wp](https://wordpress.org/support/users/midway-wp/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/sql-syntax-error-possibly-directory-php-wpdb-code/#post-11180377)
 * Status: resolved