Delete users from the total

  • Hi,

    I currently have 8 vendors, 3 customers, 0 subscribers 1 administrator accounts and one says none but my totals at the top of the table show

    All (159) | Administrator (1) | Subscriber (71) | Customer (73) | Vendor (14)

    So it appears that the others that have been deleted have not been deleted from these totals. I haven’t looked at this before but what can I do about it. I’d like to be able to see without having to count each total.

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    I had a similar situation with a disagreement between the count and what I saw under “All Users”. It turned out that (1) this was a site that had once been hacked and (2) there were records in the wp_usermeta table without corresponding records in wp_users.

    If you’re fluent-ish with databases, check the wp_usermeta table for pointers to records that do not exist in wp_users.

    Thread Starter tlsh39

    (@tlsh39)

    Hi,

    Thanks I’m looking at the wp_usermeta table but I’m not sure what else I should be looking for?

    I have Full texts umeta_id user_id Descending 1 meta_key meta_value.

    There are over 3000 rows in the table, they all have a value in the user_id column but the user id may have been deleted and therefore doesn’t exist in the wp_users table. Although the user id goes up to 294 of which I don’t think there has ever been that many users created.

    Not sure what to do now.
    Also, when you say it was a site that had once been hacked, is this something i need to be concerned about i.e. that it has been hacked rather than could it be hacked?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Delete users from the total’ is closed to new replies.