vBulletin Database Error number 2006

[blackberry]

Hi,

Whenever I email/Pm users I get this Database error
Can someone please help how to fix it?

Database error in vBulletin 4.2.2:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, November 5th 2013 @ 06:00:58 PM
Error Date : Tuesday, November 5th 2013 @ 06:03:06 PM
Script : http://sachiidosti.com/forum/cron.php?rand=1383674446
Referrer : http://sachiidosti.com/forum/mobile-...-pakistan.html
IP Address : xxx.xx.xx.xxx
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

[ForceHSS]

MySQL server has gone away
You need to talk to your host if this happens all the time if only this once don't worry about it

[blackberry]

Originally Posted by ForceHSS

MySQL server has gone away
You need to talk to your host if this happens all the time if only this once don't worry about it

they increased the wait_timeout=4000 and max_allowed_packets = 3 Gigs

now i get email after every 10 mins :-s

any idea how to fix it?

[ForceHSS]

Tell them the problem

[blackberry]

Originally Posted by ForceHSS

Tell them the problem

its fixed now thanks

[jpsandiego]

Does anyone know how to make vBulletin handle this error better? I found that my site went down completely when the master MySQL server went offline. I'm thinking that on my Apache/PHP side there's a timeout that was set too high or something. Perhaps vBulletin's MySQL code is too optimistic?

I was figuring that without the master, vBulletin would figure to use a slave temporarily, but it did not which is very disappointing.

[ForceHSS]

Originally Posted by jpsandiego

Does anyone know how to make vBulletin handle this error better? I found that my site went down completely when the master MySQL server went offline. I'm thinking that on my Apache/PHP side there's a timeout that was set too high or something. Perhaps vBulletin's MySQL code is too optimistic?

I was figuring that without the master, vBulletin would figure to use a slave temporarily, but it did not which is very disappointing.

Yes get a better host that have better up time