sql problem after upgrade to 2.6
Hallo,
yesterday I upgraded http://www.videomitici.com from 2.4 to 2.5 and then to 2.6. The host was always the same, but now after trying to upload a video I receive the error:
Code:
ERROR: Unable to execute query
SELECT * FROM `config` WHERE `config_name`='enable_flvtool'
MySQL server has gone away
Details of the host: http://www.videomitici.com/phpinfo.php
Thank you for help me in fix it
Re: sql problem after upgrade to 2.6
Have you tried repairing the database?
Re: sql problem after upgrade to 2.6
yes, the problem persists.
In admin I see the video, inactive and without lenght. I have to put the duration of the video and activate it. Strange
Re: sql problem after upgrade to 2.6
Hi again.
If you're interested, I can try helping you fix the problem. Pm me if interested. :)
Re: sql problem after upgrade to 2.6
Code:
MySQL server has gone away
This is MySQL server problem.
Re: sql problem after upgrade to 2.6
No, Admin.
It's NOT MySQL server problem.
It's happened when SCRIPT working more then "connection timeout" of MySQL configuration. It's SCRIPT PROBLEM
I have the same error, video present in admin area, but without length. And video doesn't playing.
I've described my problem here -> viewtopic.php?f=4&t=2425
Re: sql problem after upgrade to 2.6
Admin,
Our programmer says, "Holding the database connection open like that is a very bad idea. You should close the connection and write the data to an array while the video is processing and then insert the data in the array into the database."
This will solve the problem for those that are getting a "MySQL has gone away" error during conversion.
Re: sql problem after upgrade to 2.6
This probably goes back to the posts about "max-users" errors that some of us were getting and I asked about whether or not the connections were closing, so I'm thinking my hunch was correct? The connections are not closing? Notably this post: viewtopic.php?f=4&t=2167