Instanciating the views style plugin produces he following error for block and page; view works fine when previewed on presets page. So it looks like a problem with the style plugin. I'm using Views 3.x-dev. Same error with both rc5 and current dev.
Looks like a terrific module - thank you!
warning: Invalid argument supplied for foreach() in [root]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 921.
warning: Invalid argument supplied for foreach() in [root]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 997.
warning: Invalid argument supplied for foreach() in [root]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 921.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid WHE' at line 2 query: SELECT FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid WHERE (node.type in ('media')) AND (node.status = 1) AND (term_node.tid = 61) in [root]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1147.
Comments
Comment #1
bcobin commentedFurther clarification: I'm trying to generate a "carousel" type instructional video here, with different steps illustrated by different videos, using taxonomy to select the videos that will be shown. I've tried different combinations of field and style plug-in settings; all result in either incorrect data being displayed or the error above.
The view works brilliantly when I use it to test the preset and I do see in #3 here - http://drupal.org/node/1057292 - that the output needs to be unformatted in D7 to work. So it looks like something's not right in the way the current D6 version is working with Views.
But using single nodes, let me say here that this module is phenomenal! Using Media Mover and FFMPEG, I'm finally able to generate multiple file types for each video which will play cross-platform with a single file upload of any kind. I've been trying to get this functionality for months! Thank you for your sensational work here... yowsa!
Comment #2
bcobin commentedChanging the version to dev - problem still persists in 2/25 build. This is using the Media Player style plugin. I have resaved the preset, cleared all caches, etc.
* warning: Invalid argument supplied for foreach() in [site]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 920.
* warning: Invalid argument supplied for foreach() in [site]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 996.
* warning: Invalid argument supplied for foreach() in [site]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 920.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid WHE' at line 2 query: SELECT FROM node node INNER JOIN term_node term_node ON node.vid = term_node.vid WHERE (node.type in ('media')) AND (node.status = 1) AND (term_node.tid = 61) in [site]/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1146.
Additionally, for anonymous users, I'm getting the following error before the error listed above:
warning: array_fill() [function.array-fill]: Number of elements must be positive in [site]/includes/database.inc on line 253.
warning: implode() [function.implode]: Invalid arguments passed in [site]/includes/database.inc on line 253.
warning: array_keys() [function.array-keys]: The first argument should be an array in [site]/modules/user/user.module on line 515.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT p.perm FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /[site]/modules/user/user.module on line 515.
Hope this helps!
Comment #3
travist commentedWill you export your mediafront preset and the view you are using, and paste them into a comment so that I can reproduce?
Comment #4
bcobin commentedWith pleasure! Thanks, Travis!
Here's the "player" preset or use with "playlist" nodes:
$preset = array (
'name' => 'player',
'description' => 'Default OSM Player',
'player' => 'osmplayer',
'connect' => array (
'iscontroller' => array (
),
'isplaylist' => array (
),
),
'settings' => array (
'logo' => 'scdc_square_logo.png',
'link' => '[site]',
'logoWidth' => 55,
'logoHeight' => 37,
'playlist' => 'media_imagecast',
'vertical' => false,
'debug' => true,
'height' => 600,
'theme' => 'smoothness',
),
);
And here's the view:
$view = new view;
$view->name = 'media_imagecast';
$view->description = '';
$view->tag = '';
$view->base_table = 'node';
$view->human_name = 'Media - ImageCast Voting';
$view->core = 6;
$view->api_version = '3.0-alpha1';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'none';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 0;
/* Field: Content: Media player (field_media_player) */
$handler->display->display_options['fields']['field_media_player_params']['id'] = 'field_media_player_params';
$handler->display->display_options['fields']['field_media_player_params']['table'] = 'node_data_field_media_player';
$handler->display->display_options['fields']['field_media_player_params']['field'] = 'field_media_player_params';
$handler->display->display_options['fields']['field_media_player_params']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_media_player_params']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_media_player_params']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_media_player_params']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_media_player_params']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['link_to_node'] = 0;
$handler->display->display_options['fields']['field_media_player_params']['label_type'] = 'none';
$handler->display->display_options['fields']['field_media_player_params']['format'] = 'player_player';
/* Filter: Node: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'media' => 'media',
);
/* Filter: Node: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
/* Filter: Taxonomy: Term */
$handler->display->display_options['filters']['tid']['id'] = 'tid';
$handler->display->display_options['filters']['tid']['table'] = 'term_node';
$handler->display->display_options['filters']['tid']['field'] = 'tid';
$handler->display->display_options['filters']['tid']['value'] = array(
61 => '61',
);
$handler->display->display_options['filters']['tid']['reduce_duplicates'] = 0;
$handler->display->display_options['filters']['tid']['type'] = 'select';
$handler->display->display_options['filters']['tid']['vid'] = '2';
/* Display: Imagecast video */
$handler = $view->new_display('block', 'Imagecast video', 'block_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'The ImageCast Voting System';
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 0;
/* Field: Content: Upload image (field_upload_image) */
$handler->display->display_options['fields']['field_upload_image_fid']['id'] = 'field_upload_image_fid';
$handler->display->display_options['fields']['field_upload_image_fid']['table'] = 'node_data_field_upload_image';
$handler->display->display_options['fields']['field_upload_image_fid']['field'] = 'field_upload_image_fid';
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_upload_image_fid']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_upload_image_fid']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['link_to_node'] = 0;
$handler->display->display_options['fields']['field_upload_image_fid']['label_type'] = 'none';
$handler->display->display_options['fields']['field_upload_image_fid']['format'] = 'scale_and_crop_120x90_default';
/* Field: Content: Upload media (field_upload_media) */
$handler->display->display_options['fields']['field_upload_media_fid']['id'] = 'field_upload_media_fid';
$handler->display->display_options['fields']['field_upload_media_fid']['table'] = 'node_data_field_upload_media';
$handler->display->display_options['fields']['field_upload_media_fid']['field'] = 'field_upload_media_fid';
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_upload_media_fid']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_upload_media_fid']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['link_to_node'] = 0;
$handler->display->display_options['fields']['field_upload_media_fid']['label_type'] = 'none';
/* Field: Content: Media player (field_media_player) */
$handler->display->display_options['fields']['field_media_player_params']['id'] = 'field_media_player_params';
$handler->display->display_options['fields']['field_media_player_params']['table'] = 'node_data_field_media_player';
$handler->display->display_options['fields']['field_media_player_params']['field'] = 'field_media_player_params';
/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'mediaplayer';
$handler->display->display_options['style_options']['mediafront_preset'] = 'player';
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Node: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = 1;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 0;
$handler->display->display_options['path'] = 'imagecast';
$translatables['media_imagecast'] = array(
t('Defaults'),
t('more'),
t('Apply'),
t('Reset'),
t('Sort By'),
t('Asc'),
t('Desc'),
t('Imagecast video'),
t('The ImageCast Voting System'),
t('Page'),
);
Comment #5
travist commentedThis is what is causing the issue, but I have fixed it on the Views side. Hopefully they take my patch for views 3x.
http://drupal.org/node/857946#comment-4157678
Comment #6
bcobin commentedYes indeed - looks like you nailed it! Do advise if you hear back from the Views crew as to whether this will be incorporated so we can keep updated - nicely done!
Comment #7
travist commentedI figured out a way to fix this without a views patch. Just committed it in the latest DEV version. But it would still be good if the views patch makes it in, but now it isn't required.