"Error establishing a database connection" adding new site

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 (https://revistadepunta.com/test/) it shows me “Error establishing a database connection” and the root site (https://revistadepunta.com) rusn OK

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

thanks !
wiki

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 ??

If I go to https://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 (https://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

Yep, then it was likely a plugin.

yeah!

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

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

Banner Rotator: https://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?

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?