Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I had to switch around my Super Admins. I did it through the MySQL tables directly.

I now have 1 official Super Admin for my network (which is what I want & need) but WordPress shows that I have 2 Super Admins:

All (71) | Super Admins (2)

Where does WP store the SA count or the list of SA's?

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

It's stored in the main site options table, under the "site_admins" key.

Edit: As pointed out in the comments, the "site options" table in multisite is actually named PREFIX_sitemeta, like "wp_sitemeta". It's referred to as a site option internally, like get_site_option('site_admins').

To adjust this without editing the database content directly, you could do this:

$capes = get_site_option('site_admins');
// $capes is an array of the super admin usernames, adjust it as needed
// then save it back like so:
set_site_option('site_admins', $capes);
share|improve this answer
    
I looked @Otto, but I do not have a site_admins key in the options table –  H. Ferrence Feb 6 at 21:25
    
Then you don't have any super-admins. ;) That is the only place the list of super admins is stored. Make sure you're checking the SITE options table, not just the options table for one of the individual blogs. –  Otto Feb 6 at 21:30
    
I have 107 sites in the network. the table naming convention is wp_999_*. The only group of tables with *_users is wp_users and every user in my network is in this table. So I am assuming the the naming convention for my main site is wp_* without any number attached to it. Thanks @Otto. –  H. Ferrence Feb 6 at 21:31
1  
It's not in {$prefix}_options in my test installation; it's in {$prefix}_sitemeta. –  Pat J Feb 6 at 21:31
    
Yes, okay, sitemeta then. In the WordPress code, this is called site_options. Stupid terminology. –  Otto Feb 6 at 21:33
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.