MySQL server has gone away

[cruise]

After installing Vshare thinking it was going to work i keep getting the following error when the cron is run,

ERROR: Unable to execute query

SELECT * from `process_queue` WHERE status=2

MySQL server has gone away

ive tried the fix vshare_2.4_fix_20070827 however this hasnt made any diffrence at all.

[RyanC]

I am having the same problem

ERROR: Unable to execute query

INSERT INTO `process_queue` SET
		file='Default.wmv',
		title ='test',
		description='tersts',
		keywords='test',
		channels='1',
		type='public',
		user='vshare',
		user_ip='66.XX.X.XX',
		status=2

MySQL server has gone away

I am not getting this error with a cron job, but when I try to upload a video.

[admin]

MySQL server has gone away

This error is due to MySQL server down. Do a google search on "MySQL server has gone away" you will get reason for this error. It is a server problem.

[admin]

I am having the same problem

ERROR: Unable to execute query

INSERT INTO `process_queue` SET
		file='Default.wmv',
		title ='test',
		description='tersts',
		keywords='test',
		channels='1',
		type='public',
		user='vshare',
		user_ip='66.XX.X.XX',
		status=2

MySQL server has gone away

I am not getting this error with a cron job, but when I try to upload a video.

Can you check if table - process_queue is created in your phpMyAdmin ?

This is upgrade or fresh install ?

What is site url ?

[RyanC]

Ok thanks I e-mailed my server management team.

[RyanC]

It is a fresh install..

[RyanC]

[RyanC]

I found this on the MySQL Dev site which I think may be the problem?

"You can also get these errors if you send a query to the server that is incorrect or too large. If mysql receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section B.1.2.9, “Packet too large”."

[RyanC]

Here is the packsize, don't know if that helps.

[RyanC]

I just tried to upload a video that was 6.57mb which is below 10mb and it did the samething. I just had my server admin team upgrade my mysql and then I realized that I could upload videos anymore so I had them downgrade it back to what it was. Did a fresh install of the script and got the error above. They also upgraded my apache as well, I had them reverse all of that. So that is where I think the problems are coming from.