Hi,

I'm having a conflict with the "search : search terms" exposed filter in views. Before adding views slideshow to my module list, everything was working. After, getting this error :

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'n.type' in 'where clause'
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'n.type' in 'where clause'

Obviously, using the search from the exposed filter always render no results even if they are.

Thanks for the help.

Comments

Aporie created an issue. See original summary.

nickdickinsonwilde’s picture

Status: Active » Postponed (maintainer needs more info)

hmmm without more details I can't say exactly what the problem is. However I'm pretty confident that Views Slideshow is not responsible. That doesn't mean, that views slideshow isn't doing something that is meaning you get the error, but as it does no direct changes to the sql, it isn't in itself responsible if that makes sense.
With more data I could try to debug but currently, not very well; if you're still stuck with it, please give me the version of Views Search and the configuration of the view that is giving the error.
Regards

aporie’s picture

Hi NickWild,

I'm getting this error with all my views which have "search terms" widget exposed.

When I disable views slideshow everything works again, so I was thinking the problem should probably comes from the module.

For exemple, here a view configuration (with views 7.x-3.16)

$view = new view();
$view->name = 'list_of_patient';
$view->description = 'Provide a list of patient.';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'List of patient (All)';
$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'] = 'Find a patient';
$handler->display->display_options['use_ajax'] = TRUE;
$handler->display->display_options['use_more_always'] = FALSE;
$handler->display->display_options['access']['type'] = 'perm';
$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']['reset_button'] = TRUE;
$handler->display->display_options['pager']['type'] = 'infinite_scroll';
$handler->display->display_options['pager']['options']['manual_load'] = 1;
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['style_plugin'] = 'table';
$handler->display->display_options['style_options']['columns'] = array(
  'nid' => 'nid',
  'title' => 'title',
  'field_patient_age' => 'field_patient_age',
  'field_patient_address_thoroughfare' => 'field_patient_address_thoroughfare',
  'field_patient_address_postal_code' => 'field_patient_address_postal_code',
  'field_patient_address_locality' => 'field_patient_address_locality',
  'field_patient_address_data' => 'field_patient_address_data',
  'field_patient_mail' => 'field_patient_mail',
  'edit_node' => 'edit_node',
  'nothing' => 'nothing',
);
$handler->display->display_options['style_options']['default'] = '-1';
$handler->display->display_options['style_options']['info'] = array(
  'nid' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'title' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_age' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_address_thoroughfare' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_address_postal_code' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_address_locality' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_address_data' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'field_patient_mail' => array(
    'sortable' => 0,
    'default_sort_order' => 'asc',
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
  'edit_node' => array(
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 1,
  ),
  'nothing' => array(
    'align' => 'views-align-center',
    'separator' => '',
    'empty_column' => 0,
  ),
);
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
/* Field: Content: Nid */
$handler->display->display_options['fields']['nid']['id'] = 'nid';
$handler->display->display_options['fields']['nid']['table'] = 'node';
$handler->display->display_options['fields']['nid']['field'] = 'nid';
$handler->display->display_options['fields']['nid']['label'] = '';
$handler->display->display_options['fields']['nid']['exclude'] = TRUE;
$handler->display->display_options['fields']['nid']['element_label_colon'] = FALSE;
/* Field: Patient:Name */
$handler->display->display_options['fields']['title_1']['id'] = 'title_1';
$handler->display->display_options['fields']['title_1']['table'] = 'node';
$handler->display->display_options['fields']['title_1']['field'] = 'title';
$handler->display->display_options['fields']['title_1']['ui_name'] = 'Patient:Name';
$handler->display->display_options['fields']['title_1']['label'] = '';
$handler->display->display_options['fields']['title_1']['exclude'] = TRUE;
$handler->display->display_options['fields']['title_1']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title_1']['link_to_node'] = FALSE;
/* 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'] = 'Full Name';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
/* Field: Content: Age */
$handler->display->display_options['fields']['field_patient_age']['id'] = 'field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['table'] = 'field_data_field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['field'] = 'field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_patient_age']['alter']['text'] = '[field_patient_age] y-old';
/* Field: Content: Address - Thoroughfare (i.e. Street address) */
$handler->display->display_options['fields']['field_patient_address_thoroughfare']['id'] = 'field_patient_address_thoroughfare';
$handler->display->display_options['fields']['field_patient_address_thoroughfare']['table'] = 'field_data_field_patient_address';
$handler->display->display_options['fields']['field_patient_address_thoroughfare']['field'] = 'field_patient_address_thoroughfare';
$handler->display->display_options['fields']['field_patient_address_thoroughfare']['label'] = 'Street address';
/* Field: Content: Address - Postal code */
$handler->display->display_options['fields']['field_patient_address_postal_code']['id'] = 'field_patient_address_postal_code';
$handler->display->display_options['fields']['field_patient_address_postal_code']['table'] = 'field_data_field_patient_address';
$handler->display->display_options['fields']['field_patient_address_postal_code']['field'] = 'field_patient_address_postal_code';
$handler->display->display_options['fields']['field_patient_address_postal_code']['label'] = 'Postal code';
/* Field: Content: Address - Locality (i.e. City) */
$handler->display->display_options['fields']['field_patient_address_locality']['id'] = 'field_patient_address_locality';
$handler->display->display_options['fields']['field_patient_address_locality']['table'] = 'field_data_field_patient_address';
$handler->display->display_options['fields']['field_patient_address_locality']['field'] = 'field_patient_address_locality';
$handler->display->display_options['fields']['field_patient_address_locality']['label'] = 'City';
/* Field: Content: Address with phone number */
$handler->display->display_options['fields']['field_patient_address_data']['id'] = 'field_patient_address_data';
$handler->display->display_options['fields']['field_patient_address_data']['table'] = 'field_data_field_patient_address';
$handler->display->display_options['fields']['field_patient_address_data']['field'] = 'field_patient_address_data';
$handler->display->display_options['fields']['field_patient_address_data']['label'] = 'Mobile phone';
$handler->display->display_options['fields']['field_patient_address_data']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_patient_address_data']['selected_phone_type'] = '3';
/* Field: Content: E-mail */
$handler->display->display_options['fields']['field_patient_mail']['id'] = 'field_patient_mail';
$handler->display->display_options['fields']['field_patient_mail']['table'] = 'field_data_field_patient_mail';
$handler->display->display_options['fields']['field_patient_mail']['field'] = 'field_patient_mail';
/* 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'] = 'Edit patient sheet';
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['edit_node']['alter']['alt'] = 'Edit Patient Sheet';
$handler->display->display_options['fields']['edit_node']['alter']['link_class'] = 'btn btn-primary';
$handler->display->display_options['fields']['edit_node']['hide_empty'] = TRUE;
$handler->display->display_options['fields']['edit_node']['text'] = 'Edit';
/* Field: Global: Custom text */
$handler->display->display_options['fields']['nothing']['id'] = 'nothing';
$handler->display->display_options['fields']['nothing']['table'] = 'views';
$handler->display->display_options['fields']['nothing']['field'] = 'nothing';
$handler->display->display_options['fields']['nothing']['label'] = 'Appointment';
$handler->display->display_options['fields']['nothing']['alter']['text'] = '<a href="/node/add/appointment-request?field_appointment_patient=[nid]&edit%5Btitle%5D=An Appointment for [title_1]&destination=/dashboard" class="btn btn-secondary">Request</a>';
$handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['nothing']['alter']['alt'] = 'Request an Appointment';
/* Sort criterion: Content: Title */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
$handler->display->display_options['sorts']['title']['order'] = 'DESC';
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
  'patient_sheet' => 'patient_sheet',
);
/* Filter criterion: Content: Title */
$handler->display->display_options['filters']['title']['id'] = 'title';
$handler->display->display_options['filters']['title']['table'] = 'node';
$handler->display->display_options['filters']['title']['field'] = 'title';
$handler->display->display_options['filters']['title']['operator'] = 'contains';
$handler->display->display_options['filters']['title']['exposed'] = TRUE;
$handler->display->display_options['filters']['title']['expose']['operator_id'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['label'] = 'Full name';
$handler->display->display_options['filters']['title']['expose']['description'] = 'Search by Full Name';
$handler->display->display_options['filters']['title']['expose']['operator'] = 'title_op';
$handler->display->display_options['filters']['title']['expose']['identifier'] = 'title';
$handler->display->display_options['filters']['title']['expose']['remember_roles'] = array(
  2 => '2',
  3 => 0,
  7 => 0,
  9 => 0,
  4 => 0,
  6 => 0,
  8 => 0,
  5 => 0,
  1 => 0,
);
$handler->display->display_options['filters']['title']['expose']['autocomplete_filter'] = 1;
$handler->display->display_options['filters']['title']['expose']['autocomplete_items'] = '10';
$handler->display->display_options['filters']['title']['expose']['autocomplete_min_chars'] = '0';
$handler->display->display_options['filters']['title']['expose']['autocomplete_field'] = 'title';
$handler->display->display_options['filters']['title']['expose']['autocomplete_raw_suggestion'] = 1;
$handler->display->display_options['filters']['title']['expose']['autocomplete_raw_dropdown'] = 1;
$handler->display->display_options['filters']['title']['expose']['autocomplete_dependent'] = 1;
/* Filter criterion: Search: Search Terms */
$handler->display->display_options['filters']['keys']['id'] = 'keys';
$handler->display->display_options['filters']['keys']['table'] = 'search_index';
$handler->display->display_options['filters']['keys']['field'] = 'keys';
$handler->display->display_options['filters']['keys']['exposed'] = TRUE;
$handler->display->display_options['filters']['keys']['expose']['operator_id'] = 'keys_op';
$handler->display->display_options['filters']['keys']['expose']['label'] = 'Search Terms';
$handler->display->display_options['filters']['keys']['expose']['operator'] = 'keys_op';
$handler->display->display_options['filters']['keys']['expose']['identifier'] = 'keys';
$handler->display->display_options['filters']['keys']['expose']['remember_roles'] = array(
  2 => '2',
  3 => 0,
  7 => 0,
  10 => 0,
  9 => 0,
  4 => 0,
  6 => 0,
  11 => 0,
  12 => 0,
  8 => 0,
  5 => 0,
  1 => 0,
);

/* Display: Hsrehab_admin:Page */
$handler = $view->new_display('page', 'Hsrehab_admin:Page', 'page');
$handler->display->display_options['path'] = 'patient-list';

/* Display: Client:Block */
$handler = $view->new_display('block', 'Client:Block', 'block_1');
$handler->display->display_options['defaults']['title'] = FALSE;
$handler->display->display_options['title'] = 'Your Patients';
$handler->display->display_options['defaults']['access'] = FALSE;
$handler->display->display_options['access']['type'] = 'role';
$handler->display->display_options['access']['role'] = array(
  11 => '11',
  12 => '12',
  6 => '6',
  8 => '8',
);
$handler->display->display_options['defaults']['empty'] = FALSE;
/* No results behavior: Global: Text area */
$handler->display->display_options['empty']['area']['id'] = 'area';
$handler->display->display_options['empty']['area']['table'] = 'views';
$handler->display->display_options['empty']['area']['field'] = 'area';
$handler->display->display_options['empty']['area']['label'] = 'No Patient Found';
$handler->display->display_options['empty']['area']['empty'] = TRUE;
$handler->display->display_options['empty']['area']['content'] = '<h3>No Patient Found</h3>
<p>You don\'t have created any Patient Sheet yet.</p>
<div class="btn btn-primary"><a href="/node/add/patient-sheet">Create Patient Sheet</a></div>
';
$handler->display->display_options['empty']['area']['format'] = 'full_html';
$handler->display->display_options['defaults']['fields'] = FALSE;
/* Field: Content: Nid */
$handler->display->display_options['fields']['nid']['id'] = 'nid';
$handler->display->display_options['fields']['nid']['table'] = 'node';
$handler->display->display_options['fields']['nid']['field'] = 'nid';
$handler->display->display_options['fields']['nid']['label'] = '';
$handler->display->display_options['fields']['nid']['exclude'] = TRUE;
$handler->display->display_options['fields']['nid']['element_label_colon'] = FALSE;
/* Field: Patient:Name */
$handler->display->display_options['fields']['title_1']['id'] = 'title_1';
$handler->display->display_options['fields']['title_1']['table'] = 'node';
$handler->display->display_options['fields']['title_1']['field'] = 'title';
$handler->display->display_options['fields']['title_1']['ui_name'] = 'Patient:Name';
$handler->display->display_options['fields']['title_1']['label'] = '';
$handler->display->display_options['fields']['title_1']['exclude'] = TRUE;
$handler->display->display_options['fields']['title_1']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title_1']['link_to_node'] = FALSE;
/* 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'] = 'Full Name';
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = FALSE;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = FALSE;
/* Field: Content: Age */
$handler->display->display_options['fields']['field_patient_age']['id'] = 'field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['table'] = 'field_data_field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['field'] = 'field_patient_age';
$handler->display->display_options['fields']['field_patient_age']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['field_patient_age']['alter']['text'] = '[field_patient_age] y-old';
/* Field: Content: Area of injury */
$handler->display->display_options['fields']['field_patient_area_of_injury']['id'] = 'field_patient_area_of_injury';
$handler->display->display_options['fields']['field_patient_area_of_injury']['table'] = 'field_data_field_patient_area_of_injury';
$handler->display->display_options['fields']['field_patient_area_of_injury']['field'] = 'field_patient_area_of_injury';
$handler->display->display_options['fields']['field_patient_area_of_injury']['settings'] = array(
  'bypass_access' => 0,
  'link' => 0,
);
$handler->display->display_options['fields']['field_patient_area_of_injury']['delta_offset'] = '0';
/* Field: Content: Brief description of the injury */
$handler->display->display_options['fields']['field_patient_descrip_injury']['id'] = 'field_patient_descrip_injury';
$handler->display->display_options['fields']['field_patient_descrip_injury']['table'] = 'field_data_field_patient_descrip_injury';
$handler->display->display_options['fields']['field_patient_descrip_injury']['field'] = 'field_patient_descrip_injury';
$handler->display->display_options['fields']['field_patient_descrip_injury']['type'] = 'text_trimmed';
$handler->display->display_options['fields']['field_patient_descrip_injury']['settings'] = array(
  'trim_length' => '600',
);
/* Field: Content: Address with phone number */
$handler->display->display_options['fields']['field_patient_address_data']['id'] = 'field_patient_address_data';
$handler->display->display_options['fields']['field_patient_address_data']['table'] = 'field_data_field_patient_address';
$handler->display->display_options['fields']['field_patient_address_data']['field'] = 'field_patient_address_data';
$handler->display->display_options['fields']['field_patient_address_data']['label'] = 'Mobile phone';
$handler->display->display_options['fields']['field_patient_address_data']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_patient_address_data']['selected_phone_type'] = '3';
/* Field: Content: E-mail */
$handler->display->display_options['fields']['field_patient_mail']['id'] = 'field_patient_mail';
$handler->display->display_options['fields']['field_patient_mail']['table'] = 'field_data_field_patient_mail';
$handler->display->display_options['fields']['field_patient_mail']['field'] = 'field_patient_mail';
/* 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'] = 'Edit patient sheet';
$handler->display->display_options['fields']['edit_node']['alter']['alter_text'] = TRUE;
$handler->display->display_options['fields']['edit_node']['alter']['text'] = '<a href="/node/[nid]/edit?destination=/dashboard" class="btn btn-primary">Edit</a>';
$handler->display->display_options['fields']['edit_node']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['edit_node']['alter']['alt'] = 'Edit Patient Sheet';
$handler->display->display_options['fields']['edit_node']['hide_empty'] = TRUE;
/* Field: Global: Custom text */
$handler->display->display_options['fields']['nothing']['id'] = 'nothing';
$handler->display->display_options['fields']['nothing']['table'] = 'views';
$handler->display->display_options['fields']['nothing']['field'] = 'nothing';
$handler->display->display_options['fields']['nothing']['label'] = 'Appointment';
$handler->display->display_options['fields']['nothing']['alter']['text'] = '<a href="/node/add/appointment-request?field_appointment_patient=[nid]&edit%5Btitle%5D=An Appointment for [title_1]&destination=/dashboard" class="btn btn-secondary">Request</a>';
$handler->display->display_options['fields']['nothing']['alter']['make_link'] = TRUE;
$handler->display->display_options['fields']['nothing']['alter']['alt'] = 'Request an Appointment';
$handler->display->display_options['defaults']['arguments'] = FALSE;
/* Contextual filter: Content: Author uid */
$handler->display->display_options['arguments']['uid']['id'] = 'uid';
$handler->display->display_options['arguments']['uid']['table'] = 'node';
$handler->display->display_options['arguments']['uid']['field'] = 'uid';
$handler->display->display_options['arguments']['uid']['default_action'] = 'default';
$handler->display->display_options['arguments']['uid']['default_argument_type'] = 'current_user';
$handler->display->display_options['arguments']['uid']['summary']['number_of_records'] = '0';
$handler->display->display_options['arguments']['uid']['summary']['format'] = 'default_summary';
$handler->display->display_options['arguments']['uid']['summary_options']['items_per_page'] = '25';
$handler->display->display_options['block_description'] = 'Patient List (Company, Net Company, Dashboard)';
nickdickinsonwilde’s picture

Status: Postponed (maintainer needs more info) » Active

Hmm that is very odd and I'll definitely try to debug it. What version of views and Drupal are you using?
Thanks for the report and further details.
Nick

nickdickinsonwilde’s picture

Assigned: Unassigned » nickdickinsonwilde
Status: Active » Needs work
aporie’s picture

So, drupal 7.54 and views 7.x-3.16.

I think trying to reproduce the error on a fresh install should be a great start. The way I found the problem comes from view slideshow is that I put a backup on my dev server and firgured which modules wasn't still install compared to the prod server, because it used to work.

Then I figured that views slideshow wasn't installed and when I installed it, search term widget from views stop working ...

Thanks for your help, drupal rocks !

nickdickinsonwilde’s picture

hmmph. Well I've messed around a bit and haven't been able to replicate it so far unfortunately.
From the views config, I'm guessing that the site likely has privacy issues to consider so you probably can't send me a copy of the db for further testing? Do you have a base testing setup that you could send me that doesn't have private data?
If not, what other modules do you have active?
Thanks;
Nick

aporie’s picture

I sent you a mail with further informations.

Thanks

aporie’s picture

Status: Needs work » Closed (won't fix)

I'm Sooooo sorry.

I know what was the problem and thinking it was views slideshow was just a coincidence.

When I activated views slideshow it makes drupal reach the php var limit.

So to solve the problem I had to put in my php.ini :

max_input_vars = 10000

Sorry for disturbance ... and thanks a lot for your work.