• Resolved Schuurmudgeon

    (@schuurmudgeon)


    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 exist

    So, ehh… what might be preventing my WordPress multisite installation from being able to fully create Sites under subdirectory paths?

    Much appreciated

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WP multisite fails to create relevant MySQL tables on Jelastic’ is closed to new replies.