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
Comment #1
sunDuplicate of #163889: Duplicate nodes in a view result