• Resolved tomaszraczek

    (@tomaszraczek)


    Hi,

    When I want to filter approved users returns no result.
    https://prnt.sc/26mvovk
    https://prnt.sc/26mvp1s

    The error log returns the following error:

    WordPress database error Not unique table/alias: 'wp_usermeta' for query SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER 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') WHERE 1=1 AND ( 
      wp_usermeta.meta_key = 'wp_capabilities'
    ) AND ( ( wp_usermeta.meta_key = 'pw_user_status' AND CAST(wp_usermeta.meta_value AS CHAR) = 'approved' ) OR mt1.user_id IS NULL ) ORDER BY user_login ASC LIMIT 0, 20 made by WP_Users_List_Table->prepare_items, WP_User_Query->__construct, WP_User_Query->query

    It doesn’t work for multisite only.

Viewing 8 replies - 1 through 8 (of 8 total)
Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Users filtering not working on multisite’ is closed to new replies.