Multisite – New Dashboard not Accessible and Repair Database Failed

  • tedjordansrl

    (@tedjordansrl)


    1 month, 1 week ago

    Hello,

    I have been trying to put my site into subdomain multi site for a few weeks now but there seem to be some issues with the databases which i cannot seem to fix. First, when I create a new site within the, I cannot access the dashboard of this newly created site and am instead redirected to the main site Dashboard.

    Second, Network upgrade fails with wp_die at upgrade.php:96
    Lastly, when trying to manually access the wp-admin dashboard using the URL, I get a message saying there is an error “One or more database tables are unavailable. The database may need to be repaired.”
    I thus add the define(‘WP_ALLOW_REPAIR’, true); to the wp-config file and the repair does not see any issues with most of the tables but he cannot repair as he cannot find these tables:

    wp_3_posts: Table ‘wp_tedjordan.wp_3_posts’ doesn’t exist
    wp_3_comments: Table ‘wp_tedjordan.wp_3_comments’ doesn’t exist
    wp_3_links: Table ‘wp_tedjordan.wp_3_links’ doesn’t exist
    wp_3_options: Table ‘wp_tedjordan.wp_3_options’ doesn’t exist
    wp_3_postmeta: Table ‘wp_tedjordan.wp_3_postmeta’ doesn’t exist
    wp_3_terms: Table ‘wp_tedjordan.wp_3_terms’ doesn’t exist
    wp_3_term_taxonomy: Table ‘wp_tedjordan.wp_3_term_taxonomy’ doesn’t exist
    wp_3_term_relationships: Table ‘wp_tedjordan.wp_3_term_relationships’ doesn’t exist
    wp_3_termmeta: Table ‘wp_tedjordan.wp_3_termmeta’ doesn’t exist
    wp_3_commentmeta: Table ‘wp_tedjordan.wp_3_commentmeta’ doesn’t exist

    The main domain is tedjordan.org and the new subdomain I am testing for is blog.tedjordan.org (DNS is set up correctly). I checked the tables and there was nothing out of the ordinary I could find except that there was two wp_options tables: _wp_options and wp_options. The URL in the former was the one provided by the local host which I changed to tedjordan.org (what it is supposed to be) to see if that solves anything.

    Any idea what’s going on and how I can solve that?
    Thanks a mil.

    Tanguy

    • This topic was modified 1 month, 1 week ago by James Huff. Reason: moved to Networking WordPress since this is a multisite issue

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Joakim

    (@joa-kim)

    1 month ago

    You are describing multiple issues, which makes this debugging a bit more complex. But given the 3 you’ve described, I’d check the following:

    Subdomain Configuration

    First, ensure that your server configuration supports subdomains. For a WordPress multisite with subdomains, you need:

    • DNS Wildcard Records: You must have a wildcard DNS record (*.yourdomain.com) pointing to your server. This allows all subdomains to be routed to your server without having to set up DNS records for each new site.
    • Apache/Nginx Configuration: Your web server (Apache or Nginx) needs to be configured to accept wildcard subdomains. For Apache, ensure your VirtualHost is configured with ServerAlias *.yourdomain.com. For Nginx, you should have server_name yourdomain.com *.yourdomain.com;.

    WordPress Configuration

    • wp-config.php Settings: Verify that your wp-config.php is correctly configured for a multisite. This includes setting define('WP_ALLOW_MULTISITE', true);, define('MULTISITE', true);, define('SUBDOMAIN_INSTALL', true);, define('DOMAIN_CURRENT_SITE', 'yourdomain.com');, and define('PATH_CURRENT_SITE', '/');. Also, make sure you have the correct SITE_ID_CURRENT_SITE and BLOG_ID_CURRENT_SITE values.
    • .htaccess File: For Apache servers, make sure your .htaccess file is correctly configured as per WordPress’s network setup instructions. This file controls the URL rewriting capabilities of WordPress.

    Database

    It appears that some of the necessary tables for your new sites are not being created, which could be due to several reasons:

    • Database User Permissions: Ensure that the database user has all necessary permissions to create and modify tables in the database. This includes SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, and so on.
    • Debugging: You can enable WordPress debugging by adding define('WP_DEBUG', true); and define('WP_DEBUG_LOG', true); to your wp-config.php file to see if any specific errors are being logged.
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.

Tags