Exposed only works on existing products and no longer finds new products

Hi,

Am using D6.22, Views 6.x-2.12, CCK 6.x-2.9, Panels 6.x-3.9 and CTools 6.x-1.8 plus all other modules used are up to date to create a view using 3 x exposed separate taxonomy terms plus an exposed search on a product catalogue of about 250 items and all worked fine until a couple of days ago.

The search still works on existing products but now is not finding new items as they are added. The new products themselves render fine and can be found OK via the taxonomy tags. I have tried clearing cache, re-indexing and even updating the site to no avail. I've even rebuilt the view but that doesn't work either.

Query and export are below.

Any ideas?

Thanks

QUERY
SELECT node.nid AS nid, node_data_field_partimage.field_partimage_fid AS node_data_field_partimage_field_partimage_fid, node_data_field_partimage.field_partimage_list AS node_data_field_partimage_field_partimage_list, node_data_field_partimage.field_partimage_data AS node_data_field_partimage_field_partimage_data, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_data_field_partimage.field_registrationserial_value AS node_data_field_partimage_field_registrationserial_value, node_data_field_partimage.field_partnumber_value AS node_data_field_partimage_field_partnumber_value, uc_products.sell_price AS uc_products_sell_price FROM node node LEFT JOIN uc_product_stock uc_product_stock ON node.nid = uc_product_stock.nid LEFT JOIN content_type_product node_data_field_partimage ON node.vid = node_data_field_partimage.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.type in ('product')) AND (node.status <> 0) AND (uc_product_stock.stock > 0)

