I've been averaging a lot of database errors lately, in the last month. I consistently get this message -
Database error in vBulletin :
mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/mysite/public_html/mysite/forums/includes/class_core.php on line 274
MySQL Error :
Error Number :
Date : Wednesday, April 30th 2008 @ 08:35:19 PM
Script : http://mysite.com/misc.php?do=cybstats
Referrer : http://mysite.com/misc.php?do=cybstats
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
Not sure what it means, I blocked out some of the info just in case it would be bad to know my site or the ip address (person who recieved the error).
Well yea, I've been getting a lot of database error messages through email.
Here's another one. Now I'm not running any queries or anything, does the server, vb run queries on its own...because I'm getting kinda scared if someone is manually running queries and it's not me doing it.
Database error in vBulletin 3.6.9:
Invalid SQL:
SELECT *
FROM vb_session
WHERE sessionhash = 'f245e72410c445375109a5de4cae3bb4'
AND lastactivity > 1209607989
AND idhash = 'cd2b5af35d4a3cbbcf91f302da06ef9c';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, this date @ 08:32:57 PM
Script : mysite.com
Referrer :
IP Address : IP address xxxx.x.xx.xx.x
Username :
Classname : vB_Database
You can do some reading about it here: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html.
My guess is, your server is too stressed out from usage, but it could be a lot of things.
vb does do many queries.
I've experienced several "mysql gone away" error situations, that ended up being linked to either improper code or something that didn't function properly after an upgrade or chance.
Print out the page that lists your installed plugins, and then start disabling/un-installing them one by one until the errors stop. Since the first error message is associated with the cybstats plugin I'd start there.
Keep disabling until the error messages stop. The culprit could be an improper configuration, or something that requires additional server configuration to properly support.
Hope this helps,
Cyb has some of the best/well programed plugins here. I doubt its his. Your probally on a shared server or a mis configured dedicated server.
If you are on a shared server its either overloaded or you just have way to many plugins/mods running.
If you are on a dedicated server ask for a server optimization over at vb.com
I only have 9 mods.
My host is - bluehost.com
--------------- Added 1209964053 at 1209964053 ---------------
vb does do many queries.
I've experienced several "mysql gone away" error situations, that ended up being linked to either improper code or something that didn't function properly after an upgrade or chance.
Print out the page that lists your installed plugins, and then start disabling/un-installing them one by one until the errors stop. Since the first error message is associated with the cybstats plugin I'd start there.
Keep disabling until the error messages stop. The culprit could be an improper configuration, or something that requires additional server configuration to properly support.
Hope this helps,
Thanks, I'll look into it.
Chances are good that the host is experiencing problems and its out of your hands.
You can either sit there and take crappy hosting, or you can go find a hosting company that works.