Some of my views show no results after updating to the latest release. There's no indication of why, although in the view preview I get the error "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens". I looked that up here but that problem goes back at least two years so I don't know if it's anything to do with the latest release.

I've tried the latest dev version but that had the same effect. If I remain using 7.x-3.7 the views are fine.

Here is an export of two of my views, the first shows no results after the update, the second still works OK after updating. If anyone can be bothered to look through these it would be great as I don't know what to look for.

Note that the view that shows no results has two exposed filters, but the view is set to show all results by default (on no input), and in any case the view still shows no results even if you enter something in the exposed filters.

The view that doesn't show any results after the update:

$view = new view();
$view->name = 'clone_of_index';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'taxonomy_term_data';
$view->human_name = 'Clone of Index';
$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'] = 'An online index to Morrissey\'s "Autobiography"';
$handler->display->display_options['css_class'] = 'index';
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['distinct'] = TRUE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Search';
$handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE;
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '50';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['pager']['options']['id'] = '0';
$handler->display->display_options['pager']['options']['quantity'] = '9';
$handler->display->display_options['pager']['options']['expose']['items_per_page'] = TRUE;
$handler->display->display_options['pager']['options']['expose']['items_per_page_options'] = '10, 50';
$handler->display->display_options['pager']['options']['expose']['items_per_page_options_all'] = TRUE;
$handler->display->display_options['style_plugin'] = 'list';
$handler->display->display_options['style_options']['grouping'] = array(
  0 => array(
    'field' => 'name',
    'rendered' => 1,
    'rendered_strip' => 0,
  ),
);
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['inline'] = array(
  'field_page_number' => 'field_page_number',
  'field_page_range' => 'field_page_range',
  'field_photo' => 'field_photo',
);


