Posted by k3vin on June 25, 2008 at 5:55pm
Jump to:
| Project: | OpenPackage Video |
| Version: | 5.x-3.11 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | jbrown |
| Status: | closed (won't fix) |
Issue Summary
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
#1
#2
I have reproduced this. I think there is a bug in Views.
#3
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?
#4
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.#5