vBulletin Database Error help

[silver.fox1969]

I have been trying to figure out this error on our forum for the last 3-4 weeks with no luck.

I have looked though the php in question to see what the error is looking at and cant figure out what it means.

If you have any idea of the solution i would be greatfull for any comments.

thanks


I get this error via email

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User ******* already has more than 'max_user_connections' active connections
/hermes/bosweb/web053/b538/ipg.***********/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Tuesday, November 22nd 2011 @ 11:03:36 AM
Error Date : Tuesday, November 22nd 2011 @ 11:03:38 AM
Script : http://********.com/******/mgc_cb_evo_ajax.php
Referrer : http://**********.com/******/vaispy.php
IP Address : *.**.**.44.14
Username :
Classname : vB_Database
MySQL Version :

[kh99]

Lynne answered a similar question inthis thread: https://vborg.vbsupport.ru/showthread.php?t=267296

[silver.fox1969]

thanks i will take a look now, been looking around every where must have missed that post

[kh99]

It's ok, it's just easier to post a link than to post the answer again. But yeah, pretty much any db errors you get, if you search for part of the error message you'll probably find that a bunch of other people have had the same problem.

[silver.fox1969]

Ok the host has come back with they allow 10 connections at one time with no option to upgrade.

Going from that link it looks like you dont need alot of connection to run with out any problems as we are only a small forum.

Is there any way of looking at whats taking the connections from vbulletin?


** sort of found it my self
http://dev.mysql.com/doc/refman/5.0/en/too-many-connections.html

got to figure out how to use it ***

[kh99]

Here's some information on persistent connections: http://us2.php.net/manual/en/features.persistent-connections.php

It's not really my area, but I think your total number of connections to the database is affected by the 'usepconnect' setting and the number of child processes your web server allows. You may be able to solve your problem by changing the web server configuration to allow fewer child processes.