PDA

View Full Version : vBulletin Database Error


silencio2222
09-25-2010, 02:29 AM
I started getting a database error just before I upgraded the v4.0.7 but now they are continuing.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/xxxxxxx/public_html/forum/includes/class_core.php on line 313

Any suggestions?

Thanks.

KevinL
09-25-2010, 12:25 PM
Read here http://www.vbulletin.com/docs/html/troubleshoot_mysql_errors that should help you :)

silencio2222
09-25-2010, 12:39 PM
Thanks Much. Appreciate your help. I will see what my host can share with me.

Videx
09-27-2010, 02:15 AM
If you're on shared hosting, this is a very common error on oversold servers. Check your CPU loads. As the server gets slowed down, odd errors start happening.

silencio2222
09-27-2010, 02:49 PM
Thanks...the error doesn't seem to be affecting the forum but it does concern me. The errors are generated at random times and I can't seem to pin point the error and the host doesn't seem to think that there is anything they can do short of moving it to a new server.

I did make some changes to the bandwidth and ran some mysql repair and checks using cpanel and vbulletin's options. So far so good but I don't have a clue yet if it is corrected....thanks so much for your help.

If you're on shared hosting, this is a very common error on oversold servers. Check your CPU loads. As the server gets slowed down, odd errors start happening.

Videx
09-27-2010, 03:20 PM
Although changing servers can wreak havoc, if they're actually offering to do that for free it may be your best choice. Again, assuming this is a load issue. I know a move solved ours.

Forget playing around with your vb stuff, none of that will cause the mysql socket to not be available.

silencio2222
09-27-2010, 03:24 PM
Videx,

Let me ask you if moving to a new server is recommended over creating a new mysql database on the same server?

Videx
09-27-2010, 03:34 PM
Those are two totally different things that have nothing at all to do with one another. Create all the new dbs you want, but if the server is overloaded you won't be able to connect to those at times either.