WP multisite fails to create relevant MySQL tables on Jelastic
-
On https://app.jelastic.planeetta.net/ I’ve created an environment at https://[name].jelastic.planeetta.net/ with Apache, MySQL, IPv4 enabled and WordPress.
I changed the WordPress installation from single site to multisite. I configured wp-config.php and .htaccess to enable multisite with a subdirectory path structure (i.e. not subdomains).
When I try to create a new site from within the multisite WP install (WP Dashboard -> My Sites -> Network Admin -> Sites -> Add New), I can submit a Site Address (e.g. ‘fi’), a Site Title (e.g. ‘[name] Suomi’) and my Admin Email.
However, when I then push the button ‘Add Site’, my browser tries to load https://[name].jelastic.planeetta.net/wp-admin/network/site-new.php?action=add-site , but it only returns a blank browser window.
If I then return to the list of sites (Network Admin -> Sites), I see the new site listed as ‘/fi/’.
I can go to Edit Site at https://[name].jelastic.planeetta.net/wp-admin/network/site-info.php?id=3
However, if I try to go to https://[name].jelastic.planeetta.net/fi/ , I receive an error message:
Error establishing a database connection.
From the list of sites (Network Admin -> Sites), I can see that the Dashboard link pertaining to /fi/ points to https://[name].jelastic.planeetta.net/wp-admin/ instead of https://[name].jelastic.planeetta.net/fi/wp-admin/, and that the Visit link pertaining to /fi/ points to https://[name].jelastic.planeetta.net/ instead of https://[name].jelastic.planeetta.net/fi/ .
If I point my browser at https://[name].jelastic.planeetta.net/fi/wp-admin/, the following error message is returned:
One or more database tables are unavailable. The database may need to be repaired.
When I click the ‘repaired’ link, it returns the following instruction:
To allow use of this page to automatically repair database problems, please add the following line to your wp-config.php file. Once this line is added to your config, reload this page.
define(‘WP_ALLOW_REPAIR’, true);
After editing the wp-config.php file accordingly, I reload the page and it returns the following message:
One or more database tables are unavailable. To allow WordPress to attempt to repair these tables, press the “Repair Database” button. Repairing can take a while, so please be patient.
[ Repair Database ]WordPress can also attempt to optimise the database. This improves performance in some situations. Repairing and optimising the database can take a long time and the database will be locked while optimising.
[ Repair and Optimise Dababase ]When I click the button [ Repair Database ], the following list of errors is returned:
Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.
name_3_posts: Table ‘name.name_3_posts’ doesn’t exist
name_3_comments: Table ‘name.name_3_comments’ doesn’t exist
name_3_links: Table ‘name.name_3_links’ doesn’t exist
name_3_options: Table ‘name.name_3_options’ doesn’t exist
name_3_postmeta: Table ‘name.name_3_postmeta’ doesn’t exist
name_3_terms: Table ‘name.name_3_terms’ doesn’t exist
name_3_term_taxonomy: Table ‘name.name_3_term_taxonomy’ doesn’t exist
name_3_term_relationships: Table ‘name.name_3_term_relationships’ doesn’t exist
name_3_commentmeta: Table ‘name.name_3_commentmeta’ doesn’t existSo, ehh… what might be preventing my WordPress multisite installation from being able to fully create Sites under subdirectory paths?
Much appreciated
- The topic ‘WP multisite fails to create relevant MySQL tables on Jelastic’ is closed to new replies.