PDA

View Full Version : Emergency: Database Error - Forum not working


DownNout87
12-06-2013, 10:11 PM
This morning, I attempted to update my forum to vbulletin 4.2 and I ended up with a database error.

Host 'xxxxx.hostgator.com' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

I contacted hostgator and they have no idea what a flush is or how to do it. They said it was a config file issue.

My IT guy checked the config file and everything seems fine. He said hostgator should be able to fix it.

My last resort is performing a backup restore from a week ago but I want to make sure I don't overwrite any of the database (all the posts).

Does anyone have any suggestions or can help me out? I'm receiving a ton of database error emails every minute and it's very frustrating that no one can help me out.

To add to the frustration, my IT guy has gone MIA for the past 2 hours and hasn't answered my texts or phone calls.

kh99
12-06-2013, 11:26 PM
When you upgrade, do you keep the same config.php? If so then the settings are probably still correct. You could make sure you have
$config['MasterServer']['usepconnect'] = 0;


but other than that I don't know what you could do other than to get your host to help you figure it out (the error message actually contains the command to run to clear the error, so I don't know why they say they don't know how to do it).

BTW, I'm not an expert on mysql admin, I'm just reading the error message, and I googled the error message to see what other people did about it.

tbworld
12-07-2013, 09:01 AM
This is your host being lazy, they have all the tools at their disposal to understand what is going on here. This is not an uncommon error on a users account for a host company. It frequently occurs on a shared host, especially after new scripts are added and used. It can also be caused by an attack to the mysql server, but I doubt that this is the case here.

I referred to a shared server, but connections are an integral part of all database servers.