WordPress.org

1. brundlefly
   Member
   Posted 1 year ago #

   I've been developing a site network in a directory on my local server, and recently tried to upload it to the root of a staging server. I've triple-checked my database credentials and I'm pretty sure I've updated all the URLs in the database, but when I try to view the stage I get "Error establishing database connection". When I go to wp-admin, I get:

   Error establishing database connection

   If your site does not display, please contact the owner of this network. If you are the owner of this network please check that MySQL is running properly and all tables are error free.

   Could not find site my-stage.com. Searched for table wp_blogs in database my_database. Is that right?

   I've successfully uploaded another multisite install to a directory on a server run by the same host, so I think the stumbling block is moving it to root.

   Googling leads me to the following link: http://wordpress.kdari.net/2010/11/moving-wordpress-multisite-to-root.html That precisely describes my issue, but doesn't actually spell out the fix! I've left a comment, but it's under moderation.

   Any thoughts? Help would be appreciated.

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 1 year ago #

   Why the hell he hid it...

   Anyway. Go into your DB and run a search for the foldername. You'll find more than ONE place where you need to change/remove it.

3. brundlefly
   Member
   Posted 1 year ago #

   Bingo! This fixed it. Thanks for the help!

4. bkparikh
   Member
   Posted 1 year ago #

   @brundlefly, I'm having the exact same problem and came across that exact post you mentioned earlier. How did you go about searching every field in the DB?

5. Andrea_r
   team pirate
   Posted 1 year ago #

   How did you go about searching every field in the DB?

   use something like phpmyadmin and the "search" tab it has.

6. brundlefly
   Member
   Posted 1 year ago #

   I actually did a find & replace in the .sql file.

7. Matthew Gedeon
   Member
   Posted 1 year ago #

   As to why the article on kdari.net didn't have the solution, just the problem, the article was supposed to be a placeholder until we had time to write out the solution since we found the answer late at night when our brains were fried. By the time anyone commented on it we had forgotten the solution. The article is now up to date. We're sorry about the incomplete information.

Topic Closed

This topic has been closed to new replies.