Support » Plugin: New User Approve » Not unique table/alias…

  • Following is written to log when viewing the custom menu page. Hotfix possible?

    Admin > Users > Approve New Users

    [13-Oct-2016 20:31:26 UTC] 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 wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND (
    ( wp_usermeta.meta_key = ‘pw_user_status’ AND wp_usermeta.meta_value = ‘pending’ )
    ) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC 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
    [13-Oct-2016 20:31:26 UTC] 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’ ) INNER JOIN wp_usermeta wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND (
    ( wp_usermeta.meta_key = ‘pw_user_status’ AND wp_usermeta.meta_value = ‘approved’ )
    OR
    mt1.user_id IS NULL
    ) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC 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
    [13-Oct-2016 20:31:26 UTC] 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 wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) WHERE 1=1 AND (
    ( wp_usermeta.meta_key = ‘pw_user_status’ AND wp_usermeta.meta_value = ‘denied’ )
    ) AND ( (wp_usermeta.meta_key = ‘pw_user_status’ AND CAST(wp_usermeta.meta_value AS CHAR) = ‘pending’) ) ORDER BY user_login ASC 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

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Not unique table/alias…’ is closed to new replies.