Files processed correctly but not attached to the node

I was able to process normally when I downgraded to beta4

I confirm the bug.

Some tests:

Uploading a 17M mpg video:
- It create: 17M flv, 3K jpg.
- It attach the 17M mpg, 3k jpg, but NO the flv

Uploading a 17M flv video also fails.
- It create: 3K jpg.
- It attach the 3k jpg, but NO the flv, even it was uploaded OK (it's in "files" folder)

Uploading a 5M mpg video:
- It create: 5M flv, 3K jpg.
- It attach the 5M mpg, 3k jpg, AND the flv (I can see the video!)

should be fixed in version 1.4.rc1

Automatically closed -- issue fixed for two weeks with no activity.

I still have this issue with the latest release. Using on a fresh drupal install, just flashvideo installed. I've done testing with all sorts of videos, all with the same outcome. The video is attached, converted, thumbnailed - but fails with SQL errors. Editing the node after reveals the location of the original file and the thumbnail, but the converted FLV is not attached - though visible on the server. Everything works as it should, but the flv is not attached to the node.

This is happenning with the latest release...

I wonder if it's an issue of flashvideo or my hosting server (cirtex)... every video that I upload gets converted successfully (I've tried with videos of different sizes). The very small ones ( < 3MB ) get converted and attached to nodes successfully... but large videos ( I've tried with 40MB ) get converted, thumbnail generated (the files exist on the output directory), but not attached to the node.

I've checked the ffmpeg_data table and no record is stored about this conversion.
The files table shows only the original .avi and the generated .jpg but not the converted .flv... and in my cck field tables, the converted videos are not showing.

I've checked MIME types and stuff, and everything is correct.

How can I fix this? is it a bug? or a MySQL setting or what can it be?

Thanks

Bumping this thread, we are having the exact same issue on our servers, incredibly frustrating.

Only occurs on files larger than about 16MB or so... just like #2. Thumbnail attaches fine, just not the .flv

Does anyone have any ideas? We've got a couple of clients that are getting quite irate :(

Someone mentioned that there are MySQL errors associated with this. Can anyone post what those are?

Also, is this only happening with Cirtex hosting or on other hosts as well?

I believe the mysql setting is the issue. I was experiemening with this on my dedicated server, when I set the connection time out to 10 second, sometime cron will say "MYSQL server have gone away" with the SQL query that are unable to insert. At that point, I reviewed the flashvideo, node, files, and upload tables to add the field manually. I found that on all the occasion, only the FLV file are not attached in the database. The jpg and original files are hooked to the node properly.

That happens when I runs cron in ssh with video bigger then 40~ megs.

However, once I increase the time to connection time out in mysql server to 100 second, the problem go away even for videos with the size over 100~ megs.

Of course, this doesn't help people with shared hosting since it is unlikely they can change the mysql server configuration. But from my observation, it lies with the way Flashvideo module use Cron. Are we using the same database connection to attach the flv files with something else? The time gap in between can possibly cause this issue.

I agree. After much testing and research with a similar problem on my own site, it appears to be related to database connection timing out when the file size exceeds a certain amount.

I talked with my host (Site5) and found that the mysql wait_timeout setting was at 15 (which is very low, 15 seconds) and cannot be changed for shared or reseller hosting.

Not 100% sure this is the culprit, but it's the best theory.

Best,
Shane

No further discussion after a month. Marking issue as closed.