• I’am trying to convert a fresh install of wp 3.6 into multisite following this tutorial this tutorial.

    After installing and editing wp-config.php and web.config, when I try to access login page I get this message : One or more database tables are unavailable. The database may need to be repaired.

    So I try to repair and I get this :

    wp_2_posts: Table 'gpatpajbm2f.wp_2_posts' doesn't exist
    wp_2_comments: Table 'gpatpajbm2f.wp_2_comments' doesn't exist
    wp_2_links: Table 'gpatpajbm2f.wp_2_links' doesn't exist
    wp_2_options: Table 'gpatpajbm2f.wp_2_options' doesn't exist
    wp_2_postmeta: Table 'gpatpajbm2f.wp_2_postmeta' doesn't exist
    wp_2_terms: Table 'gpatpajbm2f.wp_2_terms' doesn't exist
    wp_2_term_taxonomy: Table 'gpatpajbm2f.wp_2_term_taxonomy' doesn't exist
    wp_2_term_relationships: Table 'gpatpajbm2f.wp_2_term_relationships' doesn't exist
    wp_2_commentmeta: Table 'gpatpajbm2f.wp_2_commentmeta' doesn't exist

    I see in other topic that wp_2 table is for the second website, the main website in 3.6 still use wp_ .But I didn’t create any website yet.

    here is the table after install:

    +----------------------------+
    | Tables_in_gpatpajbm2f      |
    +----------------------------+
    | wp_blog_versions           |
    | wp_blogs                   |
    | wp_commentmeta             |
    | wp_comments                |
    | wp_links                   |
    | wp_options                 |
    | wp_postmeta                |
    | wp_posts                   |
    | wp_registration_log        |
    | wp_signups                 |
    | wp_site                    |
    | wp_sitemeta                |
    | wp_term_relationships      |
    | wp_term_taxonomy           |
    | wp_terms                   |
    | wp_usermeta                |
    | wp_users                   |
    +----------------------------+

    So tables have been created.

    It’s a sub-directory based installation, here is the line I add in wp-config:

    define ( 'WP_ALLOW_MULTISITE', true);
    
    define('MULTISITE', true);
    define('SUBDOMAIN_INSTALL', false);
    define('DOMAIN_CURRENT_SITE', '<mywebsite>.azurewebsites.net');
    define('PATH_CURRENT_SITE', '/');
    define('SITE_ID_CURRENT_SITE', 1);
    define('BLOG_ID_CURRENT_SITE', 1);
    
    //define('WP_ALLOW_REPAIR', true);
    /* That's all, stop editing! Happy blogging. */

    and the web.config:

    <?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: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="{R:2}" />
                    </rule>
                    <rule name="WordPress Rule 6" stopProcessing="true">
                        <match url="." ignoreCase="false" />
                        <action type="Rewrite" url="index.php" />
                    </rule>
                </rules>
            </rewrite>
        </system.webServer>
    </configuration>

    I have try many times, I also try with a 3.5.2 version and same things happend.

    I did the same conversion on a wamp server, using .htaccess instead of the web.config and all work correctly, so it seems to be due to azure.

    If someone have some clues …

    Cheers

Viewing 1 replies (of 1 total)
  • I don’t know what azure is but after two days and so many tries I stopped counting I have not been able to get a multi site using 3.6 to work..

Viewing 1 replies (of 1 total)
  • The topic ‘convert WP 3.6 into multisite on azure database connection error’ is closed to new replies.