Status
Not open for further replies.

twolegit

Customer
Hey guys

i just started to notice these database errors and wonder if you know how to fix it?

Code:
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User twolegit_vb1 already has more than 'max_user_connections' active connections
/home3/twolegit/public_html/forums/includes/class_core.php on line 317
 
I moved this as it's not really a downloads question.
What is your max_connections set to in your mysql config file? You also want to get an estimate on how many users you have on at about that time.
 
right on, i though i was going crazy there for a minute.

so anyways i'm not sure what its set at in the config file? or how to find it?

but members online really shouldn't been a problem since i just opened in jan and the most ever was 41 so i would hope thats not a problem or my host really sucks ;)
 
If it's a windows box it's called my.ini, if it's linux it's my.cnf. The location depends on the server
On a linux box it's usually in one of these directories

/etc/my.cnf
/etc/mysql/my.cnf
/usr/etc/my.cnf

The setting is called max_connections
 
I cant even find that file for the life of me, I've searched my cpanel file manager and phpmyadmin....did i mention I'm a real noob? lmao
 
i use bluehost.com so most likely shared...but i'm not even sure about that, i just started a website with no experience
 
If you have access to SSH (aka Shell access) you can type locate my.cnf - but if you're not comfortable enough with Linux commands or editors that you feel confident you don't accidentally break something (you have no idea how many times I got spammed down with DB error emails and people complaining because I brokeded it :D) then I suggest contacting your host, and also ask them to estimate a good number to increase it to based on your server's usage stats - they should have access to those stats :)
 
Status
Not open for further replies.
Back
Top