home_url() trouble: Home page displays "Index of /wp/" also rewriting urls

OK, I think I get that part. So I uploaded everything and removed my redirects.
Regarding changes to the database: This is strictly a “pages” website – no comments, posts, trackbacks or anything.
So I’m not changing anything in the database under wp_posts or wp_x_posts
I found wp_blogs with 3 ids, and tried to change the domain and path for each. I also changed the wp_options siteurl to the appropriate value …
now all three sites have error establishing a database connection. so at least I got them to change, although I have no idea how to change the db connections. I’m still playing with it but totally unsure. Is there a step-by-step for changing values/tables/etc. in the database? I’m sorry to be so {seemingly incompetent} in the db arena – argh!

Thank you so much for all of your help, Patrick.

I didn’t figure out how to move the install and get the sites to display (no db connection for any of them).

For now I reverted back to the convoluted URLs of all 3 sites, because at least the sites display and won’t be down in the morning.

I may attempt again tomorrow but I’m really nervous about it. I suppose I could install single versions of WP in each top-level domain folder, so the urls would not have to go to Timbuktu and back. Do you think that would work and be simpler for someone not well-versed in databases?

Thank you again, so much, for all of your help!!
I hope you have a wonderful new year!

(no db connection for any of them).

That means the database user or password in wp-config.php weren’t correct or the database is not on the server.

I suppose I could install single versions of WP in each top-level domain folder, so the urls would not have to go to Timbuktu and back.

You could do that but since you have an existing install I think it’s easier to just move that rather than splitting it up into X parts.

I would like to upload my backup WP to the new location, using a NEW database, so I don’t mess up the current multisite installation. Is it possible to copy the install to a new database, and if so, is there a tutorial or step-by-step that details which files to modify? Since I already tried and got lost in the db files I’m a little hesitant to risk messing it up again.

[Should start a new thread for this – I don’t want to keep asking for help if you think it’s a separate issue. thanks!]

I would like to upload my backup WP to the new location, using a NEW database, so I don’t mess up the current multisite installation.

Sure, you can replicate the database. Go into phpMyAdmin and export the existing multisite database. Then go to cPanel and create a new database. Then go back to phpMyAdmin and import the exported file.

It’s kind of a lousy situation since you’re dealing with live sites ??

Great, thanks! I successfully replicated the database and imported it into my new db. I also successfully have interconnect/it search/replace script ready to go … except I’m unsure exactly what to replace.
I THINK I am replacing the domain.com urls with paths from /public_html/ and point to the new WP files at the root directory.

Given the desired end result of replacing:
https://djxstation.com/wp/autodjpac/ –>> autodjpac.com/
https://djxstation.com/wp/ –>> djxstation.com/ (orig. WP multisite primary)
https://djxstation.com/wp/partisound/ –>> partisound.com/ = ROOT/primary domain for hosting account = should become multisite primary somehow (do I change it to –>> /public_html/ ???

Be sure to change the web document root for “domain.com” to /public_html/.

I’m ready, just want to do it correctly! Thank you so much ??

So just making sure here — all you’re doing right now is, for example, changing https://djxstation.com/wp/autodjpac/ to https://djxstation.com/autodjpac/. The domain mapping plugin will take care of the rest after this part is finished.

For the part you’re doing right now, moving from djxstation.com/wp/sitename to djxstation.com/sitename it doesn’t matter what the document root is for the add-on domains, they’re not being used. But yes, once you’re ready to map the add-on domains they must all be pointed to /public_html.

So just making sure here — all you’re doing right now is, for example, changing https://djxstation.com/wp/autodjpac/ to https://djxstation.com/autodjpac/.

Actually it is https://djxstation.com/wp/autodjpac/ to https://partisound.com/autodjpac/, because djxstation is not main domain, partisound is. But I’m trying to use the interconnect/it tool, which I believe makes changes in the new database. I’m not sure if those urls are even included in the database files, or if I change them with the interconnect/it tool. I am trying to make the necessary changes to the database tables first. Then I was going to go to the domain mapping plugin.

The only thing I know to change in the database is the connection in either .htaccess or wp-config.php file to use the new db / user / password. As for the tables … even using the tutorial I’m not sure which to change. ??

OK, yes that tool will make the changes for you. Do a dry run first to make sure the changes actually makes sense and then proceed.

So these are the search and replaces to run…I think that’s all you need.

