New Users who have never logged in are hidden from Users List

  • Resolved 1000camels

    (@1000camels)


    3 years, 7 months ago

    It would appear that new users who have never logged in are hidden from Users List in the backend, including when you search.

    This is the query that I discovered with

    SELECT SQL_CALC_FOUND_ROWS wp_users.ID
    FROM wp_users
    INNER JOIN wp_usermeta
    ON ( wp_users.ID = wp_usermeta.user_id )
    WHERE 1=1
    AND ( wp_usermeta.meta_key = ‘wfls-last-login’ )
    AND (user_email LIKE ‘%[email protected]%’
    OR display_name LIKE ‘%[email protected]%’)
    ORDER BY wp_usermeta.meta_value DESC
    LIMIT 0, 20;`

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @1000camels, thanks for your message.

    Wordfence itself does not have an option to hide users from the WordPress > Users > All Users list. The wfls-last-login column is added by us but should only be used for logging purposes – I expect you’re using this as a reference for whether the users being hidden have logged in anyway – but thought I’d mention that.

    I did a bit of digging for a similar problem though, and it seems this could be a feature of a plugin to manage user roles. Do you use any additional user management plugins where there may be an option to view/hide users based on certain criteria such as ‘inactive’ users? This may also be a feature of some online stores where users can register their own accounts.

    If not, you may be able to see if anybody has experienced hidden inactive users with WordPress in the Fixing WordPress or Everything Else WordPress support forums.

    Thanks,

    Peter.

    This has been an issue for me as well. “All” shows all users, as expected. But when I click to sort on the last login date, it excludes anyone who has never logged in, or whose last login date was older than approximately May 2019.

    It doesn’t seem like it should do that. Those are the users I’m most interested in seeing, so I can decide if they should be deleted. Pruning out inactive users is a useful security measure.

    I have the same issue: when I click to sort on the last login column, it excludes anyone who has never logged in.

    Why is this marked as “Resolved”?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘New Users who have never logged in are hidden from Users List’ is closed to new replies.