List of Pending Members Disappeared….AGAIN!

I have the exact same issue since today. All three section now are saying “There are no users with a status of …”.
I’ve been using the plugin since nearly a year without issue, no updates were done recently to the website.
I can find the user that are pending in the user list, but because the filter is also broken it is complicated to find them when you have thousand of users.
Also the website newuserapprove.com that the author tell to use for support is broken. So anyone now if this plugin is still supported? If not i will probably need to find a new one.

I’ve check the error log and here is what i find regarding the plugin.

[Tue May 31 19:28:20.582234 2016] [:error] [pid 17493] [client 90.63.190.209:14305] WordPress database error Not unique table/alias: ‘wp_usermeta’ for query SELECT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( \n ( \n ( \n ( wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’ )\n ) \n AND \n ( \n mt1.meta_key = ‘wp_4_capabilities’\n )\n )\n) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC /* From [www.calissonincwholesale.com/wp-admin/users.php?s&pw-status-query-submit=Filter&new_user_approve_filter=pending&paged=1] in [/nas/content/live/calisson/wp-content/plugins/new-user-approve/new-user-approve.php:309] */ made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, pw_new_user_approve_user_list->pending_users_bubble, pw_new_user_approve->get_user_statuses, pw_new_user_approve->_get_user_statuses, WP_User_Query->__construct, WP_User_Query->query

[Tue May 31 19:28:20.583595 2016] [:error] [pid 17493] [client 90.63.190.209:14305] WordPress database error Not unique table/alias: ‘wp_usermeta’ for query SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) LEFT JOIN wp_usermeta AS mt1 ON (wp_users.ID = mt1.user_id AND mt1.meta_key = ‘pw_user_status’ ) LEFT JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( \n ( \n ( \n ( wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘approved’ ) \n OR \n mt1.user_id IS NULL\n ) \n AND \n ( \n mt2.meta_key = ‘wp_4_capabilities’\n )\n )\n) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC /* From [www.calissonincwholesale.com/wp-admin/users.php?s&pw-status-query-submit=Filter&new_user_approve_filter=pending&paged=1] in [/nas/content/live/calisson/wp-content/plugins/new-user-approve/new-user-approve.php:313] */ made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, pw_new_user_approve_user_list->pending_users_bubble, pw_new_user_approve->get_user_statuses, pw_new_user_approve->_get_user_statuses, WP_User_Query->__construct, WP_User_Query->query

[Tue May 31 19:28:20.584737 2016] [:error] [pid 17493] [client 90.63.190.209:14305] WordPress database error Not unique table/alias: ‘wp_usermeta’ for query SELECT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND ( \n ( \n ( \n ( wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘denied’ )\n ) \n AND \n ( \n mt1.meta_key = ‘wp_4_capabilities’\n )\n )\n) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC /* From [www.calissonincwholesale.com/wp-admin/users.php?s&pw-status-query-submit=Filter&new_user_approve_filter=pending&paged=1] in [/nas/content/live/calisson/wp-content/plugins/new-user-approve/new-user-approve.php:309] */ made by require_once(‘wp-admin/admin.php’), require(‘wp-admin/menu.php’), require_once(‘wp-admin/includes/menu.php’), do_action(‘admin_menu’), call_user_func_array, pw_new_user_approve_user_list->pending_users_bubble, pw_new_user_approve->get_user_statuses, pw_new_user_approve->_get_user_statuses, WP_User_Query->__construct, WP_User_Query->query

Mystery solved on my end. Um, er, we discovered that one of the members w/ admin access (the pres of our association) was logging on and approving people w/o our knowledge(even though they hadn’t paid their dues). Doh!

Original topic resolved.