I try to use the the filter option 'Video transcoded' to show only transcoded videos for Full Nodes View Type and get this error message:

* user warning: Unknown column 'field_video_op_videos.flv_file_id' in 'where clause' query: SELECT count( DISTINCT(node.nid)) FROM node node WHERE (node.status = '1') AND (node.type IN ('video_band_contest')) AND (field_video_op_videos.flv_file_id IS NOT NULL) in /var/www/virtual/htdocs/includes/database.mysql.inc on line 172.

The same error i get for 'Teaser List'. In 'List View' the filter option'Video transcoded' is working fine.

Comments

k3vin’s picture

k3vin commented
Category: feature » support
jbrown’s picture

jbrown commented
Assigned: Unassigned » jbrown
Category: support » bug

I have reproduced this. I think there is a bug in Views.

Grantovich’s picture

Grantovich commented
Version: 5.x-3.10 » 5.x-3.11

Just to give it a bump, I'm having the same problem using the "Video transcoded" filter in a Teaser List view, in this case attempting to show videos that are not transcoded. The exact error is:

user warning: Unknown column 'field_video_op_videos.flv_file_id' in 'where clause' query: SELECT node.nid, node.created AS node_created_created FROM node node WHERE (node.type IN ('video')) AND (field_video_op_videos.flv_file_id IS NULL) AND (node.uid = 1) ORDER BY node_created_created DESC LIMIT 0, 999 in /Library/WebServer/Documents/includes/database.mysql.inc on line 172.

Is this definitely a Views bug? If so, is there a corresponding entry on the Views issue tracker?

alippai’s picture

alippai commented

Similar problem, when retranscoding videos:

user warning: Unknown column 'para2_content_type_opvideo.field_opvideo_video_id' in 'on clause' query: SELECT para2_op_videos.video_id FROM para2_op_videos INNER JOIN para2_content_type_opvideo ON para2_op_videos.video_id = para2_content_type_opvideo.field_opvideo_video_id INNER JOIN para2_op_video_files ON para2_op_videos.source_file_id = para2_op_video_files.file_id WHERE para2_op_video_files.deleted = 0 in /home/****/www/****/includes/database.mysqli.inc on line 154.
jbrown’s picture

jbrown commented
Status: Active » Closed (won't fix)