Using the latest dev, I now get the error as listed below.

Marking this as critical, because... it's not quite right yet!

Hoping to get this resolved - I have a situation where I have videos with different aspect ratios, for which the per-node player resolution would be awesome!

Unknown column 'vf.dimensions' in 'field list' query: SELECT f.*, vf.vid, vf.nid, vf.dimensions, vf.status as video_status FROM video_files vf LEFT JOIN files f ON vf.fid = f.fid WHERE f.fid=vf.fid AND f.fid = 68 in /[site_root]/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 420.

Also, in the video_conversion error logs I get a "Video object is not present" error.

Any ideas greatly appreciated and thanks for the good work..

Comments

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@bcobin,

We are changing the code to support multiple video conversion with video module. We completed it for Zencoder but not yet for the FFMPEG

bcobin’s picture

bcobin commented

Thanks for your response, heshan - I'll check back on this thread... keep up the good work!

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented
Status: Active » Fixed

Use the update.php to run updates.

bcobin’s picture

bcobin commented
Status: Fixed » Active

Use the update.php to run updates.

Sure - I always do - still no dice.

De-installing and re-installing the latest dev produces a host of errors:

Type video_transcoder
Date Tuesday, November 30, 2010 - 11:27
User admin
Location http://[site]/filefield/ahah/video/field_video/0
Referrer http://[site]/node/add/video
Message Error generating thumbnail for video: generated file sites/default/files/video_thumbs/94/video-thumb-for-94-1.jpg does not exist.
Command Executed:
-i 'sites/default/files/videos/[video].mov' -an -y -f mjpeg -ss -1 -vframes 1 sites/default/files/video_thumbs/94/video-thumb-for-94-1.jpg
Command Output:

And (not an error):

Type video_conversion
Date Tuesday, November 30, 2010 - 11:28
User admin
Location http://[site]/node/add/video
Referrer http://[site]/node/add/video
Message We could not determine the height and width of the video: sites/default/files/videos/[video].mov
Severity debug

And, finally:

Type filefield
Date Tuesday, November 30, 2010 - 11:28
User admin
Location http://[site]/node/add/video
Referrer http://[site]/node/add/video
Message FileField was trying to display the file sites/default/files/videos/[video].mov, but it does not exist.
Severity warning

I don't have qt-faststart installed on my development sandbox, so I must convert to FLV, but I know that FFMPEG is working fine insofar as I have BD Video working fine.

Reopening this insofar as it's certainly not fixed - at least for me. I'm dead in the water here... but will keep checking for updates!

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@bcobin if you install it as fresh, can you send me the table structure you have, did u checkout latest from the CVS?

Hope the database issue is gone off now. To convert videos please check the transcoder settings and the video preset settings. Hope this helps and keep posting.

bcobin’s picture

bcobin commented

@bcobin if you install it as fresh, can you send me the table structure you have, did u checkout latest from the CVS?

I've done a fresh install of the 12/1 dev version (is that what you mean by "latest from CVS?") and thumbnails work great, but the video fails to be transcoded.

Nothing happens on save except to get the "You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly." message.

I then run cron and nothing happens. Here's the log error:

video_conversion
Date Wednesday, December 1, 2010 - 15:44
User admin
Location http://[site]/cron.php
Referrer
Message Cound not move the video to the original folder.
Severity error

(Note the misspelling on "Cound" - oops!)

The file is actually moved to the "original" folder, though. And there we sit.

I am using SWF Tools to play the video and have the players installed according to SWF Tools; I'm using JW media Player 4 for single FLV movies. I've tried with no Video presets checked, one preset and all presets checked - it's the same thing: no transcoding.

video_files is the only relevant table I see.

Hope this helps - seems like we may be getting closer?

virtuali1151’s picture

virtuali1151 commented

I am getting the same error on the latest alpha version.

•user warning: Unknown column 'vf.dimensions' in 'field list' query: SELECT f.*, vf.vid, vf.nid, vf.dimensions, vf.status as video_status FROM video_files vf LEFT JOIN files f ON vf.fid = f.fid WHERE f.fid=vf.fid AND f.fid = 351 in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 415.
•warning: Invalid argument supplied for foreach() in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 443.

Any assistance is greatly appreciated.

Cheers.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented
Status: Active » Fixed

@virtuali1151 fixed.

bcobin’s picture

bcobin commented

Making some progress over here - I had to manually change the FFMPEG command to get it to work in hq_flash.inc.

Here's the updated command from line 69 of hq_flash.inc:

'/usr/local/bin/ffmpeg -i !videofile -s !widthx!height -r 24 -b 640k -ar 44100 -ab 128k !convertfile'

I copied settings that had been working for me for BD video, but the real important thing here is that I needed to manually specify the path to FFMPEG (bolded here) - this should not be.

Thumbnails are being generated, but the loaded (ready) screen is just blank white with the play indicator in the center.

