Database Error

[revmitchell]

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT *
FROM bbcode;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, June 9th 2008 @ 10:35:26 AM
Error Date : Monday, June 9th 2008 @ 10:37:25 AM
Script : http://www.pastors-source.com/vb/external.php?type=RSS2&forumids=50
Referrer :
IP Address : 69.202.191.245
Username : Unregistered
Classname : vB_Database
MySQL Version :


Any ideas what this is a result from?

[briansol]

it happens from time to time.

a number of things could cause it-- a huge query owning the server, too many connections, etc etc.

if you get a lot of them, you should probably have a look at my.cnf config file and tweak it.

[Wayne Luke]

MySQL closed the connection before it finished returning the results to the PHP script. Check your wait_timeout value and make sure that it is set to at least 120. You can see what the value is in your Admin CP under:

Maintenance -> Diagnostics -> System Variables -> MySQL Variables. It will be the last one listed.

To change it you would edit your my.cnf (my.ini on Windows) file and increase the value. If you're on shared hosting, you will need to ask your hosting provider to increase this.

[revmitchell]

Thanks!:D