Hi, thank you for your effort with this module. I would like to be able to use it.
The default view (block) generates this error. Also, when creating a new view, when toggling "row style: rotor".
I am using
Views 6.x-3.0-alpha2
* warning: Invalid argument supplied for foreach() in ../sites/default/modules/views/plugins/views_plugin_query_default.inc on line 879.
* warning: Invalid argument supplied for foreach() in ../sites/default/modules/views/plugins/views_plugin_query_default.inc on line 955.
* warning: Invalid argument supplied for foreach() in ../sites/default/modules/views/plugins/views_plugin_query_default.inc on line 879.
* 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 drupal_node node WHERE (node.status <> 0) AND (node.type in ('rotor_item'' at line 2 query: SELECT COUNT(*) FROM (SELECT FROM drupal_node node WHERE (node.status <> 0) AND (node.type in ('rotor_item')) ) count_alias in ../sites/default/modules/views/plugins/views_plugin_pager.inc on line 134.
* 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 drupal_node node WHERE (node.status <> 0) AND (node.type in ('rotor_item'' at line 2 query: SELECT FROM drupal_node node WHERE (node.status <> 0) AND (node.type in ('rotor_item')) LIMIT 0, 10 in ../sites/default/modules/views/plugins/views_plugin_query_default.inc on line 1093.
Thanks, Jerry
Comments
Comment #1
js commentedHi again,
When I switch to using "row style: fields"
and add field
Content: Rotor Item image Rotor Item image, the image path is not included:
Rotor Item image:
But the images are correct when viewing/editing the rotor node.
SELECT rotor_item.url AS rotor_item_url,
rotor_item.nid AS rotor_item_nid
FROM drupal_node node
LEFT JOIN drupal_rotor_item rotor_item ON node.nid = rotor_item.nid
WHERE (node.status <> 0) AND (node.type in ('rotor_item'))
I hope this helps.
Thanks, Jerry
Comment #2
brack11 commentedI have the same issue with the same warnings, are there any solutions for it yet?
I can add that I dont see image, when I click "preview" it brings me to the front page (?) But I see the uploaded image while editing the rotor content
Comment #3
brack11 commentedComment #4
youngmorse commentedHi,
I just installed the rotor module and am getting the same exact error listed in the original post.
Thanks!
Comment #5
brack11 commentedI used "Views Slideshow" instead, it is way more flexible and reliable
Comment #6
summit commentedSubscribing, greetings, Martijn
Comment #7
mrfelton commentedMarking #705440: views 3 incompatability with Rotor module as a duplicate
Comment #8
dietman commentedso can't we use the module? Do we have to wait for patch? Did anybody fix this?
Comment #9
mrfelton commentedHi, Sorry but I have I will not be updating this to work with Views 3 until it hits beta at least. I will happily review and commit patches though.
Tom
Comment #10
dietman commentedWell the previous version of rotor works fine, you are saying that views slideshow can do the same thing, insert link in the picture?
Comment #11
mrfelton commented@dietman: the previous version of rotor works fine with Views 3? Which version of Rotor are you referring to?
Comment #12
dietman commented@felton
well sorry, I have 2,3 rotor version and views 2.7, I forgot to update the views.
So I am not sure if this will work. For now I will not update, because I like the rotor module.
Comment #13
ccoppen commentedJust a note that you have to go into your view and change the Row style to Fields. Then you have to add the Content:Rotor Item Field to the fields area.
I'm still having issues with it displaying, but my errors went away.
Update: Let the weirdness commence. I had to add Image: image to the fields as well.
Here's my export for those that this issue might help. Where I'm using it: http://www.3rbc.com. The picture of the church is the rotor block. Only 1 for now.
$view = new view;
$view->name = 'rotor';
$view->description = 'Default view for the Botor Banner module - A block that rotates through all Rotor Items';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$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['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'] = 'rotor';
$handler->display->display_options['style_options']['speed'] = '2';
$handler->display->display_options['style_options']['pause'] = 1;
$handler->display->display_options['style_options']['tabs'] = array(
'show_tabs' => 0,
'group_tabs' => '',
'position' => '0',
);
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 0;
/* Field: Image: Image */
$handler->display->display_options['fields']['image_image']['id'] = 'image_image';
$handler->display->display_options['fields']['image_image']['table'] = 'node';
$handler->display->display_options['fields']['image_image']['field'] = 'image_image';
$handler->display->display_options['fields']['image_image']['label'] = '';
$handler->display->display_options['fields']['image_image']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['trim'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['image_image']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['image_image']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['image_image']['alter']['html'] = 0;
$handler->display->display_options['fields']['image_image']['hide_empty'] = 0;
$handler->display->display_options['fields']['image_image']['empty_zero'] = 0;
$handler->display->display_options['fields']['image_image']['link_to_node'] = 0;
$handler->display->display_options['fields']['image_image']['image_derivative'] = '_original';
/* Field: Content: Rotor Item image */
$handler->display->display_options['fields']['rotor_item_image']['id'] = 'rotor_item_image';
$handler->display->display_options['fields']['rotor_item_image']['table'] = 'rotor_item';
$handler->display->display_options['fields']['rotor_item_image']['field'] = 'rotor_item_image';
$handler->display->display_options['fields']['rotor_item_image']['label'] = '';
$handler->display->display_options['fields']['rotor_item_image']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['alter']['trim'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['rotor_item_image']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['rotor_item_image']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['alter']['html'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['hide_empty'] = 0;
$handler->display->display_options['fields']['rotor_item_image']['empty_zero'] = 0;
/* 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;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* 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(
'rotor_item' => 'rotor_item',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Display: Block */
$handler = $view->new_display('block', 'Block', 'block_1');
Comment #14
jmary commentedAbout #13
Where the field Image:image is coming from ? I don't have it.
This is left just broken for views 3.
Comment #15
jmary commented#13 is assuming that module imagefield is installed.
Once this is done it will work as explained at #13.
Comment #16
niek_kloots commentedViews is past the beta stage and is in views 6.x-3.0-rc3 now.
views 6.x-3.0-rc1 since November 2, 2011
Please make Rotor working with views 3, I need them both.
edit:
#13 works for me.
Comment #17
ailgm commentedsubscribe
Comment #18
niek_kloots commentededit on my post #16
I can make the rotor work like I wrote in #16
Only the link if you click on a picture in a rotor block won't work. The picture can't be clicked as link because there is no link.
The only place I get a link working is under the picture.
What I get in a block is:
instead of:
<p><a href="http://othersite.com" target="_blank"><img alt="" src="mysite.com/picture.jpg" /></a></p>Comment #19
niek_kloots commentedSince January 4, 2012 views has a full 3.0 release.
@mrfelton What does it take for you to keep your promise of #9 Posted on April 28, 2010 at 7:14am?
Comment #20
mrfelton commented@Niek_Kloots It will take someone else to step up and do it. I have no use for this module in Drupal 7 or beyond, and will not be maintaining it save for security updates. If someone wants to become co-maintainer, please let me know and I'll grant you the access ou need.