Can’t see all users in admin “Users”

  • Resolved claraelise

    (@claraelise)


    2 years, 6 months ago

    Hi!

    We are using this plugin and it works great!
    We noticed today an error on server:
    Not unique table/alias: 'wp_usermeta' for query \n\t\t\t\tSELECT DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID\n\t\t\t\tFROM 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 = 'wpuf_user_status')\n\t\t\t\tWHERE 1=1 AND ( \n wp_usermeta.meta_key = 'wfls-last-login'\n) AND ( ( wp_usermeta.meta_key = 'wpuf_user_status' AND CAST(wp_usermeta.meta_value AS CHAR) = 'approved' ) OR mt1.user_id IS NULL )\n\t\t\t\tORDER BY wp_usermeta.meta_value DESC\n\t\t\t\tLIMIT 0, 20\n\t\t\t made by WP_Users_List_Table->prepare_items, WP_User_Query->__construct, WP_User_Query->query

    And we can’t see all the users in the dashboard menu at “users”.

    Any help appreciated

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Saiful Islam

    (@saifislam01)

    Hi @claraelise,

    Please run the updater of the WP User Frontend plugin and make sure you’re using PHP version 8.0 and the latest version of the plugin.

    Please check & let me know.

    Regards!

    Plugin Support Saiful Islam

    (@saifislam01)

    Hi @claraelise,

    Due to the inactivity of this topic, I am going to mark this topic as resolved. If you have any queries in the future, you can create another thread or contact through the website.

    Regards!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can’t see all users in admin “Users”’ is closed to new replies.