Hello, I'm building a view of type "Taxonomy."

I have 2 filters, to filter to a specific vocabulary, and to exclude certain terms.

When attempting to view the page, I get the following error

Fatal error: Maximum execution time of 30 seconds exceeded in /.../modules/views/views.module on line 866

When I use the "Is none of" filter for "Taxonomy: Term ID", I get the above error. If change it to "Is one of" for "Taxonomy: Term ID" the error goes away.

Cleared cache, etc. Here's the view. The on the below, the error occurs on the Page and not the Default.

$view = new view;
$view->name = 'taxonomy_site_sections';
$view->description = 'Our site sections, a listing of taxonomy terms.';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'term_data';
$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(
  'name' => 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,
    'link_to_taxonomy' => 1,
    'exclude' => 0,
    'id' => 'name',
    'table' => 'term_data',
    'field' => 'name',
    'relationship' => 'none',
  ),
  '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' => 'term_data',
    'field' => 'description',
    'relationship' => 'none',
  ),
));
$handler->override_option('filters', array(
  'vid' => array(
    'operator' => 'in',
    'value' => array(
      '8' => '8',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'vid',
    'table' => 'term_data',
    'field' => 'vid',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
));
$handler->override_option('access', array(
  'type' => 'none',
));
$handler->override_option('cache', array(
  'type' => 'none',
));
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('filters', array(
  'vid' => array(
    'operator' => 'in',
    'value' => array(
      '8' => '8',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'id' => 'vid',
    'table' => 'term_data',
    'field' => 'vid',
    'relationship' => 'none',
    'override' => array(
      'button' => 'Override',
    ),
  ),
  'tid' => array(
    'operator' => 'not',
    'value' => array(
      '54' => '54',
      '50' => '50',
      '53' => '53',
    ),
    'group' => '0',
    'exposed' => FALSE,
    'expose' => array(
      'operator' => FALSE,
      'label' => '',
    ),
    'type' => 'select',
    'limit' => TRUE,
    'vid' => '8',
    'id' => 'tid',
    'table' => 'term_data',
    'field' => 'tid',
    'hierarchy' => 1,
    'override' => array(
      'button' => 'Use default',
    ),
    'relationship' => 'none',
    'reduce_duplicates' => 1,
  ),
));
$handler->override_option('path', 'our-programs-quixote');
$handler->override_option('menu', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
  'name' => 'navigation',
));
$handler->override_option('tab_options', array(
  'type' => 'none',
  'title' => '',
  'description' => '',
  'weight' => 0,
));

CommentFileSizeAuthor
#2 views_is_none_of_bug.txt22 KBapetryk

Comments

jennycita’s picture

Status: Active » Closed (duplicate)

Marking as a duplicate of http://drupal.org/node/536692.

apetryk’s picture

StatusFileSize
new22 KB

Same issue here. In my view (see attachment), it's the Jump display that's causing the problem.

Error logs show that Views is running out of execution time when trying to cache the results of this query.

A simple workaround is to use 'is one of', select all the terms in your vocabulary, then deselect the ones you don't want. This is equivalent to using 'is none of' and selecting the ones you don't want (which is causing the crash).

oromix’s picture

Same exact issue. Subscribe.

tommeir’s picture

this solution doesnt work for me.(in my case i only have 1 term inside that vocab).

using content taxonomy instead and thus shifting the filter handling problem to cck seems to do it.