asked on

Error establishing a database connection at http://nvbcl.org

Error establishing a database connection at http://nvbcl.org

updated a sql db username now getting this message. I've checked on how to fix but the fix isn't working:

I used this to repair:

define( ‘WP_ALLOW_REPAIR’, true );

now I get this:

WordPress
The wp_users table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_users' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_users table. Error: Table 'db12356_nvbvcl.wp_users' doesn't exist

The wp_usermeta table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_usermeta table. Error: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist

The wp_posts table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_posts' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: Table 'db12356_nvbvcl.wp_posts' doesn't exist

The wp_comments table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_comments' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_comments table. Error: Table 'db12356_nvbvcl.wp_comments' doesn't exist

The wp_links table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_links' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_links table. Error: Table 'db12356_nvbvcl.wp_links' doesn't exist

The wp_options table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_options' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_options table. Error: Table 'db12356_nvbvcl.wp_options' doesn't exist

The wp_postmeta table is not okay. It is reporting the following error: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist. WordPress will attempt to repair this table…
Failed to repair the wp_postmeta table. Error: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist

The wp_terms table is okay.

The wp_term_taxonomy table is okay.

The wp_term_relationships table is okay.

The wp_commentmeta table is okay.

Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

wp_users: Table 'db12356_nvbvcl.wp_users' doesn't exist
wp_usermeta: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist
wp_posts: Table 'db12356_nvbvcl.wp_posts' doesn't exist
wp_comments: Table 'db12356_nvbvcl.wp_comments' doesn't exist
wp_links: Table 'db12356_nvbvcl.wp_links' doesn't exist
wp_options: Table 'db12356_nvbvcl.wp_options' doesn't exist
wp_postmeta: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist

I"m having issues finding where the table is to repair within the php admin window though. Anyone have any ideas or suggestions?

David Sankovsky

What sort of access do you have to server? or better yet, what sort of server is this?
If you have full administrative access to the entire server, you should be able to install phpmyadmin, if it's a shared server start by making sure that you have all the data in the wordpress configuration written down correctly, it's possible that WP can't find the tables because the db name is wrong.

Also, if it's a shared server but you are migrating from a previous hosting company, make sure you have a correct DB dump.

Quack

ASKER

Grid server via media temple...I can get into phphmyadmin but I'm not seeing any crashed table to repair

Alicia St Rose

Hi! You need to update the database user name in the wp-config.php file.

Quack

ASKER

I've tried a work around just to get the site back up but it didn't take. I've modified the wp-config file...tried the repair too...not working

Quack

ASKER

Ok...I went back to the previous db. Ran the repair process again. Got the same message/s about the tables.

Its saying these don't exist:

wp_users: Table 'db12356_nvbvcl.wp_users' doesn't exist
wp_usermeta: Table 'db12356_nvbvcl.wp_usermeta' doesn't exist
wp_posts: Table 'db12356_nvbvcl.wp_posts' doesn't exist
wp_comments: Table 'db12356_nvbvcl.wp_comments' doesn't exist
wp_links: Table 'db12356_nvbvcl.wp_links' doesn't exist
wp_options: Table 'db12356_nvbvcl.wp_options' doesn't exist
wp_postmeta: Table 'db12356_nvbvcl.wp_postmeta' doesn't exist
wp_termmeta: Table 'db12356_nvbvcl.wp_termmeta' doesn't exist

Is there a work around in wordpress for this? is there a way to find these? of course I don't have a db backup...my bad yes...Media Temple can provide one for $79.00 of course. may have to eat that and get this back up. lame.

David Sankovsky

What's the name of the DB you see in phpmyadmin? does it match the one in the error code?
Do you see a Database named db12356_nvbvcl?
if so, do you see the tables inside that DB?

Have you made sure that your DB username and DB Pass match the one in your wp-config.php file?

And no, there is no way around this, WP only works with a database.

ASKER CERTIFIED SOLUTION

Alicia St Rose

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Quack

ASKER

there was no recourse from media temple for this so I was left "out in the cold" ... very disappointed with their efforts. This suggestion was the best way forward... Lessons learned. Thanks.