Users filtering not working on multisite
-
Hi,
When I want to filter approved users returns no result.
https://prnt.sc/26mvovk
https://prnt.sc/26mvp1sThe 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.