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,
));
Comments
Comment #1
jennycita commentedMarking as a duplicate of http://drupal.org/node/536692.
Comment #2
apetryk commentedSame 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).
Comment #3
oromix commentedSame exact issue. Subscribe.
Comment #4
tommeir commentedthis 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.