convert WP 3.6 into multisite on azure database connection error
-
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
- The topic ‘convert WP 3.6 into multisite on azure database connection error’ is closed to new replies.