sql problem after upgrade to 2.6

**robaldo** · 01-26-2008, 08:59 AM

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

**ilovelinux** · 01-26-2008, 09:12 AM

Have you tried repairing the database?

**robaldo** · 01-26-2008, 10:22 AM

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

**ilovelinux** · 01-27-2008, 09:01 AM

Hi again.

If you're interested, I can try helping you fix the problem. Pm me if interested. :)

**admin** · 02-05-2008, 09:08 AM

Code:

MySQL server has gone away

This is MySQL server problem.

**webjema** · 02-19-2008, 01:30 PM

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

**FurnTech** · 04-11-2008, 06:35 AM

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.

**grynmoors** · 04-11-2008, 10:44 AM

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