EXPORT
$view = new view;
$view->name = 'searchaircraftparts001';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$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(
'field_partimage_fid' => 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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'label_type' => 'none',
'format' => 'imagefield__lightbox2__listing80x60__original',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_partimage_fid',
'table' => 'node_data_field_partimage',
'field' => 'field_partimage_fid',
'relationship' => 'none',
),
'title' => array(
'label' => 'Part',
'alter' => array(
'alter_text' => 1,
'text' => '[title]',
'make_link' => 0,
'path' => '',
'link_class' => '',
'alt' => '',
'prefix' => '',
'suffix' => '',
'target' => '',
'help' => '',
'trim' => 0,
'max_length' => '',
'word_boundary' => 1,
'ellipsis' => 1,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 1,
'exclude' => 0,
'id' => 'title',
'table' => 'node',
'field' => 'title',
'relationship' => 'none',
),
'view_node' => 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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'text' => 'Details',
'exclude' => 0,
'id' => 'view_node',
'table' => 'node',
'field' => 'view_node',
'relationship' => 'none',
),
'tid' => array(
'label' => 'Manf.',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'type' => 'separator',
'separator' => ', ',
'link_to_taxonomy' => 1,
'limit' => 1,
'vids' => array(
'7' => 7,
'4' => 0,
'5' => 0,
'3' => 0,
'8' => 0,
'2' => 0,
'1' => 0,
'9' => 0,
),
'exclude' => 0,
'id' => 'tid',
'table' => 'term_node',
'field' => 'tid',
'relationship' => 'none',
),
'tid_1' => array(
'label' => 'Type',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'type' => 'separator',
'separator' => ', ',
'link_to_taxonomy' => 1,
'limit' => 1,
'vids' => array(
'4' => 4,
'7' => 0,
'5' => 0,
'3' => 0,
'8' => 0,
'2' => 0,
'1' => 0,
'9' => 0,
),
'exclude' => 0,
'id' => 'tid_1',
'table' => 'term_node',
'field' => 'tid',
'relationship' => 'none',
),
'field_registrationserial_value' => array(
'label' => 'Reg : S/N',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'label_type' => 'custom',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_registrationserial_value',
'table' => 'node_data_field_registrationserial',
'field' => 'field_registrationserial_value',
'relationship' => 'none',
),
'tid_2' => array(
'label' => 'Part Type',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'type' => 'separator',
'separator' => ', ',
'link_to_taxonomy' => 1,
'limit' => 1,
'vids' => array(
'5' => 5,
'7' => 0,
'4' => 0,
'3' => 0,
'8' => 0,
'2' => 0,
'1' => 0,
'9' => 0,
),
'exclude' => 0,
'id' => 'tid_2',
'table' => 'term_node',
'field' => 'tid',
'relationship' => 'none',
),
'field_partnumber_value' => array(
'label' => 'Part #',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'link_to_node' => 0,
'label_type' => 'custom',
'format' => 'default',
'multiple' => array(
'group' => TRUE,
'multiple_number' => '',
'multiple_from' => '',
'multiple_reversed' => FALSE,
),
'exclude' => 0,
'id' => 'field_partnumber_value',
'table' => 'node_data_field_partnumber',
'field' => 'field_partnumber_value',
'relationship' => 'none',
),
'sell_price' => array(
'label' => 'Price',
'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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'set_precision' => 0,
'precision' => '0',
'decimal' => '.',
'separator' => ',',
'prefix' => '',
'suffix' => '',
'format' => 'uc_price',
'revision' => 'themed',
'exclude' => 0,
'id' => 'sell_price',
'table' => 'uc_products',
'field' => 'sell_price',
'relationship' => 'none',
),
'buyitnowbutton' => 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,
'html' => 0,
'strip_tags' => 0,
),
'empty' => '',
'hide_empty' => 0,
'empty_zero' => 0,
'exclude' => 0,
'id' => 'buyitnowbutton',
'table' => 'uc_products',
'field' => 'buyitnowbutton',
'relationship' => 'none',
),
));
$handler->override_option('filters', array(
'type' => array(
'operator' => 'in',
'value' => array(
'product' => 'product',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'type',
'table' => 'node',
'field' => 'type',
'relationship' => 'none',
),
'status' => array(
'operator' => '=',
'value' => '1',
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'status',
'table' => 'node',
'field' => 'status',
'relationship' => 'none',
),
'stock' => array(
'operator' => '>',
'value' => array(
'value' => '0',
'min' => '',
'max' => '',
),
'group' => '0',
'exposed' => FALSE,
'expose' => array(
'operator' => FALSE,
'label' => '',
),
'id' => 'stock',
'table' => 'uc_product_stock',
'field' => 'stock',
'relationship' => 'none',
),
'term_node_tid_depth_1' => array(
'operator' => 'or',
'value' => array(
'20' => '20',
'22' => '22',
'26' => '26',
'21' => '21',
),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'term_node_tid_depth_1_op',
'identifier' => '001aircraft',
'label' => 'Aircraft Type',
'optional' => 1,
'single' => 1,
'remember' => 0,
'reduce' => 1,
),
'type' => 'select',
'limit' => TRUE,
'vid' => '7',
'depth' => '0',
'id' => 'term_node_tid_depth_1',
'table' => 'node',
'field' => 'term_node_tid_depth',
'hierarchy' => 0,
'relationship' => 'none',
'reduce_duplicates' => 1,
),
'term_node_tid_depth' => array(
'operator' => 'or',
'value' => array(
'17' => '17',
'37' => '37',
'53' => '53',
'23' => '23',
'19' => '19',
'18' => '18',
),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'term_node_tid_depth_op',
'identifier' => '001model',
'label' => 'Model',
'optional' => 1,
'single' => 1,
'remember' => 0,
'reduce' => 1,
),
'type' => 'select',
'limit' => TRUE,
'vid' => '4',
'depth' => '0',
'id' => 'term_node_tid_depth',
'table' => 'node',
'field' => 'term_node_tid_depth',
'hierarchy' => 0,
'relationship' => 'none',
'reduce_duplicates' => 1,
),
'term_node_tid_depth_2' => array(
'operator' => 'or',
'value' => array(
'5' => '5',
'6' => '6',
'54' => '54',
'9' => '9',
'7' => '7',
'27' => '27',
'11' => '11',
'48' => '48',
'52' => '52',
'8' => '8',
'45' => '45',
'10' => '10',
'13' => '13',
'12' => '12',
'55' => '55',
),
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'term_node_tid_depth_2_op',
'identifier' => '001part',
'label' => 'Part Type',
'optional' => 1,
'single' => 1,
'remember' => 0,
'reduce' => 1,
),
'type' => 'select',
'limit' => TRUE,
'vid' => '5',
'depth' => '0',
'id' => 'term_node_tid_depth_2',
'table' => 'node',
'field' => 'term_node_tid_depth',
'hierarchy' => 0,
'relationship' => 'none',
'reduce_duplicates' => 1,
),
'keys' => array(
'operator' => 'required',
'value' => '',
'group' => '0',
'exposed' => TRUE,
'expose' => array(
'use_operator' => 0,
'operator' => 'keys_op',
'identifier' => 'search',
'label' => 'Parts #, Aircraft reg. etc',
'optional' => 1,
'remember' => 0,
),
'id' => 'keys',
'table' => 'search_index',
'field' => 'keys',
'relationship' => 'none',
),
));
$handler->override_option('access', array(
'type' => 'none',
));
$handler->override_option('cache', array(
'type' => 'none',
));
$handler->override_option('title', 'AIRCRAFT SPARE PARTS CATALOGUE');
$handler->override_option('footer', 'View full catalogue');
$handler->override_option('footer_format', '2');
$handler->override_option('footer_empty', 0);
$handler->override_option('empty', 'We\'re sorry. we can\'t find the part you are looking for. Please use the search feature above modifying your search criteria. ');
$handler->override_option('empty_format', '2');
$handler->override_option('items_per_page', 20);
$handler->override_option('use_pager', '1');
$handler->override_option('style_plugin', 'table');
$handler->override_option('style_options', array(
'grouping' => '',
'override' => 0,
'sticky' => 0,
'order' => 'asc',
'columns' => array(
'field_partimage_fid' => 'field_partimage_fid',
'title' => 'title',
'view_node' => 'title',
'tid' => 'tid',
'tid_1' => 'tid_1',
'field_registrationserial_value' => 'field_registrationserial_value',
'tid_2' => 'tid_2',
'field_partnumber_value' => 'field_partnumber_value',
'sell_price' => 'sell_price',
'buyitnowbutton' => 'buyitnowbutton',
),
'info' => array(
'field_partimage_fid' => array(
'separator' => '',
),
'title' => array(
'sortable' => 0,
'separator' => '
',
),
'view_node' => array(
'separator' => '',
),
'tid' => array(
'separator' => '',
),
'tid_1' => array(
'separator' => '',
),
'field_registrationserial_value' => array(
'separator' => '',
),
'tid_2' => array(
'separator' => '',
),
'field_partnumber_value' => array(
'sortable' => 0,
'separator' => '',
),
'sell_price' => array(
'sortable' => 0,
'separator' => '',
),
'buyitnowbutton' => array(
'separator' => '',
),
),
'default' => '-1',
));
$handler->override_option('exposed_block', TRUE);
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->override_option('path', 'catalogue-search-aircraft-spare-parts');
$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,
'name' => 'navigation',
));
$handler = $view->new_display('block', 'Block', 'block_1');
$handler->override_option('block_description', '');
$handler->override_option('block_caching', -1);