Support » Networking WordPress » "Error establishing a database connection" adding new site

Viewing 15 replies - 1 through 15 (of 25 total)
  • Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    And you went through all the create a network steps as outlined in the codex?
    And you turned off plugins?

    Hi Andrea,

    Yes, i went all the steps:

    1) I’ve first “moved” mi WP installation to root directory since i had ir under /wordpress/ directory

    2) i’ve changed my wordpress directory to match my site URL

    3) disabled plugins

    4) added define(‘WP_ALLOW_MULTISITE’, true); to wp-config

    5) run Tools/Network install

    6) Added lines to wp-config & .httaccess

    7) enabled plugins

    8) added a new site

    The most surprising point is that anoying thing is that on my secondary site (http://revistadepunta.com/test/) it shows me “Error establishing a database connection” and the root site (http://revistadepunta.com) rusn OK

    i have some experience installing multisite and WPMU, but i haven’t seen this kind of error before.

    thanks !
    wiki

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Yeah, with the network feature built in now, getting the db error shouldn’t ever happen. because you’re already installed, you know?

    I gotta go pick the brain of one of the devs.

    Exactly !

    Thanks for your help ๐Ÿ™‚

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ๐Ÿณ๏ธโ€๐ŸŒˆ Halfelf Rogue & Plugin Review Team Rep

    If I go to http://revistadepunta.com/test/wp-admin/

    I get this:

    Una tabla o mรกs de la base de dato no estรกn disponibles. La base de datos debe ser reparada.

    Have you tried a repair of the database?

    Oh, i didn’t seen that,

    and how do i repair my DB ?
    If i click on “Repail” it show me a sighn of “Updating SEO configuration options in database”

    any idea ?

    here is what is shows me now !

    wp_8_posts: Table ‘dpunta_wrdp1.wp_8_posts’ doesn’t exist
    wp_8_comments: Table ‘dpunta_wrdp1.wp_8_comments’ doesn’t exist
    wp_8_links: Table ‘dpunta_wrdp1.wp_8_links’ doesn’t exist
    wp_8_options: Table ‘dpunta_wrdp1.wp_8_options’ doesn’t exist
    wp_8_postmeta: Table ‘dpunta_wrdp1.wp_8_postmeta’ doesn’t exist
    wp_8_terms: Table ‘dpunta_wrdp1.wp_8_terms’ doesn’t exist
    wp_8_term_taxonomy: Table ‘dpunta_wrdp1.wp_8_term_taxonomy’ doesn’t exist
    wp_8_term_relationships: Table ‘dpunta_wrdp1.wp_8_term_relationships’ doesn’t exist
    wp_8_commentmeta: Table ‘dpunta_wrdp1.wp_8_commentmeta’ doesn’t exist

    i think is something with plugins
    i’ve disabled all plugins, created a new site (http://revistadepunta.com/test2/) and worked

    I think my steps 7 & 8 should be donde in the oposite way

    7) add a new site

    8) enable plugins

    thanks,
    wiki

    Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Yep, then it was likely a plugin.

    yeah!

    2 plugins were causing the problem when “Network activation” was applied:

    All in One SEO Pack: http://semperfiwebdesign.com/

    Banner Rotator: http://tribulant.com/products/view/2/wordpress-banner-rotator-plugin

    Thanks !

    It seems like I am having the same error.

    But I do not have any plugins activated.

    I am running WordPress 3.0

    My main site works great: blogs.mobilitysales.com
    I have 1 secondary site that works great: blogs.mobilitysales.com/rapid-city-sd

    Now when I attempt to create a 2nd secondary site, I get the same symtoms as above.

    When I try a database repair for the secondary site it doesn’t work.
    wp_11_posts: Table ‘wordpress-mu.wp_11_posts’ doesn’t exist
    wp_11_comments: Table ‘wordpress-mu.wp_11_comments’ doesn’t exist
    wp_11_links: Table ‘wordpress-mu.wp_11_links’ doesn’t exist
    wp_11_options: Table ‘wordpress-mu.wp_11_options’ doesn’t exist
    wp_11_postmeta: Table ‘wordpress-mu.wp_11_postmeta’ doesn’t exist
    wp_11_terms: Table ‘wordpress-mu.wp_11_terms’ doesn’t exist
    wp_11_term_taxonomy: Table ‘wordpress-mu.wp_11_term_taxonomy’ doesn’t exist
    wp_11_term_relationships: Table ‘wordpress-mu.wp_11_term_relationships’ doesn’t exist
    wp_11_commentmeta: Table ‘wordpress-mu.wp_11_commentmeta’ doesn’t exist
    wp_sitemeta: 2 clients are using or haven’t closed the table properly

    Any suggestions would be great!

    Bill

    try to uncomment define( ‘MULTISITE’, true );
    try to run /wp-admin/ms-upgrade-network.php ,
    try to set english interface .

    I am now having the same issue.

    I’ve already tried removing all plugins and mu-plugins.

    I’ve tried creating the new site from admin, and by registering it as a user.

    I’ve set up the english interface.

    But the result is always the same, The blog gets created as well as the user, but not all the tables get to the database so the error stablishing connection message appears.

    What else can I try?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ๐Ÿณ๏ธโ€๐ŸŒˆ Halfelf Rogue & Plugin Review Team Rep

    The blog gets created as well as the user, but not all the tables get to the database so the error stablishing connection message appears.

    Check that the SQL id you’re using has permissions to create new tables in your database. You may need to ask your host to check on that for you.

    Thanks for your suggestion.

    I’ve checked and it’s currently: (Privileges: ALL PRIVILEGES) for the user accesing the database.

    Any other Ideas?

Viewing 15 replies - 1 through 15 (of 25 total)
  • The topic ‘"Error establishing a database connection" adding new site’ is closed to new replies.