MySQL Error

[jbizzle]

I am getting multiple SQL errors

MySQL Error : MySQL server has gone away

Also, these errors.

Database error in vBulletin 3.8.4:

Invalid SQL:

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



Invalid SQL:

UPDATE session
SET lastactivity = 1268165777, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U;
Windows NT 6.0; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18 (.NET CLR
3.5.30729)'
WHERE sessionhash = '56542e98237a161685411bbfa1c02463';




Invalid SQL:

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


I never use to get vBulletin errors...

[Lynne]

You didn't include the necessary part of the error we need to see for the last three you listed (we need to see the bottom portion that is under what you posted). But, the first one,
MySQL server has gone away, is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

[jbizzle]

Here is one of them i'll post the others once I get them

Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1268345339, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0
WHERE sessionhash = '6eaea1d8673725d867f7f5aa36a14259';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, March 11th 2010 @ 04:08:59 PM
Error Date : Thursday, March 11th 2010 @ 04:09:24 PM
Script : http://www.mwcaraudio.net/forum/admincp/email.php?do=dosendmail
Referrer : http://www.mwcaraudio.net/forum/admincp/email.php?do=start
IP Address : xxxx
Username : jbizzle
Classname : vB_Database
MySQL Version :


--------------- Added 1268345549 at 1268345549 ---------------

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
AND varname = 'registeremail' AND languageid IN (-1, 0, 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, February 27th 2010 @ 08:28:14 AM
Error Date : Saturday, February 27th 2010 @ 08:28:37 AM
Script : http://mwcaraudio.net/forum/register.php?do=addmember
Referrer : http://mwcaraudio.net/forum/register.php?do=register
IP Address : xxxx
Username : GRMax09
Classname : vB_Database
MySQL Version :


Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1268165777, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U;
Windows NT 6.0; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18 (.NET CLR
3.5.30729)'
WHERE sessionhash = '56542e98237a161685411bbfa1c02463';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, March 9th 2010 @ 02:16:17 PM
Error Date : Tuesday, March 9th 2010 @ 02:18:07 PM
Script : http://mwcaraudio.net/forum/admincp/email.php?do=dosendmail
Referrer : http://mwcaraudio.net/forum/admincp/email.php?do=start
IP Address : xxxx
Username : jbizzle
Classname : vB_Database
MySQL Version :



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, March 9th 2010 @ 02:20:14 PM
Error Date : Tuesday, March 9th 2010 @ 02:21:02 PM
Script : http://mwcaraudio.net/forum/index.php
Referrer : http://mwcaraudio.net/forum/index.php
IP Address : xxxx
Username : jbizzle
Classname : vB_Database
MySQL Version :


^^^

[Lynne]

This is a server issue. See this: http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway and this: http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

[jbizzle]

I switched hosts, I am now with a company who specializes in hosting vBulletin forums. Hopefully I have no issues anymore.