This View for some reason displays duplicate nodes every now and then, despite the explicite DISTINCT filter. Bug? Yes, Views Cache flushed. Any help appreciated

  $view = new stdClass();
  $view->name = 'Rate_Music';
  $view->description = 'List of Song Hooks with Voting';
  $view->access = array (
  0 => '2',
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Rate the Music!';
  $view->page_header = '<p></p>
<p>Simply click the flames to add your rating to CVC\'s current playlist!  YOU control the music we play!!</p>
<p></p>


';
  $view->page_header_format = '3';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'node';
  $view->url = 'rate-the-music';
  $view->use_pager = FALSE;
  $view->nodes_per_page = '40';
  $view->sort = array (
    array (
      'tablename' => 'votingapi_vote_vote_percent',
      'field' => 'value',
      'sortorder' => 'DESC',
      'options' => '',
    ),
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'audio_metadata_title',
      'field' => 'value',
      'label' => '',
    ),
    array (
      'tablename' => 'audio_metadata_artist',
      'field' => 'value',
      'label' => '',
    ),
    array (
      'tablename' => 'audio',
      'field' => 'play_link',
      'label' => '',
      'options' => '1pixelout',
    ),
    array (
      'tablename' => 'votingapi_cache_vote_percent_average',
      'field' => 'value',
      'label' => 'Rate it!! ',
      'handler' => 'fivestar_views_widget_compact_handler',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'audio',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'status',
      'operator' => '=',
      'options' => '',
      'value' => '1',
    ),
    array (
      'tablename' => 'term_node_8',
      'field' => 'tid',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => '65',
),
    ),
    array (
      'tablename' => 'node',
      'field' => 'distinct',
      'operator' => '=',
      'options' => '',
      'value' => array (
  0 => 'distinct',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(votingapi_vote_vote_percent, audio_metadata_title, audio_metadata_artist, audio, votingapi_cache_vote_percent_average, node, term_node_8);
  $views[$view->name] = $view;

Comments

sun’s picture

Status: Active » Closed (duplicate)