Unable to execute query ....MySQL server has gone away

[hostonnet]

Ask web host to increase the timeout values.

MySQL :: MySQL 5.0 Reference Manual :: B.5.2.9 MySQL server has gone away

[amilcar]

thank you for you support.

As my host don't offer custom php.ini, if i make a modification in htaccess with php_value or php_admin_value, i found an internal error 500.

So, i changed $sql = "UPDATE `process_queue` SET
status='2' , file ='$file_name' WHERE `id`=$vid";
mysql_query($sql) or mysql_die($sql);

to the line 91 of functions_upload.php

and now it works perfectly.

Thanks

[cybra]

My timeout has been increased to 30 minutes, and I still get the same error. Database has gone away.

[vshare2]

Hi,

Open a support ticket at

BuyScripts Helpdesk

with your vshare admin and FTP login details.

Thanks,

Buyscripts Team

[bplex]

My timeout has been increased to 30 minutes, and I still get the same error. Database has gone away.

How big are the videos that you are uploading? When vShare starts the conversion process, it establishes a connection to mySQL. When the process finishes, it attempts to update mySQL with the information for the videos. If the time between the start and finish is greater than 30 minutes, then you would still get the Database has gone away error. With a timeout of 30 minutes, it sounds as though either what you are uploading and converting is very big, or your server is taking an unusually long time to convert.

[cybra]

The biggest file was about 15 minutes long. But it times out on videos as short as 7 minutes. The entire process goes for about 4-5 minutes before it times out. The average 4-5 minutes videos convert fine with no problem.

My host ensured me that they increased it but I have now way of knowing for sure. I am just taking their word for it.

(from my server)
Hello,

we have increased the timeout limit to 1800 now. Please check and let us know if you need any other assistance.

Thanks!

[bplex]

Ask them which timeout limit they actually changed and if they restarted mySQL after the change. By default, BTW, the limit is set to 8 hours. They are telling you that it is set to 30 minutes, but if it is timing out before 30 minutes, it is obviously not set to 30 minutes.

[cybra]

I asked them to increase the MySQL server timeout and I actually restarted the server myself. So you said by default the limit is set to 8 hours. That would mean they actually would have decreased the limit to 30 minutes? Should I ask them then to set the limit to 8 hours?