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
Comment #1
dawehnerCan you please try to reproduce this bug on the lateste views stable and latest cck? Its quite a old bug.
Comment #2
dpopov commentedDrupal 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.Comment #3
esmerel commentedno activity for 6 months