It works without reference. And taxonomy term name summary works with reference.

Drupal 6.12
PHP 5.2.6
MySQL 5.0.77
Server Apache/1.3.37 (Unix) PHP/5.2.6 mod_perl/1.30
Views 6.x-2.5

Query:

SELECT node_node_data_field_equip_models__term_node.tid AS node_node_data_field_equip_models__term_node_tid,
   node_node_data_field_equip_models__term_data.name AS node_node_data_field_equip_models__term_data_name,
   COUNT(node.nid) AS num_records
 FROM drupal_node node 
 LEFT JOIN drupal_content_field_equip_models node_data_field_equip_models ON node.vid = node_data_field_equip_models.vid
 LEFT JOIN drupal_node node_node_data_field_equip_models ON node_data_field_equip_models.field_equip_models_nid = node_node_data_field_equip_models.nid
 LEFT JOIN drupal_term_node node_node_data_field_equip_models__term_node ON node_node_data_field_equip_models.vid = node_node_data_field_equip_models__term_node.vid
 LEFT JOIN drupal_term_data node_node_data_field_equip_models__term_data ON node_node_data_field_equip_models.tid = node_node_data_field_equip_models__term_data.tid
 WHERE node.type in ('weblink')
 GROUP BY node_node_data_field_equip_models__term_data_name, node_node_data_field_equip_models__term_node_tid
  ORDER BY node_node_data_field_equip_models__term_data_name ASC

Error:

user warning: Unknown column 'node_node_data_field_equip_models.tid' in 'on clause' query: SELECT node_node_data_field_equip_models__term_node.tid AS node_node_data_field_equip_models__term_node_tid, node_node_data_field_equip_models__term_data.name AS node_node_data_field_equip_models__term_data_name, COUNT(node.nid) AS num_records FROM drupal_node node LEFT JOIN drupal_content_field_equip_models node_data_field_equip_models ON node.vid = node_data_field_equip_models.vid LEFT JOIN drupal_node node_node_data_field_equip_models ON node_data_field_equip_models.field_equip_models_nid = node_node_data_field_equip_models.nid LEFT JOIN drupal_term_node node_node_data_field_equip_models__term_node ON node_node_data_field_equip_models.vid = node_node_data_field_equip_models__term_node.vid LEFT JOIN drupal_term_data node_node_data_field_equip_models__term_data ON node_node_data_field_equip_models.tid = node_node_data_field_equip_models__term_data.tid WHERE node.type in ('weblink') GROUP BY node_node_data_field_equip_models__term_data_name, node_node_data_field_equip_models__term_node_tid ORDER BY node_node_data_field_equip_models__term_data_name ASC LIMIT 0, 10 in /bhome/part3/03/moinf/moinf.info/test/sites/all/modules/views/includes/view.inc on line 731.

View export:

