PDA

View Full Version : Excessive Queries vBulletin database error


TankerHC
05-16-2013, 03:20 AM
Getting this error a lot. Site goes up and down quite a bit and has been down three days continuously now. Members are unable to login and new members are unable to register. Currently I (Admin) am the only one able to log in.

Contacted Host (ipage) and was told my database excessive query limit has been reached and continues to be excessive. Problem is we are a startup, have about 140 members, and around 2000 posts in 3 months. Looking at traffic, it is minimal. We are authorized 75,000 queries per hour. We are not even close to that. All Bots have been blocked. I have received 13 of these vBulletin error messages in the last 3 days.

Host ipage
Site www.usgunowners.org
vBulletin Ver. 4.2.1

vBulletin Error message

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections
/hermes/bosoraweb067/b1198/ipg.usgunownersorg/upload/upload/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Saturday, May 11th 2013 @ 12:33:53 AM
Error Date : Saturday, May 11th 2013 @ 12:33:53 AM
Script : http://usgunowners.org/upload/
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

Tech at Host says it looks like a coding error is causing it. Possibly installs of Styles or addons. This is what I have added on.

Ban Spider by UserAgent
Fassim Anti Spam
Forum Runner
Mini Youtube for Profile
My Threads & My Posts
One Touch Ban & Cleaner
VSa - Advanced Forum Statistics
Yet Another Award System 4.0

One style not in use.

Any help would be appreciated. This isnt the first time this has happened, but it is the longest. No better way to lose members than to not be accessible.

John Lester
05-16-2013, 05:20 PM
The first thing to try is turning off / disabling all of your addons (either through your ACP or via config.php). Then if the site operates normally, you turn on one and test for a couple of days. Repeat until you find one that exceeds the query limit.