PDA

View Full Version : SQL error????


pityocamptes
10-07-2013, 04:04 AM
I received these two SQL errors, not sure if it was related to a mass email I did, or the two articles I posted on the CMS, it seems it might be CMS. What do they mean, and how do I fix it?

Database error in vBulletin 4.2.1:

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 : Sunday, October 6th 2013 @ 09:20:51 PM
Error Date : Sunday, October 6th 2013 @ 09:22:23 PM

IP Address : XXXXXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

Database error in vBulletin 4.2.1:

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 : Sunday, October 6th 2013 @ 09:51:56 PM
Error Date : Sunday, October 6th 2013 @ 09:53:22 PM

IP Address : XXXXXXXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

ozzy47
10-07-2013, 04:16 AM
Here is some info on it, MySQL server gone away error explained - vBulletin Community Forum (http://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-2-how-do-i-and-troubleshooting/44661-mysql-server-gone-away-error-explained)