I'm having what seems to be the same as this problem -- http://drupal.org/node/614968 -- but in Drupal 7.8 with the the latest dev releases (as of 2 days ago) of Views & Ctools. More specifically, here are some of the details...

* Any Views that I have include the taxonomy Contextual Filters show as blank for anonymous users. User/1 can see these views' rows fine; it seems that various roles of authenticated users can too. But not anonymous users.

* The views that are failing are using the following contexts:

CONTEXTUAL FILTERS
Content: Has taxonomy term ID (with depth)
Content: Has taxonomy term ID depth modifier

* I have multiple other views that have Filter Criteria (i.e., the good old fashion standard filters section of views admin, not the newer Contextual Filters section that are causing this problem) based on taxonomy, but do not include any contextual filters. These seem to display just fine for anonymous users.

* The views that are failing include a grid style page, a table style page, and a teaser list style page.

* I've cleared cache repeatedly.

* I've rebuilt permissions, then cleared cache again.

* There are no access restrictions set on any of the views mentioned above.

I think this just started when I updated to Drupal 7.8 from 7.7 two days ago, but I'm not 100% certain about that.

Comments

dawehner’s picture

dawehner
Primary language German
CreditAttribution: dawehner commented
Status: Active » Postponed (maintainer needs more info)

Some questions which are somehow critical to understand the problem

* Does anonymous user have access to the single node?
* Do you have installed some node acesss / taxonomy access modules on your system?
* Can you provide an export of your view as well as the sql preview?

somatics’s picture

somatics CreditAttribution: somatics commented

* Yes, anonymous has access to the nodes being listed. They have no access restrictions.

* The only access control we are using is Organic Groups Access. Years ago we got into trouble using more than one access control module and have avoided that practice since.

* Here's an export of the view, followed by the preview info provided by the views admin page (I think that's what you mean by SQL preview), for the View instance we've named Page (List).



