Database errors after enabling Multi Site

  • Resolved DanShew

    (@danshew)


    10 years, 2 months ago

    I enabled Multi site and my main site seemed to be working ok – however, after making changes to the wp-config.php file, upon loading my site it said ‘Error establishing Database connection’

    I then enabled Repair mode in the my wp-config.php files and ran the repair using ‘Repair Database.’ After checking, it said that these were the errors:

    wp_1_posts: Table ‘dkmmaindb.wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘dkmmaindb.wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘dkmmaindb.wp_1_links’ doesn’t exist
    wp_1_options: Table ‘dkmmaindb.wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘dkmmaindb.wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘dkmmaindb.wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘dkmmaindb.wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘dkmmaindb.wp_1_term_relationships’ doesn’t exist
    wp_1_commentmeta: Table ‘dkmmaindb.wp_1_commentmeta’ doesn’t exist

    Hope I can edit my wp-config.php file to get back to a working mode.

    Any help would be greatly appreciated.

    Thanks,
    Dan

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    In your wp-config.php, what’s the multisite section look like?

    Normally this means you’re missing ONE of the defines for Multisite.

    Thread Starter DanShew

    (@danshew)

    I have resolved the issue – seems that I had an extra space in the first line (see below). After removing the space before ‘WP_ALLOW_MULTISITE’, the database was able to connect. Still having trouble getting my Multi Site to work properly, but at least the main site is working ok. Thanks for your help.

    /* Multisite */
    define( ‘WP_ALLOW_MULTISITE’, true );
    define(‘SUBDOMAIN_INSTALL’, true);
    define(‘DOMAIN_CURRENT_SITE’, ‘darrenkmoore.com’);
    define(‘PATH_CURRENT_SITE’, ‘/’);
    define(‘SITE_ID_CURRENT_SITE’, 1);
    define(‘BLOG_ID_CURRENT_SITE’, 1);

    /* That’s all, stop editing! Happy blogging. */

    define( ‘WP_ALLOW_REPAIR’, true );

    Dan

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Actually… You’re missing a line.

    define( 'MULTISITE', true );

    The space shouldn’t matter in the least.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database errors after enabling Multi Site’ is closed to new replies.