WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Just installed Multisite but no SuperAdmin (32 posts)

  1. AlbinoMonkey
    Member
    Posted 2 years ago #

    I have just installed multisite onto http://jobs4thais.com and everything went smoothly but nothing has shown up in the dashboard, there is no super admin panel or anything and nothing to select sites or add new sites. Does anyone have any ideas?

    Any help is much appreciated.

  2. It could be you're just missing it:

    http://codex.wordpress.org/Create_A_Network#Network_Admin_Link_Location

    Or an easy way to check if you've installed it correctly is to visit your network dashboard URL.

    http://your-wordpress-URL-here/wp-admin/network/

    You'll either get the network admin panel or a message explaining why you didn't.

  3. AlbinoMonkey
    Member
    Posted 2 years ago #

    It says:

    You do not have sufficient permissions to access this page.

    Do you have any idea what this means?

    Thanks in advance.

  4. Most likely it means you didn't install multisite correctly. ;)

    Looking at that site, there is no existing content right? If so then you can skip the part where I say "Make sure you back up your files and database first."

    If you are not starting from scratch and have content to lose, do make those backups.

    How far did you get in the installation steps? Does your wp-config.php file contain this line?

    define('WP_ALLOW_MULTISITE', true);

    That line has to be above where it says /* That's all, stop editing! Happy blogging. */

    Once that's done the rest of the configuration should be possible.

  5. AlbinoMonkey
    Member
    Posted 2 years ago #

    I have content but it is backed up.

    I have added that line but it was below the line of text, but it let me carry on with the installation?

  6. AlbinoMonkey
    Member
    Posted 2 years ago #

    I have changed the line of code to be above that one but still cannot see anything.

    Also when i go to Network Setup it says - Warning: An existing WordPress network was detected.

  7. That's probably a good sign but I'm almost out of ideas.

    On my Crash Test installation, when I visit

    http://your-wordpress-url-here/wp-admin/network/setup.php

    I get "The original configuration steps are shown here for reference." and it shows me what I had to change to make it work.

    Try visiting that URL on your installation and confirm that the changes it says are actually made to your file system (for blogs.dir) and your .htaccess and wp-config.php files.

    If you get into trouble and aren't sure where or what you did, then restore both the files and database backups from just before you attempted this.

    That will put you back at the beginning and let you try again new.

  8. AlbinoMonkey
    Member
    Posted 2 years ago #

    It just says the same thing

    You do not have sufficient permissions to access this page.

    It says on the netowrk.php page 'To create a new network, you will need to empty or remove the network database tables.'

    Where would I need to got to remove these table?

  9. Now we're getting into the deep end of the pool and definitely should consider swimming safety.

    If you are familiar with phpMyAdmin or mysql command line, then dropping the new tables is not a big deal.

    But walking someone through that is really risky and it's easy to make a mistake that breaks things.

    Make sure you have good database backups as well as file backups.

    http://codex.wordpress.org/WordPress_Backups
    http://codex.wordpress.org/Backing_Up_Your_Database
    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

    Seriously, make sure you can restore your database backup as well as your files.

    If you feel confident then you can drop the tables that use your table_prefix and _1_. So if you are using the default prefix it would be tables that has names like so

    wp_1_
    wp_2_
    .
    .
    wp_#_

    If the error message is correct then dropping those may solve the problem.

    If the Really Bad Thing™ happens then restore your backup and start from the beginning.

  10. AlbinoMonkey
    Member
    Posted 2 years ago #

    OK, I used BackupBuddy to save everything so should be fine.

    Do I just go into phpMyAdmin and remove the files named above?

  11. OK, I used BackupBuddy to save everything so should be fine.

    Not to be overly direct but please make sure you can restore your backup even if you don't have access to BackupBuddy.

    Proceed at your own risk! You could lose everything on your WordPress installation if you make a mistake!

    There, that's out of the way. :)

    That said, go into phpMyAdmin and locate the tables (they're not files) like I described. Select those _1_ tables and use the option to drop them.

    I don't use phpMyAdmin (I'm more of a CLI person myself) so I can't provide you specifics on how to do that. Read up on phpMyAdmin and give it a go if you feel comfortable with it.

    And once again, if the Really Bad Thing™ happens then restore your backup and start from the beginning.

  12. AlbinoMonkey
    Member
    Posted 2 years ago #

    I've had a look through and can't see any tables that have the same names as _1_.

    I'm at a loss sorry!

  13. Well, then the only advice I have is

    - Take a break. Working on something that's not making sense to you can drive you nuts.

    - Read up on how to restore your database/file backup.

    http://codex.wordpress.org/WordPress_Backups
    http://codex.wordpress.org/Backing_Up_Your_Database
    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

    I think you made a misstep early on in the instructions and now your WordPress installation is in a confused state regarding the multisite network.

    There is probably a simple way to resolve it but as you are discovering, multisite is a little more complicated than regular WordPress. By "easy way" I really mean "easy if you know how to do it..."

    If you can put it all back the way it was prior to attempting this then you can redo it correctly the second time around.

  14. The wp_1_ thing is a misleading 'error' that doesn't actually mean what you think it does.

    What;s your blog prefix?

  15. AlbinoMonkey
    Member
    Posted 2 years ago #

    Sorry I don't know where to find the prefix?

  16. Look in your wp-config.php file for the line that says

    $table_prefix  = 'wp_';   // Only numbers, letters, and underscores please!

    The default value for $table_prefix is 'wp_' but it could be changed in your installation.

  17. AlbinoMonkey
    Member
    Posted 2 years ago #

    Hi This is what it says:

    $table_prefix = 'wp_';

  18. Darn. I was hoping it was a known issue with not having a table prefix.

    Also when i go to Network Setup it says - Warning: An existing WordPress network was detected.

    That implies that your server HAS the stuff on it.

    In your database, do you have a wp_blog and wp_sites tables?

  19. AlbinoMonkey
    Member
    Posted 2 years ago #

    I have wp_blogs and wp_site

  20. Idea #1: Don't bump. We're volunteers, we have lives and jobs. If you can't be patient, you should hire someone.

    The problem is you actually have Multisite installed on the DB, but not the front end. So you have two options

    1) Uninstall and start over -- Drop these global tables in the database:
    wp_blogs
    wp_blog_versions
    wp_registration_log
    wp_signups
    wp_site
    wp_sitemeta

    2) Restore the wp-config.php file from before you removed the Multisite stuff.

  21. AlbinoMonkey
    Member
    Posted 2 years ago #

    OK thanks, I haven't bumped and really appreciate all your help!

    If I restore the wp-config.php file will that let me start over or not?

  22. Your post was a bump. I deleted it. Don't try and convince a moderator we didn't see a bump ;) We know. Here's what you said:

    Anybody have any ideas?

    If you restore the wp-config to when you have WP Multisite up, it will skip over the 'You have an existing network' issue.

  23. AlbinoMonkey
    Member
    Posted 2 years ago #

    Ok sorry about that.

    So when you say it will skip over the issue can I start over again from there?

  24. It's not a 'start over', it's a 'get back to having Multisite up'

    Start OVER is delete it all and start over.

    A half start over would be delete the tables I indicated.

    Like I said, two OPTIONS. It's either 1 OR 2.

  25. AlbinoMonkey
    Member
    Posted 2 years ago #

    Sorry I don't follow.

    I have never had Multisite up so am a bit confused. After I set it up I never had the options for 'Sites' or the 'Super admin'.

    Sorry if I am being retarded here but I am slightly confused!

  26. Yes, you did. It just didn't work.

    I have just installed multisite onto http://jobs4thais.com and everything went smoothly but nothing has shown up in the dashboard, there is no super admin panel or anything and nothing to select sites or add new sites. Does anyone have any ideas?

    See? You said yourself you set up Multisite, but it didn't work. That actually set up the database.

    Go look at your database.

    Do you, or do you not, have the tables I mentioned?

  27. AlbinoMonkey
    Member
    Posted 2 years ago #

    Hi,

    I have dropped the tables that you mentioned. What do i do next?

    Thanks very much for all your help it's much appreciated!

  28. If you dropped those tables, then restore your wp-config.php file from just before you attempted this 2 days ago.

    Then try again from the beginning.

    http://codex.wordpress.org/Create_A_Network#Step_1:_Prepare_Your_WordPress

  29. AlbinoMonkey
    Member
    Posted 2 years ago #

    OK thanks I'll try that now!

  30. AlbinoMonkey
    Member
    Posted 2 years ago #

    Thanks got it working

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.