MySQL has gone away errors...

[pityocamptes]

I contacted my host and they are saying that the issue is on my side, though they can't say what it is, just that's its code, or corrupt DB, etc. Does that sound right? Any suggestions on how to fix this? Thanks.

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 : Friday, December 20th 2013 @ 09:20:32 PM
Error Date : Friday, December 20th 2013 @ 09:21:56 PM
Script : http://www.gunsgrubandgold.com/cron.php?rand=1387599631
Referrer : https://www.gunsgrubandgold.com/content/115-financials
IP Address : XXXXXXXXXXXXXXXX
Username : Unregistered
Classname : vB_Database
MySQL Version :

[ForceHSS]

This is server host side dont listen to them saying this is ur fault

[pityocamptes]

Ok, will get back to them... thanks.

[ozzy47]

Find out what the wait_timeout is set to.

[pityocamptes]

Is that something in php.ini or host provides that?

[Lynne]

"MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

The wait_timeout is actually a MySQL variable. By default it is set to 28800, but most sites are fine with it set around 300.

[Paul M]

Originally Posted by pityocamptes

I contacted my host and they are saying that the issue is on my side, though they can't say what it is

Start looknig for a new host.

Seriously - if this is an example of their level of their competance then you have no chance if you hit a real problem.

Look for a host that has at least a clue about what they are doing.

[Max Taxable]

You are always going to see this on shared hosting that is OVERSOLD. Paul is right, you need to get a competent and responsible host. Alot of them OVERSELL the cheaper shared hosting, then try to blame you when the server farts from overload. Then they try to up-sell you. Been through this for years, seen it time and time again not just personally but with many friends as well, on different platforms too.

It's not you, it's definitely not vBulletin, it's their oversold machine.

[steve3402000]

Who said programmers don't have a sense of humor. Not to minimize the obvious, but " the server has gone away " OMG man.. lol Might have just said " your server has left the building "

Steve

[pityocamptes]

Ok, my contract expires in a couple of months. Anyone recommend a good, inexpensive host? Thanks.