GSATech

It isn’t too hard. Do you have access to the wordpress database as you will need to make changes there.

Here are the options in the database to change

wp_options: options named “siteurl” and “home”
wp_site
wp_sitemeta: the option named “siteurl”
wp_blogs: any entries in the “domains” column that have the old domain name
wp_#_options: Each sub-site will have sets of tables that correspond to the blog_id in the wp_blogs table. You need to go to the wp_#_options table, where # corresponds to the blog_id, and update the “siteurl” and “home” settings in that table.

Hi Mike

I am on a Windows server so I don’t have a htaccess file. I do have a web.config file.

<?xml version=”1.0″ encoding=”UTF-8″?>
<configuration>
<system.webServer>
<rewrite>
<rules>
<rule name=”WordPress Rule 1″ stopProcessing=”true”>
<match url=”^index\.php$” ignoreCase=”false” />
<action type=”None” />
</rule>
<rule name=”WordPress Rule 2″ stopProcessing=”true”>
<match url=”^([_0-9a-zA-Z-]+/)?wp-admin$” ignoreCase=”false” />
<action type=”Redirect” url=”{R:1}wp-admin/” redirectType=”Permanent” />
</rule>
<rule name=”WordPress Rule 3″ stopProcessing=”true”>
<match url=”^” ignoreCase=”false” />
<conditions logicalGrouping=”MatchAny”>
<add input=”{REQUEST_FILENAME}” matchType=”IsFile” ignoreCase=”false” />
<add input=”{REQUEST_FILENAME}” matchType=”IsDirectory” ignoreCase=”false” />
</conditions>
<action type=”None” />
</rule>
<rule name=”WordPress Rule 4″ stopProcessing=”true”>
<match url=”^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*)” ignoreCase=”false” />
<action type=”Rewrite” url=”{R:2}” />
</rule>
<rule name=”WordPress Rule 5″ stopProcessing=”true”>
<match url=”^([_0-9a-zA-Z-]+/)?([_0-9a-zA-Z-]+/)?(.*\.php)$” ignoreCase=”false” />
<action type=”Rewrite” url=”{R:1}” />
</rule>
<rule name=”WordPress Rule 6″ stopProcessing=”true”>
<match url=”.” ignoreCase=”false” />
<action type=”Rewrite” url=”index.php” />
</rule>
</rules>
</rewrite>
</system.webServer>
</configuration>

My subdirectories have now disappeared and I get a 500 error message.

I am not sure what has gone wrong.

Thanks Will.

Yes, I have followed those steps. It was working this morning and then it stopped working. The only thing I have done today is delete some plug-ins.

I’m not sure if it is to do with Rule 5 in the web.config file.

<rule name=”WordPress Rule 5″ stopProcessing=”true”>
<match url=”^([_0-9a-zA-Z-]+/)?([_0-9a-zA-Z-]+/)?(.*\.php)$” ignoreCase=”false” />
<action type=”Rewrite” url=”{R:1}” />
</rule>

This was working fine, until I changed the domain of the server last week. It was still loading subdirectory sites fine until it just seemed to stop.

Try changing

<rule name="WordPress Rule 4" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*)" ignoreCase="false" />
                    <action type="Rewrite" url="E:/Inetpub/WWWRoot/wordpress/{R:1}" />
                </rule>
                <rule name="WordPress Rule 5" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?([_0-9a-zA-Z-]+/)?(.*\.php)$" ignoreCase="false" />
                    <action type="Rewrite" url="E:/Inetpub/WWWRoot/wordpress/{R:2}" />
                </rule></em>

to

<em>                <rule name="WordPress Rule 4" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*)" ignoreCase="false" />
                    <action type="Rewrite" url="E:/Inetpub/WWWRoot/wordpress/{R:2}" />
                </rule>
                <rule name="WordPress Rule 5" stopProcessing="true">
                    <match url="^([_0-9a-zA-Z-]+/)?([_0-9a-zA-Z-]+/)?(.*\.php)$" ignoreCase="false" />
                    <action type="Rewrite" url="E:/Inetpub/WWWRoot/wordpress/{R:1}" />
                </rule>

Brilliant!

I managed to get it working by finding an older version of phpmyadmin.

Thanks for your help.

Now got that that problem of not being able to get to /wp-admin/ on subdirectories. I’ve fixed this before but I can’t remember how.

Thanks for your help Mike.

Thanks for the swift response Mike. I’ve had a look at this and I am not sure how to make the changes as you have suggested.

I installed wordpress using IIS on my windows server. I’m not sure how to access the database.

Sorry for this, I’m not 100% sure what I am doing as this is the first time I have done anything like this. Using a windows server has added some extra complications.

I’ve tried installing phpmyadmin on the server, but it came across errors and said I needed to update MySQL to 5.5 instead of 5.1. I’ve got stuck here.