vb.org Archive - mysql_connect Database Errors

Page 1 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - mysql_connect Database Errors (https://vborg.vbsupport.ru/showthread.php?t=243703)

Chalex4

06-01-2010 09:41 AM

mysql_connect Database Errors

Ever since I upgraded to vbulletin 4, my forum constantly seems to be getting database errors along the lines of this (I've got 1000 emails just today):

Code:

Database error in vBulletin :



mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxxx_forum already has more than 'max_user_connections' active connections

/home/xxxxxx/public_html/includes/class_core.php on line 312



MySQL Error   : 

Error Number  : 

Request Date  : Tuesday, June 1st 2010 @ 11:38:05 AM

Error Date    : Tuesday, June 1st 2010 @ 11:38:05 AM

Script        : http://www.atkcommunity.com/threads/clientscript/build/shadowbox.js

Referrer      : 

IP Address    : 216.104.15.130

Username      : 

Classname     : vB_Database

MySQL Version :

The script line changes in virtually every email I get to something else (probably dependent on what the person was trying to view?). However, could this be caused by my .htaccess rewrites? All the scripts begin with "http://www.atkcommunity.com/threads/".

Website: www.atkcommunity.com

Thanks in advance.

borbole

06-01-2010 01:23 PM

You should talk to your host about this.

Videx

06-02-2010 06:02 PM

I think the question is: Are you really opening a lot of connections, and how many are you allowed with your hosting package. We'd need to know how many simultaneous users you usually have, and if your hosting has a hard limit. Also if you have any mods that encourages people to stay connected (eg chatbox). Darned hard to tell much of anything when the actual error is blank like that.

You may want to try disabling all your mods for a while to see if one of them is acting up.

Chalex4

06-03-2010 09:13 AM

I've just opened a support ticket with my host, so I'll let you know what they say soon. I believe this all started when I installed the vsa chatbox and started noticing hundreds more guests just viewing the chatlogs.

A couple of days ago I changed to a different chatbox and removed the other one, but perhaps the bots are just still coming. As I said above, what's with all the scripts being at /threads? That's not actually where the scripts are as that's just an SEO thing. Is my .htaccess file to blame?

--------------- Added [DATE]1275588723[/DATE] at [TIME]1275588723[/TIME] ---------------

Here's the reply I got:

Quote:

You're allowed 25 mysql connections at once so you need to ensure that your mysql script is closing connections, this is in place so that badly coded scripts dont run away with server resources.

Any advice?

Chalex4

06-05-2010 01:43 AM

Sorry to double post, but do you guys have any ideas?

Videx

06-05-2010 03:15 AM

Quote:

Originally Posted by Chalex4 (Post 2048581)

Sorry to double post, but do you guys have any ideas?

If you're still getting 1000 errors a day, turn off all your mods. Re-enable them one at a time.

borbole

06-05-2010 09:22 AM

Quote:

Originally Posted by Chalex4 (Post 2047523)

Try to un-install the vsa chatbox then and see if the errors would stop.

Marco van Herwaarden

06-07-2010 03:29 AM

A maximum of 25 connections really is not much.

Chalex4

06-08-2010 05:05 PM

I think that the problem's now sorted thanks. I just made sure that all evidence of the VSA shoutbox was gone. For some reason it just attracted loads of bots.

Marco I'm interested to hear why 25 isn't enough so that I can talk to my host about it. Also, if I decide to switch, I'd like to know what a good number is.

Zachery

06-08-2010 05:07 PM

It comes down to mean you can have 25 active mysql connections total. If you had 26+ users online at the same time, or possibly higehr, your users will get those errors.

All times are GMT. The time now is 02:27 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01040 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: