PDA

View Full Version : I really need help !


Milobil
07-23-2012, 11:08 AM
First, sorry for my english (i'm not).

Yesterday, i wanted to access to my forum, but i saw database error in the index page, so i I logged on my mailbox (gmail) and vbulletin (my forum) sent me some errors for database like this :
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxx already has more than 'max_user_connections' active connections
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Monday, July 23rd 2012 @ 02:19:38 AM
Error Date : Monday, July 23rd 2012 @ 02:19:38 AM
Script : http://www.myforum.com/forum/css.php?styleid=3&langid=1&d=1342049041&td=ltr&sheet=forumbits.css,forumhome.css,options.css
Referrer : http://www.myforum.com/forum/forum.php
IP Address : XXX.XX.XX.XXX
Username :
Classname : vB_Database
MySQL Version :

Or this :
Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,


NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed, emailupdate, folderid,
post.pagetext AS description,
thread.*


FROM thread AS thread

LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 0 AND subscribethread.canview = 1)


LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid = 406;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, July 23rd 2012 @ 01:59:27 AM
Error Date : Monday, July 23rd 2012 @ 02:14:13 AM
Script : http://www.myforum.com/forum/newreply.php?do=newreply&t=406
Referrer :
IP Address : XXX.XX.XX.XX
Username : Unregistered
Classname : vB_Database
MySQL Version :

So after i saw those errors, i went to my host and connect to mysql database using phpmyadmin and miraculously, my forum was now accessible and on...

I just wanted to know what are those errors and what i have to do to avoid this in the future.

Thank you for your help.

kh99
07-23-2012, 12:21 PM
Those have to do with your server configuration and not vbulletin. If it only happened once, I wouldn't worry about it. If it continues to happen you should contact your host and ask them about it.

Milobil
07-23-2012, 10:38 PM
Ok i have this problem now :

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (11)
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Tuesday, July 24th 2012 @ 01:31:44 AM
Error Date : Tuesday, July 24th 2012 @ 01:31:44 AM
Script : http://www.myforum.com/forum/login.php?do=login
Referrer :
IP Address : XXX.XX.XX.XX
Username :
Classname : vB_Database
MySQL Version :

When i want to connect to mysql using phpmyadmin, the page does not load, it comes from there ?

kh99
07-23-2012, 10:43 PM
It sounds to me like maybe your mysql server isn't running.

Milobil
07-23-2012, 10:49 PM
So i have to contact my host ?
PS : I have seen this error too :
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User mysqluser already has more than 'max_user_connections' active connections
/home/ah40607/web/www/forum/includes/class_core.php on line 317

MySQL Error :
Error Number :
Request Date : Tuesday, July 24th 2012 @ 01:42:26 AM
Error Date : Tuesday, July 24th 2012 @ 01:43:08 AM
Script : http://www.myforum.com/forum/newreply.php?p=5197&noquote=1
Referrer : http://www.myforum.com/forum/showthread.php?173-What-U-Want-But-In-Anal-Version-(Collection-By-ChapterX)/page7
IP Address : 41.226.67.230
Username :
Classname : vB_Database
MySQL Version :

mysqluser (it's not the real mysql username) already has more than 'max_user_connections' active connections ?
What it means ?