WordPress.org

Ready to get started?Download WordPress

Forums

Multisite crash after update (5 posts)

  1. amanda_schmitz
    Member
    Posted 2 years ago #

    I have our WP install set-up as a multisite with Domain mapping. Site and mapping was working great in version 3.3, of course I backed up the database before updating to version 3.4.1. After the update to the new version my main site worked fine, but my one network site gave me this error -> Error establishing a database connection
    Then, when I log into the admin and I was prompted to repair the site so I ran the repair and got this:
    wp_2_posts: Table 'bra1202410323917.wp_2_posts' doesn't exist
    wp_2_comments: Table 'bra1202410323917.wp_2_comments' doesn't exist
    wp_2_links: Table 'bra1202410323917.wp_2_links' doesn't exist
    wp_2_options: Table 'bra1202410323917.wp_2_options' doesn't exist
    wp_2_postmeta: Table 'bra1202410323917.wp_2_postmeta' doesn't exist
    wp_2_terms: Table 'bra1202410323917.wp_2_terms' doesn't exist
    wp_2_term_taxonomy: Table 'bra1202410323917.wp_2_term_taxonomy' doesn't exist
    wp_2_term_relationships: Table 'bra1202410323917.wp_2_term_relationships' doesn't exist
    wp_2_commentmeta: Table 'bra1202410323917.wp_2_commentmeta' doesn't exist

    What I tried:
    • Restoring the backup and it did not solve the problem.
    • Andrea Rennick suggested in her creating a WordPress Network that if you get the Error establishing a database connection, it usually means the extra tables were not created. She suggested making sure the database user has ALL permissions on the database. So I contacted my host (goDaddy.com) to check SQL permissions to make sure I can create tables and they said they could not tell me where or how to set the permission – I was not able to find the permission setting myself. Ugh.
    • I also just tried to add another site to the network and I could not, I got this error: Missing or invalid site address.

    So at this point I am not sure how I should approach fixing this mess? I think I am over my head with this one.

  2. First step is to go into your DB and see if those tables actually exist.

    You may need to run a repair of the DB via phpMyAdmin, or whatever it is that GoDaddy uses.

  3. amanda_schmitz
    Member
    Posted 2 years ago #

    Thanks for the input Mike,

    I checked the DB and there are no wp_2_.... tables only the default wp_... tables. I am going to look around GoDaddys site to see if I can figure out how to repair the DB. I clicked on the phpMyAdmin tool and it launched the home view -it looks like they use a tool called Starfield technology - which unfortunately looks nothing like phpMyAdmin that I have worked in some in the past. The link to documentation is broken in the tool so I am going to do some research.

  4. YossarianC
    Member
    Posted 2 years ago #

    Make sure Line 2 shown below exists in wp-config.php

    1: define('WP_ALLOW_MULTISITE', true);
    2: define('MULTISITE', true);
    3: define('SUBDOMAIN_INSTALL', false);
    4: $base = '/<YOUR_DIRECTORY>/';
    5: define('DOMAIN_CURRENT_SITE', '<YOUR_URL>');
    6: define('PATH_CURRENT_SITE', '/<YOUR_PATH>/');
    7: define('SITE_ID_CURRENT_SITE', 1);
    8: define('BLOG_ID_CURRENT_SITE', 1);

    Regards

  5. amanda_schmitz
    Member
    Posted 2 years ago #

    Thanks for the suggestion YossarianC.

    I checked the config file and all the code above is present.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags