Support » Networking WordPress » Super admin not showing

  • I’m doing a trial run of multisite on a HostGator account before setting up a new installation for a school. The school site is already using a subdomain, so I want the teachers’ individual sites to be in subdirectories. I didn’t see this option but achieved it in the config by setting subdomain_install to false. This is my second try; the first time I got the Super Admin option, but adding a site created a subdirectory, which surprised me as WordPress has been sitting on the domain for a year or so. So I started over, after deleting the extra tables in phpAdmin so that the installation wasn’t telling me that it was already set up for a network.

    The problem may be in the username. From another topic here, I saw you ask if there were capital letters in the username. Somewhere along the way I changed “admin” to “Heather”, and now there is no “admin”.

    Can I add a super admin directly to the database? Or should I start over yet again?

    The site is at I’m running it in French, but hopefully you can find your way around.

Viewing 15 replies - 1 through 15 (of 47 total)
  • Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Do you have the network enabled or not?

    Logged in as “heather” or “Heather”, the only admin-level user, I do not see the “network” menu item that I saw before (I think that would be the right English term; in French it’s “réseau”) but at the top of the menu, under the dashboard button, I get “My sites” (mes sites), which suggests to me that the network is enabled but I’m not super admin anymore. Perhaps I had too many tabs open and didn’t log out and in with the right sequence, or something like that.

    In phpMyAdmin I see tables for wp_blogs and wp_blog_versions.

    Under wp_user_capabilities, I am a:1:{s:13:”administrator”;b:1;} and wp_user_level 10. If I change (one of) these, will it mess things up? What would I change them to exactly?

    (I suppose I should have done the trial run in English, but I need to learn the French vocabulary so I can teach the teachers to use it!)

    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Ooo je suis une Canadien! 😉

    Usually just logging out shouldn’t remove anything. Hrm.

    Okay, since you;re in the db anyway, look in the wp_sitemeta table. there’s a meta key there called admin_user_id. Is it 1? Does that match the user ID of Heather?

    Vive les canadiennes !

    I don’t see a wp_sitemeta table. In wp_options, admin_email is mine, in wp_users I have ID 1, in wp_usermeta I have user level 10. Those all pertain to the main blog, though, don’t they? Nothing seems to be “meta” to that, except for wp_blogs and wp_blog_versions.

    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Okay, so the tables for the network didn’t get created.

    Did you follow the instructions and go through the menu to set up the network?

    If so, make sure the db user has ALL permissions on the db.

    I think the permissions must be there because it worked the first time, except that subdomains showed up which I didn’t want. Then I tried to erase all my steps, but it looks like I missed something so it didn’t “take”. I think I should start again from scratch. Restore the original config file, drop the extra tables, log out, log in a couple of times, make sure that it knows I really am admin – or need I go back to a fresh install of WordPress? Are there any other places where the network is “registered” (I’m comparing it to a registry entry on a computer)?

    I install 3.01 today, and follow all the steps ( exactly, I can not see the super admin menu too.

    I can see wp_usermeta and the rest network tables.

    I just don’t understand why I can’t see the super admin.



    I just created the network, and my WP installation says that it detects it when I click on the “network” link under tools. Didn’t get any errors, All the plugins got reactivated just fine, I just don’t see the “SuperAdmin” on my menu either. I’m hosting on hostgator too. Anyone know how to fix this?

    When you added the data to your wp-config.php file, you DID put it above the line that tells you to stop editing here, right?

    In my case, yes. Right above it.

    Definitely, yes, in my case too.

    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Everyone having issues with this, please look in your database and see if the extra tables were created.

    can you maybe tell me what tables I should be looking for?

    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress


    Yep, they’re all there.

Viewing 15 replies - 1 through 15 (of 47 total)
  • The topic ‘Super admin not showing’ is closed to new replies.