Not soup yet, but a lot closer.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented
Status: Fixed » Active

@bcobin, please check the latest ALPHA2 release.

bcobin’s picture

bcobin commented
Status: Active » Fixed

Yes - latest alpha release is fine! There's an issue with thumbnails with JW Player 4 and JW Player 3 doesn't seem to work at all (Flowplayer is OK with thumbnails, but the size is wrong), but I'll open up a separate issue for these and close this.

Nice job!

virtuali1151’s picture

virtuali1151 commented

Checking out Alpha 2... Will post results shortly..

Cheers.

virtuali1151’s picture

virtuali1151 commented

Hmm.. I am still getting this error on current videos... Does this just work for new videos..?? or is there something I am missing..

•user warning: Unknown column 'vf.dimensions' in 'field list' query: SELECT f.*, vf.vid, vf.nid, vf.dimensions, vf.status as video_status FROM video_files vf LEFT JOIN files f ON vf.fid = f.fid WHERE f.fid=vf.fid AND f.fid = 459 in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 416.
•warning: Invalid argument supplied for foreach() in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 444.

Tks.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@virtuali1151 did u upgrade the module? or is this a fresh install?

greywolfsspirit’s picture

greywolfsspirit commented

I've also got the same error on alpha 2, did upgrade..

I see no upgrades or patch notices when I run update.php showing any changes going on in the database though. But when I check the modules, it is the 6.4 alpha 2 version, but still get the error message periodically, even if I'm not even using the module at the time.

If I pull up system status, it pops up..

Hope this helps narrow down some areas as to what is going on.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@greywolfsspirit, there is an update video_update_6407, please run the update script and select this update tag to make effect.

greywolfsspirit’s picture

greywolfsspirit commented

Tried that and got errors of duplicate entries.. I uninstalled the video module completely and reinstalled.. will see if this fixes my situation.

virtuali1151’s picture

virtuali1151 commented

@heshan.lk - I have done both.... I did the upgrade first... which it updated my tables etc... and I got the errors.. then I did a total uninstall... removed all 3 db tables etc.... and I am still getting the errors.. I tired to run the 6407 script and it said it could drop the tables. This is what I am still getting.

•user warning: Unknown column 'vf.dimensions' in 'field list' query: SELECT f.*, vf.vid, vf.nid, vf.dimensions, vf.status as video_status FROM video_files vf LEFT JOIN files f ON vf.fid = f.fid WHERE f.fid=vf.fid AND f.fid = 351 in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 416.
•warning: Invalid argument supplied for foreach() in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 444.

Any updates are appreciated.

Cheers.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@virtuali1151 download the ALPHA2 version and run the update script.

greywolfsspirit’s picture

greywolfsspirit commented

I found that by uninstalling the video module totally, along with video upload and video ftp and then reinstalling them seem to have (for now) corrected this for me. I haven't seen it creep back up all day. Running the update 6407 did not work previously which led me to this attempt.

virtuali1151’s picture

virtuali1151 commented

Ok, I have downloaded alpha2 (and did an uninstall etc etc) and I am still getting the below error... which is one less than before...
warning: Invalid argument supplied for foreach() in /home/site/public_html/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 444.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@virtuali1151 there is no any direct way to upgrade form the older version on the module to ALPHA1 or ALPHA2, I clearly mentioned it on the release note.

I'm preparing a upgrade script for the module from a older 4.x version, there is a change on the database and if you upgrade u might loose all existing videos.

virtuali1151’s picture

virtuali1151 commented

Hi Heshan,

Thats ok.. I have it all backend up anyways... I have been able to restore it... What I might do is start over anyways and see how it goes with new vids... I will keep you guys posted.

Thanks for all your help.

Cheers.

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented

@virtuali1151 easiest thing is set up all configurations of the video module properly, then upload a test video and check how its working.

Then go to video_files (if your in FFMPEG) or video_zencoder (if your in Zencoder) and update all entries status to 1, then all videos will convert again with new presets.

In that case you can have HTML5 support and HQ video support in one shot and all the new features will apply to the old videos.

virtuali1151’s picture

virtuali1151 commented

Hi All,

I am still getting a few errors... I am just gonna revert back to the old version for now til a more stable version is avail.

Tks.

virtuali1151’s picture

virtuali1151 commented

Does anybody no why I would get the below errors:

FileField was trying to display the file sites/default/files/videos/uploads/1/videos/original/test.wmv, but it does not exist.
FileField was trying to display the file sites/default/files/video_thumbs/506/video-thumb-for-506-2.jpg, but it does not exist.

It seems the directory setup isnt correct..??

This is using the alpha2 version on a clean install.

Any assistance is great tks.

virtuali1151’s picture

virtuali1151 commented

Got it figured out... content type had incorrect path.

Tks

Status: Fixed » Closed (fixed)

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