vBulletin Database Error number 2006
 

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 :

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?

Tell them the problem

its fixed now thanks :D

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