Aggregator Category Filter stopped working

Views Version 2.9 filter excludes all records, even the ones that are in the selected filter Aggregator category: Category ID = 1

Views Version 2.8 filter displayed records that were in the selected category ID = 1.
----------------------------------------------------

export from Views version 2.9 (with module views_ticker installed -- filter not working, i.e., all records are being excluded):

$view = new view; $view->name = 'wcrdaggregator'; $view->description = 'WCRD Aggregator'; $view->tag = ''; $view->view_php = ''; $view->base_table = 'aggregator_item'; $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('fields', array( 'title' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'display_as_link' => 1, 'exclude' => 0, 'id' => 'title', 'table' => 'aggregator_item', 'field' => 'title', 'relationship' => 'none', ), 'description' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 1, 'max_length' => '200', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'exclude' => 0, 'id' => 'description', 'table' => 'aggregator_item', 'field' => 'description', 'relationship' => 'none', ), )); $handler->override_option('sorts', array( 'random' => array( 'id' => 'random', 'table' => 'views', 'field' => 'random', ), )); $handler->override_option('filters', array( 'cid' => array( 'operator' => 'in', 'value' => array( '1' => '1', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'cid', 'table' => 'aggregator_category', 'field' => 'cid', 'relationship' => 'none', ), )); $handler->override_option('access', array( 'type' => 'none', )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('use_ajax', TRUE); $handler->override_option('style_plugin', 'views_ticker_scroller'); $handler->override_option('style_options', array( 'scroller_type' => 'vertical', 'hscroller_speed' => '30', 'hscroller_direction' => 'left', 'hscroller_delay' => '0', 'hscroller_mouseover' => 0, 'hscroller_bounce' => 0, 'vscroller_speed' => '20', 'vscroller_direction' => 'up', 'vscroller_delay' => '2', 'vscroller_mouseover' => 0, 'vscroller_bounce' => 0, )); $handler = $view->new_display('block', 'Block', 'block_1'); $handler->override_option('block_description', 'Aggregator Ticker'); $handler->override_option('block_caching', -1);

------------------------------------------------------------------
export from Views version 2.8 (filters working, i.e., Category 1 items are being displayed). I only had an older version of the website with Views 2.8 installed, so it was missing the later-installed Views-Ticker module, and I needed to recreate the aggregator view. But 2.8 aggregator filter previously worked correctly with Views Ticker installed (as I recall).

$view = new view; $view->name = 'wcrdaggregator'; $view->description = 'wcrdaggregator'; $view->tag = ''; $view->view_php = ''; $view->base_table = 'aggregator_item'; $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('fields', array( 'title' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'display_as_link' => 1, 'exclude' => 0, 'id' => 'title', 'table' => 'aggregator_item', 'field' => 'title', 'relationship' => 'none', 'override' => array( 'button' => 'Override', ), ), 'description' => array( 'label' => '', 'alter' => array( 'alter_text' => 0, 'text' => '', 'make_link' => 0, 'path' => '', 'link_class' => '', 'alt' => '', 'prefix' => '', 'suffix' => '', 'target' => '', 'help' => '', 'trim' => 0, 'max_length' => '', 'word_boundary' => 1, 'ellipsis' => 1, 'strip_tags' => 0, 'html' => 0, ), 'empty' => '', 'hide_empty' => 0, 'empty_zero' => 0, 'exclude' => 0, 'id' => 'description', 'table' => 'aggregator_item', 'field' => 'description', 'relationship' => 'none', 'override' => array( 'button' => 'Override', ), ), )); $handler->override_option('sorts', array( 'random' => array( 'id' => 'random', 'table' => 'views', 'field' => 'random', ), )); $handler->override_option('filters', array( 'cid' => array( 'operator' => 'in', 'value' => array( '1' => '1', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'cid', 'table' => 'aggregator_category', 'field' => 'cid', 'relationship' => 'none', ), )); $handler->override_option('access', array( 'type' => 'none', )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('use_ajax', TRUE); $handler = $view->new_display('block', 'Block', 'block_1'); $handler->override_option('block_description', 'Aggregator Ticker'); $handler->override_option('block_caching', -1);
----------------------------------------------------------------

Query from Views 2.8 with filters working (i.e., correctly selecting Category = 1 aggregator items)

SELECT aggregator_item.iid AS iid,
aggregator_item.title AS aggregator_item_title,
aggregator_item.link AS aggregator_item_link,
aggregator_item.description AS aggregator_item_description,
RAND() AS _random
FROM aggregator_item aggregator_item
LEFT JOIN aggregator_category_feed aggregator_category_feed ON aggregator_item.fid = aggregator_category_feed.fid
LEFT JOIN aggregator_category aggregator_category ON aggregator_category_feed.cid = aggregator_category.cid
WHERE aggregator_category.cid in ('1')
ORDER BY _random ASC

Let me know if you need more information.

Keith

one thing i've found with drupal is when you're having 'fun' you typically pop out the other end a little bit wiser.

yes i noticed the sql statements were the same, and the exports not much different with the exception of the views-ticker module components. the reason i assigned this bug to the views module is it is very similar to the filters behavior (or over-zealousness of behavior) i saw before application of the following patch to Views 2.8:

andagain.patch

found at http://drupal.org/node/748742 (#16).

before reporting this as a bug i verified (to the best of my visual acuity) that the andagain.patch was indeed committed to Views 2.9.

Keith

red herring or not, the only modules that changed between filters working and now not working were Views and I18n, both due to security updates.

new information. the filter category ID <> 1 also does not work (results are empty).

does this help?

SELECT aggregator_item.iid AS iid,
aggregator_item.title AS aggregator_item_title,
aggregator_item.link AS aggregator_item_link,
aggregator_item.description AS aggregator_item_description,
RAND() AS _random
FROM aggregator_item aggregator_item
LEFT JOIN aggregator_category_feed aggregator_category_feed ON aggregator_item.fid = aggregator_category_feed.fid
LEFT JOIN aggregator_category aggregator_category ON aggregator_category_feed.cid = aggregator_category.cid
WHERE aggregator_category.cid not in ('1')
ORDER BY _random ASC

Keith