$view = new view;
$view->name = 'commerce_catalog_browser';
$view->description = 'A view to emulate Drupal core\'s handling of taxonomy/term.';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Commerce Catalog Browser';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Product Catalog';
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['expose']['items_per_page'] = TRUE;
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = 0;
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'node';
/* Header: Global: Text area */
$handler->display->display_options['header']['area']['id'] = 'area';
$handler->display->display_options['header']['area']['table'] = 'views';
$handler->display->display_options['header']['area']['field'] = 'area';
$handler->display->display_options['header']['area']['label'] = 'Header Text';
$handler->display->display_options['header']['area']['empty'] = FALSE;
$handler->display->display_options['header']['area']['content'] = 'Our product catalog is listed here, organized by category.';
$handler->display->display_options['header']['area']['format'] = '1';
$handler->display->display_options['header']['area']['tokenize'] = 0;
/* Relationship: Content: Referenced product */
$handler->display->display_options['relationships']['field_product_product_id']['id'] = 'field_product_product_id';
$handler->display->display_options['relationships']['field_product_product_id']['table'] = 'field_data_field_product';
$handler->display->display_options['relationships']['field_product_product_id']['field'] = 'field_product_product_id';
$handler->display->display_options['relationships']['field_product_product_id']['label'] = 'Referenced Product';
$handler->display->display_options['relationships']['field_product_product_id']['required'] = 1;
/* Field: Commerce Product: Image */
$handler->display->display_options['fields']['field_image']['id'] = 'field_image';
$handler->display->display_options['fields']['field_image']['table'] = 'field_data_field_image';
$handler->display->display_options['fields']['field_image']['field'] = 'field_image';
$handler->display->display_options['fields']['field_image']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['field_image']['label'] = '';
$handler->display->display_options['fields']['field_image']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_image']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_image']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_image']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_image']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_image']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_image']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_image']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['field_image']['click_sort_column'] = 'fid';
$handler->display->display_options['fields']['field_image']['settings'] = array(
  'image_style' => 'thumbnail',
  'image_link' => 'content',
);
$handler->display->display_options['fields']['field_image']['field_api_classes'] = 0;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Commerce Product: Price */
$handler->display->display_options['fields']['commerce_price']['id'] = 'commerce_price';
$handler->display->display_options['fields']['commerce_price']['table'] = 'field_data_commerce_price';
$handler->display->display_options['fields']['commerce_price']['field'] = 'commerce_price';
$handler->display->display_options['fields']['commerce_price']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['commerce_price']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['external'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['commerce_price']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['commerce_price']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['trim'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['html'] = 0;
$handler->display->display_options['fields']['commerce_price']['element_label_colon'] = 1;
$handler->display->display_options['fields']['commerce_price']['element_default_classes'] = 1;
$handler->display->display_options['fields']['commerce_price']['hide_empty'] = 0;
$handler->display->display_options['fields']['commerce_price']['empty_zero'] = 0;
$handler->display->display_options['fields']['commerce_price']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['commerce_price']['click_sort_column'] = 'amount';
$handler->display->display_options['fields']['commerce_price']['type'] = 'commerce_price_formatted_amount';
$handler->display->display_options['fields']['commerce_price']['settings'] = array(
  'calculation' => 'calculated_sell_price',
);
$handler->display->display_options['fields']['commerce_price']['field_api_classes'] = 0;
/* Field: Commerce Product: Add to Cart form */
$handler->display->display_options['fields']['add_to_cart_form']['id'] = 'add_to_cart_form';
$handler->display->display_options['fields']['add_to_cart_form']['table'] = 'commerce_product';
$handler->display->display_options['fields']['add_to_cart_form']['field'] = 'add_to_cart_form';
$handler->display->display_options['fields']['add_to_cart_form']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['add_to_cart_form']['label'] = '';
$handler->display->display_options['fields']['add_to_cart_form']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['external'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['trim'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['html'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['add_to_cart_form']['element_default_classes'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['hide_empty'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['empty_zero'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['show_quantity'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['default_quantity'] = '1';
$handler->display->display_options['fields']['add_to_cart_form']['combine'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['display_path'] = 0;
/* Field: Commerce Product: Operations links */
$handler->display->display_options['fields']['operations']['id'] = 'operations';
$handler->display->display_options['fields']['operations']['table'] = 'commerce_product';
$handler->display->display_options['fields']['operations']['field'] = 'operations';
$handler->display->display_options['fields']['operations']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['operations']['label'] = '';
$handler->display->display_options['fields']['operations']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['operations']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['operations']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['operations']['alter']['external'] = 0;
$handler->display->display_options['fields']['operations']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['operations']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['operations']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['operations']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['operations']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['operations']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['operations']['alter']['trim'] = 0;
$handler->display->display_options['fields']['operations']['alter']['html'] = 0;
$handler->display->display_options['fields']['operations']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['operations']['element_default_classes'] = 1;
$handler->display->display_options['fields']['operations']['hide_empty'] = 0;
$handler->display->display_options['fields']['operations']['empty_zero'] = 0;
$handler->display->display_options['fields']['operations']['hide_alter_empty'] = 0;
/* Sort criterion: Content: Sticky */
$handler->display->display_options['sorts']['sticky']['id'] = 'sticky';
$handler->display->display_options['sorts']['sticky']['table'] = 'node';
$handler->display->display_options['sorts']['sticky']['field'] = 'sticky';
$handler->display->display_options['sorts']['sticky']['order'] = 'DESC';
/* Sort criterion: Content: Post date */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Contextual filter: Content: Has taxonomy term ID (with depth) */
$handler->display->display_options['arguments']['term_node_tid_depth']['id'] = 'term_node_tid_depth';
$handler->display->display_options['arguments']['term_node_tid_depth']['table'] = 'node';
$handler->display->display_options['arguments']['term_node_tid_depth']['field'] = 'term_node_tid_depth';
$handler->display->display_options['arguments']['term_node_tid_depth']['default_action'] = 'not found';
$handler->display->display_options['arguments']['term_node_tid_depth']['exception']['title_enable'] = 1;
$handler->display->display_options['arguments']['term_node_tid_depth']['title_enable'] = 1;
$handler->display->display_options['arguments']['term_node_tid_depth']['title'] = '%1';
$handler->display->display_options['arguments']['term_node_tid_depth']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['term_node_tid_depth']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['term_node_tid_depth']['specify_validation'] = 1;
$handler->display->display_options['arguments']['term_node_tid_depth']['validate']['type'] = 'taxonomy_term';
$handler->display->display_options['arguments']['term_node_tid_depth']['depth'] = '0';
$handler->display->display_options['arguments']['term_node_tid_depth']['break_phrase'] = 1;
/* Contextual filter: Content: Has taxonomy term ID depth modifier */
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['id'] = 'term_node_tid_depth_modifier';
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['table'] = 'node';
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['field'] = 'term_node_tid_depth_modifier';
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['exception']['title_enable'] = 1;
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['default_argument_type'] = 'fixed';
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['term_node_tid_depth_modifier']['specify_validation'] = 1;
/* Filter criterion: Content: Published or admin */
$handler->display->display_options['filters']['status_extra']['id'] = 'status_extra';
$handler->display->display_options['filters']['status_extra']['table'] = 'node';
$handler->display->display_options['filters']['status_extra']['field'] = 'status_extra';
$handler->display->display_options['filters']['status_extra']['group'] = 0;
$handler->display->display_options['filters']['status_extra']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Catalog category (field_taxonomy_catalog) */
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['id'] = 'field_taxonomy_catalog_tid';
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['table'] = 'field_data_field_taxonomy_catalog';
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['field'] = 'field_taxonomy_catalog_tid';
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['value'] = array(
  206 => '206',
  223 => '223',
  224 => '224',
  225 => '225',
  313 => '313',
  205 => '205',
  207 => '207',
  208 => '208',
  209 => '209',
  215 => '215',
  210 => '210',
  228 => '228',
  227 => '227',
  226 => '226',
  229 => '229',
  253 => '253',
  211 => '211',
  212 => '212',
  213 => '213',
  565 => '565',
  214 => '214',
  202 => '202',
  216 => '216',
  218 => '218',
  217 => '217',
  252 => '252',
  369 => '369',
  203 => '203',
  220 => '220',
  221 => '221',
  219 => '219',
  334 => '334',
  204 => '204',
  370 => '370',
  504 => '504',
  512 => '512',
  517 => '517',
  335 => '335',
  518 => '518',
  519 => '519',
  510 => '510',
  511 => '511',
  562 => '562',
);
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['reduce_duplicates'] = 0;
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['type'] = 'select';
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['vocabulary'] = 'vocabulary_25';
$handler->display->display_options['filters']['field_taxonomy_catalog_tid']['hierarchy'] = 1;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'shop/catalog/%';

/* Display: Feed */
$handler = $view->new_display('feed', 'Feed', 'feed');
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = 15;
$handler->display->display_options['style_plugin'] = 'rss';
$handler->display->display_options['row_plugin'] = 'node_rss';
$handler->display->display_options['path'] = 'taxonomy/term/%/%/feed';
$handler->display->display_options['displays'] = array(
  'page' => 'page',
  'default' => 0,
);

/* Display: Page (Teaser) */
$handler = $view->new_display('page', 'Page (Teaser)', 'page_1');
$handler->display->display_options['display_description'] = 'Teaser view of product catalog browser.';
$handler->display->display_options['path'] = 'shop/browse/%';

/* Display: Page (Grid) */
$handler = $view->new_display('page', 'Page (Grid)', 'page_2');
$handler->display->display_options['display_description'] = 'Grid view of the product catalog.';
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'grid';
$handler->display->display_options['style_options']['columns'] = '3';
$handler->display->display_options['style_options']['fill_single_line'] = 1;
$handler->display->display_options['style_options']['summary'] = 'Table for grid view of products catalog.';
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 1;
$handler->display->display_options['row_options']['default_field_elements'] = 1;
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['path'] = 'taxonomy/term/%/grid';
$handler->display->display_options['menu']['type'] = 'tab';
$handler->display->display_options['menu']['title'] = 'Grid View';
$handler->display->display_options['menu']['description'] = 'View this list in grid format';
$handler->display->display_options['menu']['weight'] = '3';

/* Display: Page (List) */
$handler = $view->new_display('page', 'Page (List)', 'page_3');
$handler->display->display_options['display_description'] = 'List view of the product catalog.';
$handler->display->display_options['defaults']['style_plugin'] = FALSE;
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'field_image_cache' => 'field_image_cache',
  'title' => 'title',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
  'field_image_cache' => array(
    'align' => '',
    'separator' => '',
  ),
  'title' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
  ),
);
$handler->display->display_options['style_options']['override'] = 1;
$handler->display->display_options['style_options']['sticky'] = 0;
$handler->display->display_options['style_options']['empty_table'] = 1;
$handler->display->display_options['defaults']['style_options'] = FALSE;
$handler->display->display_options['defaults']['row_plugin'] = FALSE;
$handler->display->display_options['defaults']['row_options'] = FALSE;
$handler->display->display_options['path'] = 'taxonomy/term/%/list';
$handler->display->display_options['menu']['type'] = 'tab';
$handler->display->display_options['menu']['title'] = 'List View';
$handler->display->display_options['menu']['description'] = 'View this list in convenient compact form';
$handler->display->display_options['menu']['weight'] = '5';
$translatables['commerce_catalog_browser'] = array(
  t('Master'),
  t('Product Catalog'),
  t('more'),
  t('Apply'),
  t('Reset'),
  t('Sort by'),
  t('Asc'),
  t('Desc'),
  t('Items per page'),
  t('- All -'),
  t('Offset'),
  t('Header Text'),
  t('Our product catalog is listed here, organized by category.'),
  t('Referenced Product'),
  t('Price'),
  t('All'),
  t('%1'),
  t('Page'),
  t('Feed'),
  t('Page (Teaser)'),
  t('Teaser view of product catalog browser.'),
  t('Page (Grid)'),
  t('Grid view of the product catalog.'),
  t('Page (List)'),
  t('List view of the product catalog.'),
);



SELECT commerce_product_field_data_field_product.product_id AS commerce_product_field_data_field_product_product_id, node.title AS node_title, node.nid AS nid, node.sticky AS node_sticky, node.created AS node_created, 'commerce_product' AS field_data_field_image_commerce_product_entity_type, 'commerce_product' AS field_data_commerce_price_commerce_product_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_product} field_data_field_product ON node.nid = field_data_field_product.entity_id AND (field_data_field_product.entity_type = 'node' AND field_data_field_product.deleted = '0')
INNER JOIN {commerce_product} commerce_product_field_data_field_product ON field_data_field_product.field_product_product_id = commerce_product_field_data_field_product.product_id
INNER JOIN {field_data_field_taxonomy_catalog} field_data_field_taxonomy_catalog ON node.nid = field_data_field_taxonomy_catalog.entity_id AND (field_data_field_taxonomy_catalog.entity_type = 'node' AND field_data_field_taxonomy_catalog.deleted = '0')
WHERE (( (node.status = 1 OR (node.uid = 6 AND 6 <> 0 AND 1 = 1) OR 1 = 1) AND (field_data_field_taxonomy_catalog.field_taxonomy_catalog_tid IN  ('206', '223', '224', '225', '313', '205', '207', '208', '209', '215', '210', '228', '227', '226', '229', '253', '211', '212', '213', '565', '214', '202', '216', '218', '217', '252', '369', '203', '220', '221', '219', '334', '204', '370', '504', '512', '517', '335', '518', '519', '510', '511', '562')) AND (node.nid IN  (SELECT tn.nid AS nid
FROM 
{taxonomy_index} tn
WHERE ( (tn.tid = '223') ))) ))
ORDER BY node_sticky DESC, node_created DESC
LIMIT 10 OFFSET 0
rucx’s picture

rucx CreditAttribution: rucx commented

got similar problem but with relationships: http://drupal.org/node/1276074

somatics’s picture

somatics CreditAttribution: somatics commented
Status: Postponed (maintainer needs more info) » Active

I wanted to add some additional information I found: It's not just the anonymous that doesn't see the view, it appears to be all user roles other than user/1.

rucx’s picture

rucx CreditAttribution: rucx commented

with the newest dev version (as of today) my views started appearing correctly.

Letharion’s picture

Letharion CreditAttribution: Letharion commented
Status: Active » Fixed

I'm going to close this issue, for two separate reasons.
1) A user has reported it fixed
and, more importantly
2) it can't be fixed in it's current state.

If this error is still around for someone else, you absolutely need to apply some "divide and conquer". There is way to many variables here to figure out what's going on. Clone the view, simplifying it as much as possible until the error can no longer be reproduced, so that it can more easily be understood where the problem occurs.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

dropbydrop’s picture

dropbydrop CreditAttribution: dropbydrop commented
Version: 7.x-3.x-dev » 7.x-3.4
Status: Closed (fixed) » Active

After updating to 3.4 rss data do not appear to anonymous users.
I tried also the todays' dev version but no result.
Going back to 3.3 fixes the problem!

What new feature of 3.4 could introduce the problem?

couturier’s picture

couturier CreditAttribution: couturier commented

Are you able to follow the instructions in comment #6 to help us figure this out?

dropbydrop’s picture

dropbydrop CreditAttribution: dropbydrop commented

I try to figure out.
Did anything change related to permissions since views 7-3.3?

somatics’s picture

somatics CreditAttribution: somatics commented

I don't remember where I found the issue resolution, but somewhere there's a post regarding Views or Drupal Commerce that IIRC solved this problem for me and many others. I can't remember how to explain this very articulately, but here's the gist: Apparently, when there is a relationship of the sort that includes Taxonomy depth, permissions can't track through the layers of relationships properly. I can show the View, but not the records being queried through the relationship on the View, so it shows blank.

The way to fix this is to go to Query settings under Other settings on the admin page for the View, and check the box for "Disable SQL rewriting".

This will prevent Drupal from checking node_access when it runs the query for the View. It means that the View can show records to a user who shouldn't see them, so you have to carefully set your filters for the View to limit them correctly and specifically -- but it works like a charm for the problem I had. I've had to do it for several Views with relationships, and it has worked every time.

Try it and see if it this fixes your problem too, and then we'll know if we're talking about the same thing. If so, perhaps we have some more information for this issue, as per #6, and we can get everyone closer to finding a real solution that doesn't require Disabling the SQL Rewriting.

dropbydrop’s picture

dropbydrop CreditAttribution: dropbydrop commented
Status: Active » Closed (fixed)

that's another issue what i have

cogno’s picture

cogno CreditAttribution: cogno commented
Status: Closed (fixed) » Active

I've been having the same issue, and this workaround solved my problem. What flummoxed me was that my taxonomy term view pulls in two content types and fields for one of them showed up fine, but not the other.

a.ross’s picture

a.ross CreditAttribution: a.ross commented

Having the same issue, the workaround in #11 fixes it for me as well.

My view also has a relationship to the product bundle and I'm also using Commerce. It turns out that the error disappears when I remove that relationship.

guy_schneerson’s picture

guy_schneerson CreditAttribution: guy_schneerson commented
Priority: Major » Minor
Status: Active » Closed (duplicate)

This is not a views issue but a commerce one.
The problem is the "View any product of any type" permission that's not set by default.
I tested this on two non commerce sites and the view works fine.

see Views results empty for unprivileged user when using Relationship: Content: Referenced Product

If anyone gets this issue on a view that doesn't link in the commerce product then please re-open

guy_schneerson’s picture

guy_schneerson CreditAttribution: guy_schneerson commented
Status: Closed (duplicate) » Closed (works as designed)

Sorry it should be "works as designed" and not a "duplicate" as the duplicate issue is on another project

_sania’s picture

_sania CreditAttribution: _sania commented

is it really dangerous to let any user view any product if yes, explain why, please

matthewv789’s picture

matthewv789 CreditAttribution: matthewv789 commented

I had a similar problem, and it was not that nothing showed up, but rather than when selecting any category other than "All" in the exposed filter, anonymous users would always see the same results, as if it had permanently cached the results for one particular category and was always using that. Everything worked fine while logged in, though, and even anonymous users could still click "All" to see all the results. I made sure to turn off Views caching for this View, but it made no difference. Enabling or disabling "Use Ajax" also made no difference.

Disabling SQL rewriting under Query Settings (per #11) fixed this issue for me as well, though I worry about other issues coming up (like seeing unpublished content in this area?) It's not super sensitive content so I'm not TOO worried, but this does seem like a bug of some kind. (I am not using Commerce or any unusual entity type, just a standard content type and taxonomy.)

hockey2112’s picture

hockey2112 CreditAttribution: hockey2112 commented
Issue summary: View changes

#11 fixed it for me! Thanks!

NWOM’s picture

NWOM CreditAttribution: NWOM commented
Version: 7.x-3.4 » 7.x-3.x-dev
Priority: Minor » Normal
Status: Closed (works as designed) » Active

I can confirm that this problem is not isolated to the Commerce module. My environment does not have Commerce installed and #11 fixed this. This is similar to what @matthewv789 said.

More information: I'm able to reproduce mine with an Entity Reference field used as a Relationship, and in turn having fields display from that Relationship. If the entity reference does not exist, then the view is only viewable by admin, however the moment the entity reference exists, results are shown by other users as well.

Jabastin Arul’s picture

Jabastin Arul CreditAttribution: Jabastin Arul commented

#11 fixed it for me too!!

Please see below link:

https://www.drupal.org/node/1276450

Its also same issue....

Jabastin Arul’s picture

Jabastin Arul CreditAttribution: Jabastin Arul commented
Status: Active » Closed (duplicate)
NWOM’s picture

NWOM CreditAttribution: NWOM commented
Status: Closed (duplicate) » Active

As explained in a prior comment and by others, this does not necessarily affect only people with the Commerce module. I do not have the Commerce module installed, and #11 fixes the issue.

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous as a volunteer commented

#11 is still the bomb.

Thanks!

dkrockville’s picture

dkrockville CreditAttribution: dkrockville as a volunteer commented

Disabling sql-rewriting in views advanced did not work for me.
Any other ideas?
Drupal 8.6.4

When an anonymous user views the node page, the taxonomy term is not visible. All other roles can view that term.

dkrockville’s picture

dkrockville CreditAttribution: dkrockville as a volunteer commented
Version: 7.x-3.x-dev » 8.x-3.x-dev
couturier’s picture

couturier CreditAttribution: couturier as a volunteer commented

Please forgive me if I have missed something, but since Views is now in core for Drupal 8, why are we moving this issue out of the 7.x queue?

MustangGB’s picture

MustangGB CreditAttribution: MustangGB commented
Version: 8.x-3.x-dev » 7.x-3.x-dev
Status: Active » Closed (works as designed)

What @couturier said, open a new issue for D8 in the core queue if you wish, this was already answered for D7.

xurizaemon’s picture

xurizaemon
he/him
Location Ōtepoti, Aotearoa 🏝
CreditAttribution: xurizaemon at Catalyst IT commented

@somatics, from someone using Drupal 8.8 in 2020, thanks for your comment from 2012 - disable SQL rewriting did the trick for me too.

robert_t_taylor’s picture

robert_t_taylor CreditAttribution: robert_t_taylor as a volunteer and commented

+1 on #11. Thank you!

tce’s picture

tce CreditAttribution: tce commented

@somatics thanks for the advice in #11, this helped me fix my issue

seedmeAu’s picture

seedmeAu CreditAttribution: seedmeAu as a volunteer commented

@somatics thanks for the advice in #11. However isn't this is now handled by a module called "Permission by Term"? I am using V9.2.x and could not find a settings called "Disable SQL rewrite", which according to #stackoverflow is now called disable Access Check. I only find such setting within this module.

The reason I responded to this old discussion is that we also run into similar issue with displaying a view - teaser provided by gavias_view from Gavis_theme using Gavias Owl Carousel. The rendering of display randomly fails for anonymous till the cache is cleared manually.

Please kindly advise should I get the mentioned module here installed and see if that resolve the issue? - being reluctant of doing so as trying to minimise modules involved.