The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
MySQL problem!! Please help!
Ok, there have been two problems so far with my MySQl table while I was gone, and I recieved over 100 emails from my vBulletin board telling me that there has been an error.
Here are the 3 emails: De: <thechief@gamebgs.com> ?: <thechief@gamebgs.com> Objet: vBulletin Database Error! Date: November 9, 2005 7:23 PM Database error in vBulletin : Code:
mysql_connect(): User gamebgs_admin has already more than 'max_user_connections' active connections /home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273 MySQL Error : Error Number : Date : Thursday, November 10th 2005 @ 12:23:31 AM Script : http://etalk.gamebgs.com/forums/index.php Referrer : IP Address : 69.230.135.249 Username : Classname : vb_database Code:
Database error in vBulletin : mysql_connect(): Too many connections /home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273 MySQL Error : Error Number : Date : Thursday, November 10th 2005 @ 02:01:44 AM Script : http://etalk.gamebgs.com/forums/index.php Referrer : http://etalk.gamebgs.com/index.html IP Address : 205.188.116.10 Username : Classname : vb_database Code:
Database error in vBulletin : mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) /home2/gamebgs/public_html/etalk/forums/includes/class_core.php on line 273 MySQL Error : Error Number : Date : Thursday, November 10th 2005 @ 02:10:41 AM Script : http://etalk.gamebgs.com/forums/index.php Referrer : IP Address : 64.12.116.9 Username : Classname : vb_database Can some please help me fix this, my users can't login bvecause of this and they keep getting errors!! Thanks! |
#2
|
|||
|
|||
This is hoster's fault. Tell him about it, as he is the only one who can fix it.
|
#3
|
||||
|
||||
Well I have contacted them, I really hope they will respond soon, I thought maybe it had something to do with vB???
|
#4
|
|||
|
|||
Well it might be
Can you please check your /includes/config.php for this line and tell us what the value is? If the value is 1 try setting it to 0 Code:
// ****** MASTER DATABASE PERSISTENT CONNECTIONS ****** // This option allows you to turn persistent connections to MySQL on or off. // The difference in performance is negligible for all but the largest boards. // If you are unsure what this should be, leave it off. (0 = off; 1 = on) $config['MasterServer']['usepconnect'] = 0; |
#5
|
||||
|
||||
Im not a master admin, however unless you have access to your mysql conig file, your host will need to change it. It may also be some rouge script that has hijacked mysql resources. I had this once. Only solution was to periodically reboot which was a serious pain. I eventually moved servers and left behind whatever script caused it (my personal feelings was that it was with a particular email program that plugged into vb).
Personally, I would be my money its a rouge script. |
#6
|
|||
|
|||
Using pconnect can also cause these symptoms.
What vB version are you using? If you look at vb.com you will see an increased number of reports on similar errors since 3.5.1 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|