It works well to use Views Alpha Pager to my a Views page without arguments, but got the error message below when I use it to a view with arguments:

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 'DISTINCT(node.nid) = term_node.nid LEFT JOIN term_data term_data ON term_node.ti' at line 1 query: SELECT count(DISTINCT(term_data.name)) FROM node node LEFT JOIN term_node term_node ON DISTINCT(node.nid) = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN node_data_field_item_number node_data_field_item_number ON node.vid = node_data_field_item_number.vid LEFT JOIN node_data_field_latin_name node_data_field_latin_name ON node.vid = node_data_field_latin_name.vid WHERE left(trim(LEADING 'And ' FROM (trim(LEADING 'The ' FROM (trim(LEADING 'A ' FROM (trim(LEADING '\'' FROM (trim(LEADING '"' FROM (trim(LEADING ' ' FROM (upper(node.title))))))))))))), 1) = 'A' AND (node.status = '1') AND (term_node.tid IN ('35','36','37 in .../includes/database.mysql.inc on line 120.

Comments

douggreen’s picture

douggreen commented
Priority: Critical » Normal

It looks like the problem is related to the "distinct" filter and not views with arguments. Do you have "distinct" in your filter list? If so, can you try removing it and let me know if the SQL error goes away. Thanks!

astra’s picture

astra commented

I don't know how to remove "distinct" from my filter. Here is a exported code from the view page. Can you find a solution?

  $view = new stdClass();
  $view->name = 'herb_by_species';
  $view->description = 'View Chinese herbs by species.';
  $view->access = array (
  0 => '1',
  1 => '2',
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Chinese Herbs 草藥';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'view/herb/byspecies';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '1000';
  $view->menu = TRUE;
  $view->menu_title = 'by species (草藥種類)';
  $view->menu_tab = TRUE;
  $view->menu_tab_default = TRUE;
  $view->menu_tab_weight = '0';
  $view->sort = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'sortorder' => 'ASC',
      'options' => '',
    ),
  );
  $view->argument = array (
    array (
      'type' => 'taxletter',
      'argdefault' => '6',
      'title' => '%1',
      'options' => '',
      'wildcard' => '',
      'wildcard_substitution' => '',
    ),
  );
  $view->field = array (
    array (
      'tablename' => 'node_data_field_item_number',
      'field' => 'field_item_number_value',
      'label' => 'Nr.',
      'sortable' => '1',
      'options' => 'default',
    ),
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => 'Pinyin & Chinese Name',
      'handler' => 'views_handler_field_nodelink',
      'sortable' => '1',
      'defaultsort' => 'ASC',
      'options' => 'link',
    ),
    array (
      'tablename' => 'node_data_field_latin_name',
      'field' => 'field_latin_name_value',
      'label' => 'Latin Name',
      'sortable' => '1',
      'options' => 'default',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'term_node_4',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => '35',
  1 => '36',
  2 => '37',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(node, node_data_field_item_number, node_data_field_latin_name, term_node_4);
  $views[$view->name] = $view;
omerida’s picture

omerida commented

I had the same error, removing the distinct node did fix it.

douggreen’s picture

douggreen commented
Status: Active » Closed (won't fix)