WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] User in DB and User in Interface: Number variance (10 posts)

  1. chartinael
    Member
    Posted 3 years ago #

    Hi guys,

    my backend interface shows a number that differs by one from the number of users in database after update von 2.9 to 3.01

    Anybody know why and how to correct?

  2. obscure
    Member
    Posted 3 years ago #

    is the extra user named "root"?

  3. chartinael
    Member
    Posted 3 years ago #

    None visible. Lists one less user than the number states. Users correct, number wrong.

  4. obscure
    Member
    Posted 3 years ago #

    Sorry I think I misunderstood. The dashboard > users shows a list of users and at the top the number of users (All) shows a number that is +1 to the actual number of users in the list - is that the issue?

  5. chartinael
    Member
    Posted 3 years ago #

    Yes, correct. Sorry for not being more precise in my OP.

  6. chartinael
    Member
    Posted 3 years ago #

    Anybody have any thoughts on why causes that?

  7. obscure
    Member
    Posted 3 years ago #

    no sorry. never heard of anyone having this issue.

  8. chartinael
    Member
    Posted 3 years ago #

    ^^me neither. None of my other 3.01 installations have that issue. Beats me.

  9. Mark / t31os
    Moderator
    Posted 3 years ago #

    Might be left over usermeta throwing off the counts..

    If you have access to PhpMyAdmin and know how to use it, run this query on your WordPress database...

    SELECT um.*
    FROM wp_usermeta um LEFT JOIN wp_users u ON um.user_id = u.ID
    WHERE u.ID IS NULL;

    NOTE: If your WP prefix is not wp_ update the appropriate places in the query.

    If you get any results that'll be the source the counts being off (users present in the meta table that don't have a corresponding record in the user table).

  10. chartinael
    Member
    Posted 3 years ago #

    Thank you, that did the job. Had a user with id 0 and also some left meta on user 27 who hasn't existed for ages.

Topic Closed

This topic has been closed to new replies.

About this Topic