$view = new view;
$view->name = 'test';
$view->description = 'Test';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->override_option('relationships', array(
  'field_equip_models_nid' => array(
    'label' => 'Модели',
    'required' => 0,
    'delta' => '-1',
    'id' => 'field_equip_models_nid',
    'table' => 'node_data_field_equip_models',
    'field' => 'field_equip_models_nid',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('fields', array(
  'nothing' => array(
    'label' => 'Custom text',
    'alter' => array(
      'text' => '',
      'make_link' => 0,
      'path' => '',
      'alt' => '',
      'prefix' => '',
      'suffix' => '',
      'help' => '',
      'trim' => 0,
      'max_length' => '',
      'word_boundary' => 1,
      'ellipsis' => 1,
      'strip_tags' => 0,
      'html' => 0,
    ),
    'exclude' => 0,
    'id' => 'nothing',
    'table' => 'views',
    'field' => 'nothing',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('arguments', array(
  'tid' => array(
    'default_action' => 'summary asc',
    'style_plugin' => 'unformatted_summary',
    'style_options' => array(
      'count' => 1,
      'override' => 0,
      'items_per_page' => '25',
      'inline' => 1,
      'separator' => '-',
    ),
    'wildcard' => 'all',
    'wildcard_substitution' => 'Все',
    'title' => '',
    'default_argument_type' => 'fixed',
    'default_argument' => '',
    'validate_type' => 'none',
    'validate_fail' => 'not found',
    'break_phrase' => 0,
    'add_table' => 0,
    'require_value' => 0,
    'reduce_duplicates' => 0,
    'set_breadcrumb' => 0,
    'id' => 'tid',
    'table' => 'term_node',
    'field' => 'tid',
    'validate_user_argument_type' => 'uid',
    'validate_user_roles' => array(
      '2' => 0,
      '3' => 0,
      '4' => 0,
    ),
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'field_equip_models_nid',
    'default_options_div_prefix' => '',
    'default_argument_user' => 0,
    'default_argument_fixed' => '',
    'default_argument_php' => '',
    'validate_argument_node_type' => array(
      'ad' => 0,
      'weblink' => 0,
      'adbuy' => 0,
      'adsell' => 0,
      'article' => 0,
      'equip' => 0,
      'event' => 0,
      'manuf' => 0,
      'news' => 0,
      'page' => 0,
      'retail' => 0,
      'story' => 0,
    ),
    'validate_argument_node_access' => 0,
    'validate_argument_nid_type' => 'nid',
    'validate_argument_vocabulary' => array(
      '3' => 0,
      '4' => 0,
      '1' => 0,
      '2' => 0,
    ),
    'validate_argument_type' => 'tid',
    'validate_argument_transform' => 0,
    'validate_user_restrict_roles' => 0,
    'validate_argument_php' => '',
  ),
));
$handler->override_option('filters', array(
  'type' => array(
    'operator' => 'in',
    'value' => array(
      'weblink' => 'weblink',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'type',
    'table' => 'node',
    'field' => 'type',
    'override' => array(
      'button' => 'Override',
    ),
    'relationship' => 'none',
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler = $view->new_display('page', 'Страница', 'page_1');
$handler->override_option('path', 'links2');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));

Comments

dawehner’s picture

Can you please try to reproduce this bug on the lateste views stable and latest cck? Its quite a old bug.

dpopov’s picture

Drupal 6.16
PHP 5.2.10
MySQL 5.0.87
Server Apache/1.3.37 (Unix) PHP/5.2.10 mod_perl/1.30
Views 6.x-2.8
CCK 6.x-2.6

It's better now - there is no error and result is not empty. But there are duplicates (same link – different titles), and I can not filter titles by vocabulary. And if option 'Do not display items with no value in summary' is checked there is error:

user warning: Unknown column 'node_node_data_field_equip_models.tid' in 'on clause' query: SELECT node_node_data_field_equip_models__term_node2.tid AS node_node_data_field_equip_models__term_node2_tid, node_node_data_field_equip_models__term_data2.name AS node_node_data_field_equip_models__term_data2_name, COUNT(DISTINCT(node.nid)) AS num_records FROM drupal_node node LEFT JOIN drupal_content_field_equip_models node_data_field_equip_models ON node.vid = node_data_field_equip_models.vid AND node_data_field_equip_models.delta = 0 INNER JOIN drupal_node node_node_data_field_equip_models ON node_data_field_equip_models.field_equip_models_nid = node_node_data_field_equip_models.nid LEFT JOIN drupal_term_node node_node_data_field_equip_models__term_node ON node_node_data_field_equip_models.vid = node_node_data_field_equip_models__term_node.vid LEFT JOIN drupal_term_node node_node_data_field_equip_models_node_node_data_field_equip_models__term_node ON node_node_data_field_equip_models.vid = node_node_data_field_equip_models_node_node_data_field_equip_models__term_node.vid LEFT JOIN drupal_term_data node_node_data_field_equip_models__term_data ON node_node_data_field_equip_models__term_node.tid = node_node_data_field_equip_models__term_data.tid INNER JOIN drupal_term_node node_node_data_field_equip_models__term_node2 ON node_node_data_field_equip_models.vid = node_node_data_field_equip_models__term_node2.vid LEFT JOIN drupal_term_data node_node_data_field_equip_models__term_data2 ON node_node_data_field_equip_models.tid = node_node_data_field_equip_models__term_data2.tid WHERE (node.type in ('weblink')) AND (node_node_data_field_equip_models__term_data.vid in ('2')) GROUP BY node_node_data_field_equip_models__term_data2_name ORDER BY node_node_data_field_equip_models__term_data2_name ASC in /bhome/part3/03/moinf/moinf.info/test/sites/all/modules/views/includes/view.inc on line 769.

esmerel’s picture

Status: Active » Closed (cannot reproduce)

no activity for 6 months