Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2013, 03:20 AM
TankerHC TankerHC is offline
 
Join Date: Sep 2012
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Excessive Queries vBulletin database error

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.
Reply With Quote
  #2  
Old 05-16-2013, 05:20 PM
John Lester John Lester is offline
 
Join Date: Nov 2004
Posts: 543
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:58 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04017 seconds
  • Memory Usage 2,165KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete