Views support: when sorting by role weights a node appears three times.

Posted by Bèr Kessels on May 17, 2006 at 3:21pm

Issue Summary

Something is broken in the role wights table. when sorting by role weights a node appears three times. This ususally indicates the $table returns something erronous. Resulting in a strange JOIN query built by views module.

Comments

#1

Posted by leafish_paul on May 17, 2006 at 7:40pm

Can you provide your view? I can't reproduce this here.

#2

Posted by Bèr Kessels on May 18, 2006 at 1:31pm

http://incubator.beauty-coach.nl/vacatures/alle

  $view = new stdClass();
  $view->name = 'Vacatures';
  $view->description = 'Vacatures';
  $view->access = array (
);
  $view->page = TRUE;
  $view->page_title = 'Vacatures';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_type = 'teaser';
  $view->url = 'vacatures/alle';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->block = TRUE;
  $view->block_title = '';
  $view->block_header = '';
  $view->block_header_format = '1';
  $view->block_type = 'teaser';
  $view->nodes_per_block = '0';
  $view->block_more = '0';
  $view->block_use_page_header = FALSE;
  $view->sort = array (
    array (
      'tablename' => 'node',
      'field' => 'sticky',
      'sortorder' => 'ASC',
      'options' => '',
    ),
    array (
      'tablename' => 'role_weights',
      'field' => 'weight',
      'sortorder' => 'ASC',
      'options' => '',
    ),
    array (
      'tablename' => 'node',
      'field' => 'created',
      'sortorder' => 'DESC',
      'options' => '',
    ),
  );
  $view->argument = array (
    array (
      'type' => 'taxletter',
      'argdefault' => '2',
      'title' => 'Vacatures: %1',
      'options' => '',
    ),
  );
  $view->field = array (
    array (
      'tablename' => 'node',
      'field' => 'title',
      'label' => '',
      'handler' => 'views_handler_field_nodelink',
    ),
    array (
      'tablename' => 'term_node_9',
      'field' => 'name',
      'label' => '',
    ),
    array (
      'tablename' => 'term_node_8',
      'field' => 'name',
      'label' => '',
    ),
    array (
      'tablename' => 'term_node_14',
      'field' => 'name',
      'label' => '',
    ),
    array (
      'tablename' => 'term_node_7',
      'field' => 'name',
      'label' => '',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'content-vacature',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'moderate',
      'operator' => '=',
      'options' => '',
      'value' => '0',
    ),
    array (
      'tablename' => 'term_node_9',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
    array (
      'tablename' => 'term_node_11',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
    array (
      'tablename' => 'term_node_7',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
    array (
      'tablename' => 'term_node_8',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
    array (
      'tablename' => 'term_node_14',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
),
    ),
  );
  $view->requires = array(node, role_weights, term_node_9, term_node_8, term_node_14, term_node_7, term_node_11);
  $views[$view->name] = $view;

#3

Posted by leafish_paul on January 30, 2007 at 1:07am

Any luck with this and more recent versions of Views, Bèr?

#4

Posted by leafish_paul on February 27, 2008 at 11:38pm

Title:	views table bug: when sorting by role weights a node appears three times.	» Views support: when sorting by role weights a node appears three times.
Status:	active	» postponed (maintainer needs more info)