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

1 Answer 1

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
    
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
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

Your Answer

 
discard

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