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 WHERE (node.status = 1) AND (node.type in ('rotor_item')) ) ' at line 2 query: SELECT COUNT(*) FROM (SELECT DISTINCT FROM node node WHERE (node.status = 1) AND (node.type in ('rotor_item')) ) count_alias in E:\xampp\htdocs\drupal6veratest\modules\views\plugins\views_plugin_pager.inc on line 141.
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 WHERE (node.status = 1) AND (node.type in ('rotor_item')) L' at line 2 query: SELECT DISTINCT FROM node node WHERE (node.status = 1) AND (node.type in ('rotor_item')) LIMIT 0, 10 in E:\xampp\htdocs\drupal6veratest\modules\views\plugins\views_plugin_query_default.inc on line 1191.

why is this happening? I have all the latest modules installed
are you still working on this module, the latest dev is pretty old

Comments

webaccess’s picture

webaccess commented

Hi,

When I switch to using "row style: rotor to fields" user warnings are disappears.
Actually when query builds for "rotor" style, fields array is empty.
In the views/plugins/views_plugin_query_default.inc file following code was commented. if I uncomment that part then query for rotor row style builds properly.
//uncomment following part : we need this part to generate base fields.
if ($base_field) {
$this->fields[$base_field] = array(
'table' => $base_table,
'field' => $base_field,
'alias' => $base_field,
);
}

I hope it will help you!

kanika.sud’s picture

kanika.sud commented
Issue summary: View changes

Hi,

Useful information. It did help. But another problem appeared.
Only one rotor item is showing.