The module seems to be looking for the original video in files/videos when it's actually in the files/videos/original folder after upload. It then reports the video as being successfully converted, when it's not. Copying the file to the files/videos folder (for testing purposes) also fails, but this may be another issue - just dealing with the filefield error here. Hope this helps!

Errors:

Unknown column 'filepath' in 'field list' query: SELECT filepath FROM video_files WHERE fid=70 in /[site_root]/sites/all/modules/video/transcoders/video_ffmpeg.inc on line 408.

FileField was trying to display the file sites/default/files/videos/[video].mov, but it does not exist.

Comments

jm.federico’s picture

jm.federico commented
Title: Filefield location error » Bad SQL query: SELECT filepath FROM {video_files} WHERE fid=%d

Seems to me the error you are reporting is related to a probelm with the SQL query.

The table 'video_files' does not have a column 'filepath', which gives you the error you are seeing.
I'm changing title to reflect this.

I'm guessing there must be a JOIN there to get the filepath, something like:

SELECT files.filepath FROM {video_files} LEFT JOIN {files} ON video_files.fid = files.fid WHERE video_files.fid=%d

hypertext200’s picture

hypertext200
he/him
Primary language Singhalese
Location New York City
commented
Status: Active » Closed (duplicate)

duplicate of #989258: Video files aren't deleted either when removed from node nor on node delete.