Error establishing a database connection

  • Resolved tootsie

    (@tootsie)


    15 years, 1 month ago

    hello everyone.

    i’m new to WP so i have been following the installation guides exactly as written. i am trying to set up a network. first i installed WP 3.0.5 and was successful logging in to my new site. great! everything is working, i can add posts and change themes, etc.

    so, then i followed the instructions to install a network. i went into config.php and added: define(‘WP_ALLOW_MULTISITE’, true);. when i reloaded my admin page the Network option showed under Tools. i selected sub-directories and moved on to the next step. i did everything it said, adding the blog.dir directory, adding code to config.php and .htaccess.

    when i returned and clicked Log In again, i get “Error establishing a database connection.” if i just go to my url, the site no longer load and it shows the same error.

    so what happened? i didn’t change anything to do with my database, login or password. i even went so far as to erase my database and reinstall everything but the exact same thing is happening. any clues would greatly be appreciated. thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter tootsie

    (@tootsie)

    15 years, 1 month ago

    so i saw on another post someone suggested running wp-admin/maint/repair.php?referrer=is_blog_installed. i did that and this is the error i got:

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

    so why aren’t the tables for the network creating properly? i have installed, cleared, and reinstalled three times and it keeps happening the same.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    15 years, 1 month ago

    Check that your SQL ID has permissions to CREATE new tables.

    Also what’s the multisite section of your wp-config.php file look like? You should have BOTH of these:

    define('WP_ALLOW_MULTISITE', true);
define( 'MULTISITE', true );

    Thread Starter tootsie

    (@tootsie)

    15 years, 1 month ago

    thank you, thank you!

    all i needed was that one line in my config.php file:

    define( ‘MULTISITE’, true );

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error establishing a database connection’ is closed to new replies.