/* Relationship: Taxonomy term: Representative node */
$handler->display->display_options['relationships']['tid_representative']['id'] = 'tid_representative';
$handler->display->display_options['relationships']['tid_representative']['table'] = 'taxonomy_term_data';
$handler->display->display_options['relationships']['tid_representative']['field'] = 'tid_representative';
$handler->display->display_options['relationships']['tid_representative']['required'] = TRUE;
$handler->display->display_options['relationships']['tid_representative']['subquery_sort'] = 'field_data_field_page_number.field_page_number_value';
$handler->display->display_options['relationships']['tid_representative']['subquery_order'] = 'ASC';
$handler->display->display_options['relationships']['tid_representative']['subquery_view'] = '';
$handler->display->display_options['relationships']['tid_representative']['subquery_namespace'] = '';
/* Relationship: Taxonomy term: Content with term */
$handler->display->display_options['relationships']['nid']['id'] = 'nid';
$handler->display->display_options['relationships']['nid']['table'] = 'taxonomy_index';
$handler->display->display_options['relationships']['nid']['field'] = 'nid';
$handler->display->display_options['relationships']['nid']['required'] = TRUE;
/* Field: Taxonomy term: Index name */
$handler->display->display_options['fields']['field_index_name']['id'] = 'field_index_name';
$handler->display->display_options['fields']['field_index_name']['table'] = 'field_data_field_index_name';
$handler->display->display_options['fields']['field_index_name']['field'] = 'field_index_name';
$handler->display->display_options['fields']['field_index_name']['label'] = '';
$handler->display->display_options['fields']['field_index_name']['exclude'] = TRUE;
$handler->display->display_options['fields']['field_index_name']['element_label_colon'] = FALSE;
/* Field: Taxonomy term: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'taxonomy_term_data';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['exclude'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['text'] = '[field_index_name]';
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['name']['element_type'] = 'strong';
$handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['name']['element_default_classes'] = FALSE;
/* Field: Content: Page number */
$handler->display->display_options['fields']['field_page_number']['id'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['table'] = 'field_data_field_page_number';
$handler->display->display_options['fields']['field_page_number']['field'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_page_number']['label'] = '';
$handler->display->display_options['fields']['field_page_number']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_number']['element_default_classes'] = FALSE;
$handler->display->display_options['fields']['field_page_number']['type'] = 'number_unformatted';
$handler->display->display_options['fields']['field_page_number']['settings'] = array(
  'thousand_separator' => ' ',
  'prefix_suffix' => 1,
);
/* Field: Content: Page range */
$handler->display->display_options['fields']['field_page_range']['id'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['table'] = 'field_data_field_page_range';
$handler->display->display_options['fields']['field_page_range']['field'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_page_range']['label'] = '';
$handler->display->display_options['fields']['field_page_range']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_page_range']['alter']['text'] = '- [field_page_range-to]';
$handler->display->display_options['fields']['field_page_range']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_range']['click_sort_column'] = 'from';
$handler->display->display_options['fields']['field_page_range']['settings'] = array(
  'range_separator' => '-',
  'thousand_separator' => ' ',
  'range_combine' => 0,
  'from_prefix_suffix' => 1,
  'to_prefix_suffix' => 1,
);
/* Field: Content: Photo */
$handler->display->display_options['fields']['field_photo']['id'] = 'field_photo';
$handler->display->display_options['fields']['field_photo']['table'] = 'field_data_field_photo';
$handler->display->display_options['fields']['field_photo']['field'] = 'field_photo';
$handler->display->display_options['fields']['field_photo']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_photo']['label'] = '';
$handler->display->display_options['fields']['field_photo']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_photo']['alter']['text'] = '[field_photo]';
$handler->display->display_options['fields']['field_photo']['element_label_colon'] = FALSE;
/* Sort criterion: Taxonomy term: Index name (field_index_name) */
$handler->display->display_options['sorts']['field_index_name_value']['id'] = 'field_index_name_value';
$handler->display->display_options['sorts']['field_index_name_value']['table'] = 'field_data_field_index_name';
$handler->display->display_options['sorts']['field_index_name_value']['field'] = 'field_index_name_value';
/* Sort criterion: Content: Page number (field_page_number) */
$handler->display->display_options['sorts']['field_page_number_value']['id'] = 'field_page_number_value';
$handler->display->display_options['sorts']['field_page_number_value']['table'] = 'field_data_field_page_number';
$handler->display->display_options['sorts']['field_page_number_value']['field'] = 'field_page_number_value';
$handler->display->display_options['sorts']['field_page_number_value']['relationship'] = 'nid';
/* Filter criterion: Taxonomy term: Name */
$handler->display->display_options['filters']['name']['id'] = 'name';
$handler->display->display_options['filters']['name']['table'] = 'taxonomy_term_data';
$handler->display->display_options['filters']['name']['field'] = 'name';
$handler->display->display_options['filters']['name']['operator'] = 'contains';
$handler->display->display_options['filters']['name']['exposed'] = TRUE;
$handler->display->display_options['filters']['name']['expose']['operator_id'] = 'name_op';
$handler->display->display_options['filters']['name']['expose']['label'] = 'Search for a subject, person or place';
$handler->display->display_options['filters']['name']['expose']['use_operator'] = TRUE;
$handler->display->display_options['filters']['name']['expose']['operator'] = 'name_op';
$handler->display->display_options['filters']['name']['expose']['identifier'] = 'name';
$handler->display->display_options['filters']['name']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: Taxonomy term: Index name (field_index_name) */
$handler->display->display_options['filters']['field_index_name_value']['id'] = 'field_index_name_value';
$handler->display->display_options['filters']['field_index_name_value']['table'] = 'field_data_field_index_name';
$handler->display->display_options['filters']['field_index_name_value']['field'] = 'field_index_name_value';
$handler->display->display_options['filters']['field_index_name_value']['operator'] = 'starts';
$handler->display->display_options['filters']['field_index_name_value']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_index_name_value']['expose']['operator_id'] = 'field_index_name_value_op';
$handler->display->display_options['filters']['field_index_name_value']['expose']['use_operator'] = TRUE;
$handler->display->display_options['filters']['field_index_name_value']['expose']['operator'] = 'field_index_name_value_op';
$handler->display->display_options['filters']['field_index_name_value']['expose']['identifier'] = 'field_index_name_value';
$handler->display->display_options['filters']['field_index_name_value']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['defaults']['access'] = FALSE;
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
  3 => '3',
);
$handler->display->display_options['defaults']['header'] = FALSE;
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Taxonomy vocabulary: Name */
$handler->display->display_options['fields']['name_1']['id'] = 'name_1';
$handler->display->display_options['fields']['name_1']['table'] = 'taxonomy_vocabulary';
$handler->display->display_options['fields']['name_1']['field'] = 'name';
$handler->display->display_options['fields']['name_1']['label'] = '';
$handler->display->display_options['fields']['name_1']['exclude'] = TRUE;
$handler->display->display_options['fields']['name_1']['element_label_colon'] = FALSE;
/* Field: Taxonomy term: Index name */
$handler->display->display_options['fields']['field_index_name']['id'] = 'field_index_name';
$handler->display->display_options['fields']['field_index_name']['table'] = 'field_data_field_index_name';
$handler->display->display_options['fields']['field_index_name']['field'] = 'field_index_name';
$handler->display->display_options['fields']['field_index_name']['label'] = '';
$handler->display->display_options['fields']['field_index_name']['exclude'] = TRUE;
$handler->display->display_options['fields']['field_index_name']['element_label_colon'] = FALSE;
/* Field: Taxonomy term: Name */
$handler->display->display_options['fields']['name']['id'] = 'name';
$handler->display->display_options['fields']['name']['table'] = 'taxonomy_term_data';
$handler->display->display_options['fields']['name']['field'] = 'name';
$handler->display->display_options['fields']['name']['label'] = '';
$handler->display->display_options['fields']['name']['exclude'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['name']['alter']['text'] = '[field_index_name] ';
$handler->display->display_options['fields']['name']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['name']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['name']['element_type'] = 'strong';
$handler->display->display_options['fields']['name']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['name']['element_default_classes'] = FALSE;
/* Field: Content: Page number */
$handler->display->display_options['fields']['field_page_number']['id'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['table'] = 'field_data_field_page_number';
$handler->display->display_options['fields']['field_page_number']['field'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_page_number']['label'] = '';
$handler->display->display_options['fields']['field_page_number']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_number']['element_default_classes'] = FALSE;
$handler->display->display_options['fields']['field_page_number']['type'] = 'number_unformatted';
$handler->display->display_options['fields']['field_page_number']['settings'] = array(
  'thousand_separator' => ' ',
  'prefix_suffix' => 1,
);
/* Field: Content: Page range */
$handler->display->display_options['fields']['field_page_range']['id'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['table'] = 'field_data_field_page_range';
$handler->display->display_options['fields']['field_page_range']['field'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_page_range']['label'] = '';
$handler->display->display_options['fields']['field_page_range']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_page_range']['alter']['text'] = '- [field_page_range-to]';
$handler->display->display_options['fields']['field_page_range']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_range']['click_sort_column'] = 'from';
$handler->display->display_options['fields']['field_page_range']['settings'] = array(
  'range_separator' => '-',
  'thousand_separator' => ' ',
  'range_combine' => 0,
  'from_prefix_suffix' => 1,
  'to_prefix_suffix' => 1,
);
/* Field: Content: Photo */
$handler->display->display_options['fields']['field_photo']['id'] = 'field_photo';
$handler->display->display_options['fields']['field_photo']['table'] = 'field_data_field_photo';
$handler->display->display_options['fields']['field_photo']['field'] = 'field_photo';
$handler->display->display_options['fields']['field_photo']['relationship'] = 'nid';
$handler->display->display_options['fields']['field_photo']['label'] = '';
$handler->display->display_options['fields']['field_photo']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_photo']['alter']['text'] = '[field_photo]';
$handler->display->display_options['fields']['field_photo']['element_label_colon'] = FALSE;
$handler->display->display_options['path'] = 'indexclone';
$handler->display->display_options['menu']['title'] = 'Main index';
$handler->display->display_options['menu']['weight'] = '0';
$handler->display->display_options['menu']['name'] = 'main-menu';
$handler->display->display_options['menu']['context'] = 0;
$handler->display->display_options['menu']['context_only_inline'] = 0;

The view that is unaffected by the update (results still show):

$view = new view();
$view->name = 'pages_done';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Pages done';
$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'] = 'Pages admin';
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
  3 => '3',
);
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Search';
$handler->display->display_options['exposed_form']['options']['reset_button'] = TRUE;
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['inline'] = array(
  'title' => 'title',
  'field_page_number' => 'field_page_number',
  'edit_node' => 'edit_node',
);
/* Field: Content: Page range */
$handler->display->display_options['fields']['field_page_range']['id'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['table'] = 'field_data_field_page_range';
$handler->display->display_options['fields']['field_page_range']['field'] = 'field_page_range';
$handler->display->display_options['fields']['field_page_range']['label'] = '';
$handler->display->display_options['fields']['field_page_range']['exclude'] = TRUE;
$handler->display->display_options['fields']['field_page_range']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_range']['click_sort_column'] = 'from';
$handler->display->display_options['fields']['field_page_range']['settings'] = array(
  'range_separator' => '-',
  'thousand_separator' => ' ',
  'range_combine' => 0,
  'from_prefix_suffix' => 1,
  'to_prefix_suffix' => 1,
);
/* Field: Content: Page number */
$handler->display->display_options['fields']['field_page_number']['id'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['table'] = 'field_data_field_page_number';
$handler->display->display_options['fields']['field_page_number']['field'] = 'field_page_number';
$handler->display->display_options['fields']['field_page_number']['label'] = 'Page';
$handler->display->display_options['fields']['field_page_number']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_page_number']['alter']['text'] = '[field_page_number-value] [field_page_range]';
$handler->display->display_options['fields']['field_page_number']['element_type'] = 'strong';
$handler->display->display_options['fields']['field_page_number']['element_label_type'] = 'strong';
$handler->display->display_options['fields']['field_page_number']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_page_number']['settings'] = array(
  'thousand_separator' => ' ',
  'prefix_suffix' => 1,
);
$handler->display->display_options['fields']['field_page_number']['delta_offset'] = '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']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
/* Field: Content: Edit link */
$handler->display->display_options['fields']['edit_node']['id'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['table'] = 'views_entity_node';
$handler->display->display_options['fields']['edit_node']['field'] = 'edit_node';
$handler->display->display_options['fields']['edit_node']['label'] = '';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['edit_node']['alter']['text'] = '(edit)';
$handler->display->display_options['fields']['edit_node']['element_label_colon'] = FALSE;
/* Field: Content: All taxonomy terms */
$handler->display->display_options['fields']['term_node_tid']['id'] = 'term_node_tid';
$handler->display->display_options['fields']['term_node_tid']['table'] = 'node';
$handler->display->display_options['fields']['term_node_tid']['field'] = 'term_node_tid';
$handler->display->display_options['fields']['term_node_tid']['label'] = '';
$handler->display->display_options['fields']['term_node_tid']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['term_node_tid']['element_wrapper_class'] = 'admin-list';
$handler->display->display_options['fields']['term_node_tid']['vocabularies'] = array(
  'morrissey_detailed' => 0,
  'morrissey_main' => 0,
  'people' => 0,
  'subjects' => 0,
);
/* Sort criterion: Content: Page number (field_page_number) */
$handler->display->display_options['sorts']['field_page_number_value']['id'] = 'field_page_number_value';
$handler->display->display_options['sorts']['field_page_number_value']['table'] = 'field_data_field_page_number';
$handler->display->display_options['sorts']['field_page_number_value']['field'] = 'field_page_number_value';
$handler->display->display_options['sorts']['field_page_number_value']['order'] = 'DESC';
/* Filter criterion: Content: Page number (field_page_number) */
$handler->display->display_options['filters']['field_page_number_value']['id'] = 'field_page_number_value';
$handler->display->display_options['filters']['field_page_number_value']['table'] = 'field_data_field_page_number';
$handler->display->display_options['filters']['field_page_number_value']['field'] = 'field_page_number_value';
$handler->display->display_options['filters']['field_page_number_value']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_page_number_value']['expose']['operator_id'] = 'field_page_number_value_op';
$handler->display->display_options['filters']['field_page_number_value']['expose']['label'] = 'Page number(s)';
$handler->display->display_options['filters']['field_page_number_value']['expose']['use_operator'] = TRUE;
$handler->display->display_options['filters']['field_page_number_value']['expose']['operator'] = 'field_page_number_value_op';
$handler->display->display_options['filters']['field_page_number_value']['expose']['identifier'] = 'field_page_number_value';
$handler->display->display_options['filters']['field_page_number_value']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
/* Filter criterion: Content: Page range range filter */
$handler->display->display_options['filters']['field_page_range']['id'] = 'field_page_range';
$handler->display->display_options['filters']['field_page_range']['table'] = 'field_data_field_page_range';
$handler->display->display_options['filters']['field_page_range']['field'] = 'field_page_range';
$handler->display->display_options['filters']['field_page_range']['exposed'] = TRUE;
$handler->display->display_options['filters']['field_page_range']['expose']['operator_id'] = 'field_page_range_op';
$handler->display->display_options['filters']['field_page_range']['expose']['label'] = 'Page range';
$handler->display->display_options['filters']['field_page_range']['expose']['operator'] = 'field_page_range_op';
$handler->display->display_options['filters']['field_page_range']['expose']['identifier'] = 'field_page_range';
$handler->display->display_options['filters']['field_page_range']['expose']['remember_roles'] = array(
  2 => '2',
  1 => 0,
  3 => 0,
);
$handler->display->display_options['filters']['field_page_range']['include_endpoints'] = 1;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'pages-admin';
$handler->display->display_options['menu']['type'] = 'normal';
$handler->display->display_options['menu']['title'] = 'Pages admin';
$handler->display->display_options['menu']['weight'] = '0';
$handler->display->display_options['menu']['name'] = 'main-menu';
$handler->display->display_options['menu']['context'] = 0;
$handler->display->display_options['menu']['context_only_inline'] = 0;

Comments

ThuleNB’s picture

Hey! I am facing the same issue. Did you already find a reason for this or even a solution?