V Bulletin Error

[Leeds]

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 1,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, July 26th 2011 @ 06:55:22 PM
Error Date : Tuesday, July 26th 2011 @ 06:59:02 PM
Script :
Referrer :
IP Address : 119.63.196.116
Username : Unregistered
Classname : vB_Database
MySQL Version :


(Next to Script is my sites address)



Any ideas what I need to do exactly..only experienced answers no guessing

Leeds Reviewed by Leeds on 26th Jul 2011. V Bulletin Error Database error in vBulletin 3.8.4: Invalid SQL: UPDATE datastore SET data = data - 1, data = IF(data < 0, 0, data) WHERE title = 'mailqueue'; MySQL Error : MySQL server has gone away Rating: 5

[chems]

try to repair your db from phpmyadmin

if no result check your host support

[Lock Down]

MySQL Error : MySQL server has gone away (not a vb error)

The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. In this case, you normally get one of the following error codes (which one you get is operating system-dependent).

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[Leeds]

I've had a bunch of different errors that says 'MySQL server has gone away'

I am more interested in this part of the error as its abit more specific to others that I've had

UPDATE datastore SET
data = data - 1,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

Thanks anyway guys I will check what you have posted

[Lock Down]

That type of update on a very large table could take some time.

You can have host or yourself check the wait_timeout setting in mysql configuration and double it. See if that helps.

[l0calh0st]

There are too many connections to the SQL server and the service will drop all connections. Increase the SQL maxconnections/timeout. Or your server is running out of memory.

[cyber.crime]

lol the problem is this WHERE title = 'mailqueue';

u have a problem with that disable mailqueue'; at vbulletin option and enable with locking