Posted 1 year ago #
I have more admins on one of my blogs than I should and some are hidden. I asked for help in seeing records for those admins a couple of months ago. No one has responded.
Can anyone help me please? Here's the original post:
http://wordpress.org/support/topic/admin-count-shows-more-than-are-listed
Thanks
Vic
I wonder if the count is coming from the usermeta table where the capabilities entry is for 'administrator'.
Try this query in phpMyAdmin to see how many entries are in the usermeta table as administrator:
SELECT m.*
FROM wp_usermeta m
WHERE m.meta_key = 'wp_capabilities'
AND m.meta_value like '%administrator%'
Posted 1 year ago #
@vtxyzzy Thanks - the SQL query threw up 10 records, and gave the user ids. Only one of those user ids appear in wp_users - my own admin record. This seems to give a complete explanation of what I see in the Users list in the WP control panel.
I made a backup of the entire site, deleted records in wp_usermeta for those users, excluding my own, and the Users list now looks normal.
One thing I don't understand is that I re-ran the query expecting to see just my record, and it showed 0 records.
So I browsed the table and my record is still there, still as administrator - it is still present in wp_users and shows in the WP control panel, so it seems OK.
@esmi Thanks. I'll look through those links. As I had done a full restore from backup, updated the version and then hardened with a variety of plugins, I thought the installation had to be clean. Obviously not!
Vic
If that solved your problem, please use the dropdown at top right to mark this topic 'Resolved' so someone researching a similar problem can see that there is a solution.
Posted 1 year ago #
Ah, thank you.
Vic
This topic has been closed to new replies.
