PDA

View Full Version : Invalid SQL: MySQL has gone away


MonCher
06-22-2009, 06:29 AM
Does anyone know what would cause the following error and what I should do?

_________________________________
Database error in vBulletin 3.8.2:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1245654044,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, June 22nd 2009 @ 02:00:44 AM
Error Date : Monday, June 22nd 2009 @ 02:00:57 AM
Script : http://www.4datetalk.com/forums/cron.php?rand=1245654039
Referrer : http://www.4datetalk.com/forums/index.php?
IP Address : 97.104.87.106
Username : Unregistered
Classname : vB_Database
MySQL Version :

Thanks,

HMBeaty
06-22-2009, 06:39 AM
Thats an issue with your host. You need to contact your host

MonCher
06-22-2009, 06:56 AM
Thank you Redline. I know there should be a button I can click to say that, but, I don't see one.

HMBeaty
06-22-2009, 06:58 AM
Haha. It's ok MonCher

Carnage
06-23-2009, 08:53 PM
If i remember right, thats the error you get if the mysql server closes the connection on you unexpectedly and then you try to use that connection to send another query. In my experience the error tends to come and go occasionally I've had to restart mysql to fix it.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html for more info.

As an off topic note, the error message always seems quite depressing to me... imagine it being said by Marvin from hitchhikers guide...

MonCher
06-23-2009, 09:21 PM
Carnage - I so needed a smile today:)

Thank you for the additional reference material. That looks like a great reference
guide for MySQL. I hope that was the issue. Getting my host to respond seems
impossible. But, I tried to run a repair on MySQL which is what they asked me to
do...lol!