Error establishing a Database Connection

Just so I understand, when you deactivate woocommerce, you can login to wordpress and it works no problem, but when you activate woocommerce, database connection error?

If this is correct, the only conclusion I can come to is that your database is corrupt. Log into MyPHP admin and repair the tables in your database and see if that works.

If you can’t get into wordpress at all, then it would lead me to believe a problem with your wp-config file and the database credentials.

I did once have a problem like this I couldn’t explain, so I added another user to the database with full credentials and then changed up the wp-config to login to the database with the new users credentials and then it magically worked.

Please clarify the issue.

Pablostevens71
That is correct. With woocommerce disabled the theme runs correctly and the pages load (very slowly about 60-90 seconds per page). Unfortunately, all my products and catagories are in woocommerce so the theme by itself is useless.
How do I repair the tables in the database. I do believe the database may be corrupt also, at least, that is what GoDaddy Tech support said.
Thank you,

60 – 90 seconds page load suggests a much deeper issue with your database. I suspect since things are already messed up in there it’s not woo specifically, just that because woo is a complex plugin and makes a lot of db queries it tips things over the edge if you like and everything grinds to a halt.

You’re probably best to restore the db from your most recent backup. Best guess is another plugin you’re recently added has been going nuts and made you db balloon to a huge size and/or corrupted things.

So bottom line Woo is unlikely the culprit – it’s just the plugin that causes your poorly database to become un-usable.

DB table “repairs” are way beyond the scope of what we can reasonably work through on a support ticket here. Restoring from backup is your best option.

Cheers

SteveHoneyNZ
Hi Steve,
I tried a restore before I posted this thread. To your suggestion I went back and completed a restore from a couple days earlier and it worked! So simple yet it cost me so much $ with my site down. Anyway, it is fixed. Thank you GREATLY for your help.

Happy to help, I’d just also flag that you should still work out what the issue was! A good starting point is any plugin that does recommendations or makes associations between products/posts, those relational plugins can get out of hand in db entries quickly. Just a guess, whatever you do make sure you work out the underlying issue ??