The band-aid fix is simply a system that monitors it for the same problem every 5 minutes and text messages my cell phone if there is a problem. That way I know within 5 minutes, rather than 6 hours (like before). It's a relatively rare thing that happens with MySQL apparently (first time it's happened to me in a few years running it, and only will happen under certain circumstances). The "ultimate" fix is going to have to come from MySQL though since it's an issue with that. But it's being worked on, so...
yup, I had a few sites with hostgator as well and they suspended my account, and I talked to them, and they put me back on promise that I wont use ad_network.php I am now moving my websites to another server. Somebody, Please recommend me a good dedicated server. I am ready to pay what is fair, but do not want to over pay. All companies that I have seen have some good reviews and some bad reviews. Somebody, please help.
A lot of people here are reccomending Site 5, they seem to have good rep and value for money. http://forums.digitalpoint.com/showthread.php?t=26815
I made a couple minor changes to the ad_network PHP file that should suppress the errors if it were ever to happen again.