MySQL server has gone away

[paulman888888]

Hello there,

I've been having problems with this query and i can't understand why i am getting this MySQL server has gone away error. I managed to find out the line and where about in the script this is error is happening.

 

Here is the query that is used and causes the error

 

INSERT INTO stats_user (userid,name,friendcount,gender,likecount,picturecount,groupcount,wallcount,birthday, update_time) VALUES(100000325560036,"Paul Happy Hutchinson",325,"male",509,116,197,402,19920914, NOW());

 

Please can someone point me in the  right direction. I have never had this error before where a query is causeing the server to go away. I have done some more checking and i can comfirm that it is this query causeing the problem because i have used other querys in its place just to check its not a server or network issue.

 

Please please can you help me

Thank-you all

Paul Hutchinson

[gizmola]

You need to check the mysql error log for the server.  There are some things I find curious, like why your userid value is so large for this insert, as well as the format of the birthday column.  Just to begin with however, I would check the diskspace situation for the server, and make sure that the volume/partition etc. is not out of diskspace.  If this is innodb it could also be that the innodb tablespace is out of space.    These are all just guesses.