(1) search & replace “djxstation.com” to “partisound.com”
(2) search & replace “/wp/sitename/” to “/sitename/”
(3) Go to wp_blogs table and change the path from “/wp/” to “/” for Site ID 1.
(4) Edit wp-config.php

define('DOMAIN_CURRENT_SITE', 'partisound.com');
define('PATH_CURRENT_SITE', '/');

I think that covers all the changes but I could be forgetting something…

Wow, this is great, I never knew a “dry run” could point out so many things to think about! For instance, the order in which I search/replace these things matters a LOT.
If I do this one first:

(1) search & replace “djxstation.com” to “partisound.com”

then there will be no more djxstation.com to change – and that site (djxstation.com), which was site ID 1, will be pretty much gone, I think.

here’s what I’ve tried … modified… to address that.
{0} search & replace “djxstation.com/wp/partisound/” to “partisound.com/” **NEED TRAILING SLASH**

{2} search & replace “/wp/sitename/” to “/sitename/”
“/wp/autodjpac/” to “/autodjpac/”
“/wp/partisound/” to “/partisound/” **NOT NECESSARY** taken care of in {0} NONE SHOULD EXIST
{2.1} “djxstation.com/wp/” to “partisound.com/djxstation.com/” **NOT SURE ABOUT ‘.com’ ? djxstation files should be the only ones left in /wp/ directory, so should I switch them to “partisound.com/djxstation/” ? I don’t want to confuse subfolders with site ID here …
**Trying to keep djxstation from disappearing when I run {1} djxstation.com/ to partisound.com/**

{1} search & replace “djxstation.com/” to “partisound.com/” **I SHOULD DO THIS NEARER THE END**

Hi Patrick,
I made the search/replaces that you outlined using Interconnect/it. Please ignore my previous post above (6 days ago) …that was me overthinking everything, I think! I decided to go with your outline and keep it straight.
Then I edited the wp-config.php as you said:

So these are the search and replaces to run…I think that’s all you need.

(1) search & replace “djxstation.com” to “partisound.com”
(2) search & replace “/wp/sitename/” to “/sitename/”
(3) Go to wp_blogs table and change the path from “/wp/” to “/” for Site ID 1.
(4) Edit wp-config.php
define(‘DOMAIN_CURRENT_SITE’, ‘partisound.com’);
define(‘PATH_CURRENT_SITE’, ‘/’);

Then I installed the wordpress-mu-domain-mapping.0.5.4.3 and started to follow those instructions. I “Network Activated” the plugin, and then when I got to step 4, I tried to get in to my WP network the usual way, I got this error:

The domain mapping plugin only works if the site is installed in /. This is a limitation of how virtual servers work and is very difficult to work around.

BUT … Then I realized I was trying to get to the network admin of my current / live WP database/installation. This is the URL of the page with the error:
https://djxstation.com/wp/partisound/wp-admin/post.php?post=33&action=edit
So at present I am unable to edit my original 3 sites on the
WP multisite install, but the sites are still working.

When I try to go directly to the primary domain/root site to login to WP, I get this error:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

I was worried that I missed something in the search/replace, but I’m pretty sure I uploaded the MU domain mapper plugin to the root and not to my /wp/ install area.

Do you know what I might have done wrong? It seems I’ve messed up the old/stable/currently live install as well as not being able to work on the new one.

Thank you, and please, and I really thought I was there!

Do you have Multisite installed in the root of the primary network domain? Right now it looks like it’s in /wp/.

I have it in the primary domain root. Something keeps redirecting it into /wp/ and also connecting the MU Domain Mapper with the old WP installation, which is at /public_html/djxstation.com/wp/

Also, in Dreamweaver my FTP connection to the primary root where I installed the *new* multisite WP is messed up. I didn’t change anything in the server definitions, but after installing the domain mapper I can’t connect. Is that related to changes I made?

to clarify this:

The domain mapping plugin only works if the site is installed in /. This is a limitation of how virtual servers work and is very difficult to work around.

BUT … Then I realized I was trying to get to the network admin of my current / live WP database/installation. This is the URL of the page with the error:
https://djxstation.com/wp/partisound/wp-admin/post.php?post=33&action=edit
So at present I am unable to edit my original 3 sites on the
WP multisite install, but the sites are still working.

This is the original install that’s 3 directories down, not the one I copied and put up at the root.