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

js’s picture

Title: sql error when setting "row style: rotor" » image path appears to be missing

Hi 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:

Only local images are allowed.

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

brack11’s picture

I 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

brack11’s picture

Priority: Normal » Critical
youngmorse’s picture

Hi,

I just installed the rotor module and am getting the same exact error listed in the original post.

Thanks!

brack11’s picture

I used "Views Slideshow" instead, it is way more flexible and reliable

summit’s picture

Subscribing, greetings, Martijn

mrfelton’s picture

Title: image path appears to be missing » Rotor image path appears to be missing (views 3 incompatability)
dietman’s picture

so can't we use the module? Do we have to wait for patch? Did anybody fix this?

mrfelton’s picture

Hi, 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

dietman’s picture

Well the previous version of rotor works fine, you are saying that views slideshow can do the same thing, insert link in the picture?

mrfelton’s picture

@dietman: the previous version of rotor works fine with Views 3? Which version of Rotor are you referring to?

dietman’s picture

@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.

ccoppen’s picture

Just 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');

jmary’s picture

About #13

Where the field Image:image is coming from ? I don't have it.

This is left just broken for views 3.

jmary’s picture

#13 is assuming that module imagefield is installed.

Once this is done it will work as explained at #13.

niek_kloots’s picture

Views 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.

ailgm’s picture

subscribe

niek_kloots’s picture

edit 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:

<p><img alt="" src="mysite.com/picture.jpg" /><br/>
<a href="http://othersite.com" target="_blank">http://othersite.com</a></p>

instead of:
<p><a href="http://othersite.com" target="_blank"><img alt="" src="mysite.com/picture.jpg" /></a></p>

niek_kloots’s picture

Since 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?

mrfelton’s picture

@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.