Everything was working great, but then I got rid of a bunch of my old profile values, and restructured my views to filter on content_profile fields. The views work great, but my finder is broken. I rebuilt EVERYTHING from scratch; new content_profile fields, new view, new finder, even uninstalled (not just disabled) finder and reactivated, but I still get the following error. I am so frustrated! It was working perfectly. 

user warning: Column 'field_hospital_value' in field list is ambiguous query: SELECT users.uid AS uid, users.picture AS users_picture, users.name AS users_name, realname.realname AS realname_realname, realname.uid AS realname_uid, profile_values_profile_firstname.value AS profile_values_profile_firstname_value, profile_values_profile_firstname.uid AS profile_values_profile_firstname_uid, profile_values_profile_lastname.value AS profile_values_profile_lastname_value, profile_values_profile_lastname.uid AS profile_values_profile_lastname_uid, users.mail AS users_mail, field_hospital_value, nid, type, vid FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'profile_about_me' LEFT JOIN users_roles users_roles ON users.uid = users_roles.uid AND users_roles.rid = 8 LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_0 ON node_users.vid = node_data_field_deparment_value_0.vid AND node_data_field_deparment_value_0.field_deparment_value = '61' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_1 ON node_users.vid = node_data_field_deparment_value_1.vid AND node_data_field_deparment_value_1.field_deparment_value = '44' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_2 ON node_users.vid = node_data_field_deparment_value_2.vid AND node_data_field_deparment_value_2.field_deparment_value = '39' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_3 ON node_users.vid = node_data_field_deparment_value_3.vid AND node_data_field_deparment_value_3.field_deparment_value = '46' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_4 ON node_users.vid = node_data_field_deparment_value_4.vid AND node_data_field_deparment_value_4.field_deparment_value = '43' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_5 ON node_users.vid = node_data_field_deparment_value_5.vid AND node_data_field_deparment_value_5.field_deparment_value = '38' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_6 ON node_users.vid = node_data_field_deparment_value_6.vid AND node_data_field_deparment_value_6.field_deparment_value = '37' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_7 ON node_users.vid = node_data_field_deparment_value_7.vid AND node_data_field_deparment_value_7.field_deparment_value = '40' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_8 ON node_users.vid = node_data_field_deparment_value_8.vid AND node_data_field_deparment_value_8.field_deparment_value = '42' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_9 ON node_users.vid = node_data_field_deparment_value_9.vid AND node_data_field_deparment_value_9.field_deparment_value = '41' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_10 ON node_users.vid = node_data_field_deparment_value_10.vid AND node_data_field_deparment_value_10.field_deparment_value = '45' LEFT JOIN content_type_profile_about_me node_data_field_deparment_value_11 ON node_users.vid = node_data_field_deparment_value_11.vid AND node_data_field_deparment_value_11.field_deparment_value = '36' LEFT JOIN content_type_profile_about_me node_data_field_job_title_value_0 ON node_users.vid = node_data_field_job_title_value_0.vid AND node_data_field_job_title_value_0.field_job_title_value = '64' LEFT JOIN content_type_profile_about_me node_data_field_job_title_value_1 ON node_users.vid = node_data_field_job_title_value_1.vid AND node_data_field_job_title_value_1.field_job_title_value = '65' LEFT JOIN content_type_profile_about_me node_data_field_job_title_value_2 ON node_users.vid = node_data_field_job_title_value_2.vid AND node_data_field_job_title_value_2.field_job_title_value = '63' LEFT JOIN content_type_profile_about_me node_data_field_job_title_value_3 ON node_users.vid = node_data_field_job_title_value_3.vid AND node_data_field_job_title_value_3.field_job_title_value = '66' LEFT JOIN content_type_profile_about_me node_data_field_job_title_value_4 ON node_users.vid = node_data_field_job_title_value_4.vid AND node_data_field_job_title_value_4.field_job_title_value = '62' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_0 ON node_users.vid = node_data_field_hospital_value_0.vid AND node_data_field_hospital_value_0.field_hospital_value = '11' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_1 ON node_users.vid = node_data_field_hospital_value_1.vid AND node_data_field_hospital_value_1.field_hospital_value = '20' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_2 ON node_users.vid = node_data_field_hospital_value_2.vid AND node_data_field_hospital_value_2.field_hospital_value = '22' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_3 ON node_users.vid = node_data_field_hospital_value_3.vid AND node_data_field_hospital_value_3.field_hospital_value = '21' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_4 ON node_users.vid = node_data_field_hospital_value_4.vid AND node_data_field_hospital_value_4.field_hospital_value = '9' LEFT JOIN content_type_profile_about_me node_data_field_hospital_value_5 ON node_users.vid = node_data_field_hospital_value_5.vid AND node_data_field_hospital_value_5.field_hospital_value = '10' LEFT JOIN realname realname ON users.uid = realname.uid LEFT JOIN profile_values profile_values_profile_firstname ON users.uid = profile_values_profile_firstname.uid AND profile_values_profile_firstname.fid = '3' LEFT JOIN profile_values profile_values_profile_lastname ON users.uid = profile_values_profile_lastname.uid AND profile_values_profile_lastname.fid = '2' WHERE (users.status <> 0) AND (users_roles.rid IS NULL) AND (node_data_field_deparment_value_0.field_deparment_value = '61' OR node_data_field_deparment_value_1.field_deparment_value = '44' OR node_data_field_deparment_value_2.field_deparment_value = '39' OR node_data_field_deparment_value_3.field_deparment_value = '46' OR node_data_field_deparment_value_4.field_deparment_value = '43' OR node_data_field_deparment_value_5.field_deparment_value = '38' OR node_data_field_deparment_value_6.field_deparment_value = '37' OR node_data_field_deparment_value_7.field_deparment_value = '40' OR node_data_field_deparment_value_8.field_deparment_value = '42' OR node_data_field_deparment_value_9.field_deparment_value = '41' OR node_data_field_deparment_value_10.field_deparment_value = '45' OR node_data_field_deparment_value_11.field_deparment_value = '36') AND (node_data_field_job_title_value_0.field_job_title_value = '64' OR node_data_field_job_title_value_1.field_job_title_value = '65' OR node_data_field_job_title_value_2.field_job_title_value = '63' OR node_data_field_job_title_value_3.field_job_title_value = '66' OR node_data_field_job_title_value_4.field_job_title_value = '62') AND (node_data_field_hospital_value_0.field_hospital_value = '11' OR node_data_field_hospital_value_1.field_hospital_value = '20' OR node_data_field_hospital_value_2.field_hospital_value = '22' OR node_data_field_hospital_value_3.field_hospital_value = '21' OR node_data_field_hospital_value_4.field_hospital_value = '9' OR node_data_field_hospital_value_5.field_hospital_value = '10') ORDER BY realname_realname ASC in /var/www/vhosts/mybluepearlvet.com/httpdocs/drupal/sites/all/modules/views/includes/view.inc on line 769.

Comments

danielb’s picture

danielb commented

can you please paste an export of your finder here? perhaps your view too?

fidot’s picture

fidot commented

The column 'field_hospital_value' is declared in tables node_data_field_hospital_value_0, node_data_field_hospital_value_1, node_data_field_hospital_value_2, node_data_field_hospital_value_3, node_data_field_hospital_value_4 and node_data_field_hospital_value_5, so the query doesn't know which you mean.

HTH
Terry

davidbessler’s picture

davidbessler commented

Sure. Here's the finder (I actually rebuilt it several times, so it may not be exactly the same, but still produces the error above.

array(   'finder_id' =&gt; '1',   'base' =&gt; 'views',   'title' =&gt; 'Bluepearl Directory',   'description' =&gt; 'Find a Bluepearl member',   'path' =&gt; 'finder/bluepearl-directory',   'block' =&gt; '0',   'settings' =&gt; array(     'form_on_page' =&gt; 1,     'form' =&gt; array(       'prefix' =&gt; '',       'prefix_format' =&gt; '4',       'suffix' =&gt; '',       'suffix_format' =&gt; '4',       'button_text' =&gt; 'Find',       'go_text' =&gt; 'Go',     ),     'advanced' =&gt; array(       'filter' =&gt; 1,       'submission' =&gt; 1,       'ahah' =&gt; 1,       'ahah_effect' =&gt; 'none',       'element_combination' =&gt; '0',       'pager' =&gt; '0',       'match' =&gt; 'contains',       'goto' =&gt; '',       'hide_args' =&gt; 1,       'arg_sep' =&gt; ',',       'show_links' =&gt; 1,       'show_admin_links' =&gt; 1,       'search' =&gt; '0',     ),     'views' =&gt; array(       'view' =&gt; 'directory',       'displays' =&gt; array(         'query' =&gt; 'page_2',         'output' =&gt; 'page_2',       ),       'results' =&gt; '0',       'views_args' =&gt; array(         'args' =&gt; '',         'delimiter' =&gt; '/',       ),     ),   ),   'elements' =&gt; array(     '0' =&gt; array(       'finder_element_id' =&gt; '3',       'finder_id' =&gt; '1',       'element' =&gt; 'autocomplete',       'title' =&gt; 'Name',       'weight' =&gt; '0',       'settings' =&gt; array(         'form' =&gt; array(           'description' =&gt; '',           'prefix' =&gt; '',           'prefix_format' =&gt; '2',           'suffix' =&gt; '',           'suffix_format' =&gt; '2',           'default_value' =&gt; '',           'required' =&gt; 0,           'field_prefix' =&gt; '',           'field_suffix' =&gt; '',           'maxlength' =&gt; '',           'size' =&gt; '',           'max_suggestions' =&gt; '10',           'match' =&gt; 'contains',           'autosubmit' =&gt; 0,         ),         'choices' =&gt; array(           'field' =&gt; array(             'realname.realname' =&gt; 'realname.realname',           ),           'views' =&gt; array(             'args' =&gt; '',             'delimiter' =&gt; '/',           ),           'displays' =&gt; array(             'query' =&gt; 'page_1',           ),         ),       ),       'element_handler' =&gt; array(         '#title' =&gt; 'Autocomplete textfield',         '#module' =&gt; 'finder_autocomplete',       ),       '#_finder_object' =&gt; '1',     ),     '1' =&gt; array(       'finder_element_id' =&gt; '6',       'finder_id' =&gt; '1',       'element' =&gt; 'select',       'title' =&gt; 'Hospital',       'weight' =&gt; '0',       'settings' =&gt; array(         'form' =&gt; array(           'description' =&gt; '',           'prefix' =&gt; '',           'prefix_format' =&gt; '3',           'suffix' =&gt; '',           'suffix_format' =&gt; '4',           'default_value' =&gt; '',           'required' =&gt; 0,           'size' =&gt; '',           'multiple' =&gt; 1,           'empty' =&gt; 'prepend',           'empty_text' =&gt; 'Any',         ),         'choices' =&gt; array(           'field' =&gt; array(             'node_data_field_hospital.field_hospital_value' =&gt; 'node_data_field_hospital.field_hospital_value',           ),           'rewrite' =&gt; array(             'php' =&gt; '',           ),           'views' =&gt; array(             'args' =&gt; '',             'delimiter' =&gt; '/',           ),           'displays' =&gt; array(             'query' =&gt; 'default',           ),         ),       ),       'element_handler' =&gt; array(         '#title' =&gt; 'Select list',         '#module' =&gt; 'finder_optionwidgets',       ),       '#_finder_object' =&gt; '1',     ),   ),   'elements_index' =&gt; array(     '3' =&gt; 0,     '6' =&gt; 1,   ),   'base_handler' =&gt; array(     '#title' =&gt; 'Views finder',     '#module' =&gt; 'finder_views',   ),   'admin_links' =&gt; array(     'finder/bluepearl-directory' =&gt; 'View \&quot;Path\&quot;',     'admin/build/finder/1/edit' =&gt; 'Edit',   ),   'links' =&gt; array(),   '#_finder_object' =&gt; '1', )

Here is the view:

$view = new view; $view->name = 'directory'; $view->description = 'Directory'; $view->tag = ''; $view->view_php = ''; $view->base_table = 'users'; $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('relationships', array( 'content_profile_rel' => array( 'label' => 'Content Profile', 'required' => 0, 'type' => 'personal_profile', 'id' => 'content_profile_rel', 'table' => 'users', 'field' => 'content_profile_rel', 'relationship' => 'none', ), )); $handler->override_option('fields', array( 'picture' => array( 'label' => 'Picture', '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' => 'picture', 'table' => 'users', 'field' => 'picture', 'relationship' => 'none', ), 'realname' => array( 'label' => 'Name', '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_user' => 1, 'overwrite_anonymous' => 0, 'anonymous_text' => '', 'exclude' => 0, 'id' => 'realname', 'table' => 'realname', 'field' => 'realname', 'relationship' => 'none', ), 'value_1' => array( 'label' => 'First Name', '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_user' => 1, 'exclude' => 1, 'id' => 'value_1', 'table' => 'profile_values_profile_firstname', 'field' => 'value', 'relationship' => 'none', ), 'value' => array( 'label' => 'Last name', '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_user' => 1, 'exclude' => 1, 'id' => 'value', 'table' => 'profile_values_profile_lastname', 'field' => 'value', 'relationship' => 'none', ), 'mail' => array( 'label' => 'E-mail', '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_user' => 'user', 'exclude' => 0, 'id' => 'mail', 'table' => 'users', 'field' => 'mail', 'relationship' => 'none', ), )); $handler->override_option('sorts', array( 'realname' => array( 'order' => 'ASC', 'id' => 'realname', 'table' => 'realname', 'field' => 'realname', 'relationship' => 'none', ), )); $handler->override_option('filters', array( 'status' => array( 'operator' => '=', 'value' => '1', 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'status', 'table' => 'users', 'field' => 'status', 'relationship' => 'none', ), 'rid' => array( 'operator' => 'not', 'value' => array( '8' => '8', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => 'rid_op', 'label' => 'User: Roles', 'use_operator' => 0, 'identifier' => 'rid', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'rid', 'table' => 'users_roles', 'field' => 'rid', 'relationship' => 'none', 'reduce_duplicates' => 1, 'override' => array( 'button' => 'Override', ), ), 'field_deparment_value' => array( 'operator' => 'or', 'value' => array( '61' => '61', '44' => '44', '39' => '39', '46' => '46', '43' => '43', '38' => '38', '37' => '37', '40' => '40', '42' => '42', '41' => '41', '45' => '45', '36' => '36', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => 'field_deparment_value_op', 'label' => 'Content: Department (field_deparment)', 'use_operator' => 0, 'identifier' => 'field_deparment_value', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'field_deparment_value', 'table' => 'node_data_field_deparment', 'field' => 'field_deparment_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, ), 'field_job_title_value' => array( 'operator' => 'or', 'value' => array(), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'field_job_title_value', 'table' => 'node_data_field_job_title', 'field' => 'field_job_title_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, ), 'field_hospital_value' => array( 'operator' => 'or', 'value' => array( '20' => '20', '22' => '22', '21' => '21', '9' => '9', '10' => '10', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'field_hospital_value', 'table' => 'node_data_field_hospital', 'field' => 'field_hospital_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, ), )); $handler->override_option('access', array( 'type' => 'role', 'role' => array( '2' => 2, '8' => 8, ), )); $handler->override_option('cache', array( 'type' => 'none', )); $handler->override_option('title', 'Bluepearl Directory'); $handler->override_option('use_ajax', TRUE); $handler->override_option('items_per_page', 0); $handler->override_option('use_pager', '1'); $handler->override_option('style_plugin', 'table'); $handler->override_option('style_options', array( 'grouping' => '', 'override' => 1, 'sticky' => 1, 'order' => 'asc', 'columns' => array( 'picture' => 'picture', 'realname' => 'realname', 'value_1' => 'value_1', 'value' => 'value', 'mail' => 'mail', 'value_2' => 'value_2', ), 'info' => array( 'picture' => array( 'sortable' => 0, 'separator' => '', ), 'realname' => array( 'sortable' => 1, 'separator' => '', ), 'value_1' => array( 'sortable' => 0, 'separator' => ' ', ), 'value' => array( 'sortable' => 0, 'separator' => '', ), 'mail' => array( 'sortable' => 1, 'separator' => '', ), 'value_2' => array( 'sortable' => 1, 'separator' => '', ), ), 'default' => 'value', )); $handler = $view->new_display('page', 'Bluepearl Directory', 'page_1'); $handler->override_option('path', 'directory'); $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, )); $handler = $view->new_display('page', 'Bluepearl Email List with select fields', 'page_2'); $handler->override_option('filters', array( 'status' => array( 'operator' => '=', 'value' => '1', 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => FALSE, 'label' => '', ), 'id' => 'status', 'table' => 'users', 'field' => 'status', 'relationship' => 'none', ), 'rid' => array( 'operator' => 'not', 'value' => array( '8' => '8', ), 'group' => '0', 'exposed' => FALSE, 'expose' => array( 'operator' => 'rid_op', 'label' => 'User: Roles', 'use_operator' => 0, 'identifier' => 'rid', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'rid', 'table' => 'users_roles', 'field' => 'rid', 'relationship' => 'none', 'reduce_duplicates' => 1, 'override' => array( 'button' => 'Override', ), ), 'field_hospital_value' => array( 'operator' => 'or', 'value' => array( '11' => '11', '20' => '20', '22' => '22', '21' => '21', '9' => '9', '10' => '10', ), 'group' => '0', 'exposed' => TRUE, 'expose' => array( 'use_operator' => 0, 'operator' => 'field_hospital_value_op', 'identifier' => 'field_hospital_value', 'label' => 'Hospital', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 1, ), 'id' => 'field_hospital_value', 'table' => 'node_data_field_hospital', 'field' => 'field_hospital_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, 'override' => array( 'button' => 'Use default', ), ), 'field_deparment_value' => array( 'operator' => 'or', 'value' => array(), 'group' => '0', 'exposed' => TRUE, 'expose' => array( 'use_operator' => 0, 'operator' => 'field_deparment_value_op', 'identifier' => 'field_deparment_value', 'label' => 'Department', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'field_deparment_value', 'table' => 'node_data_field_deparment', 'field' => 'field_deparment_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, 'override' => array( 'button' => 'Use default', ), ), 'field_job_title_value' => array( 'operator' => 'or', 'value' => array(), 'group' => '0', 'exposed' => TRUE, 'expose' => array( 'use_operator' => 0, 'operator' => 'field_job_title_value_op', 'identifier' => 'field_job_title_value', 'label' => 'Job Title', 'optional' => 1, 'single' => 0, 'remember' => 0, 'reduce' => 0, ), 'id' => 'field_job_title_value', 'table' => 'node_data_field_job_title', 'field' => 'field_job_title_value', 'relationship' => 'content_profile_rel', 'reduce_duplicates' => 1, 'override' => array( 'button' => 'Use default', ), ), )); $handler->override_option('path', 'blue-pearl-email-list-choces'); $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, ));

Thank you SO very much for your help.

davidbessler’s picture

davidbessler commented

Terry, I searched my database for those values and tables and can't find them anywhere. Where might they be?

davidbessler’s picture

davidbessler commented

With the way it is set up above, this is the error I get:

user warning: Unknown column 'field_hospital_value' in 'field list' query: SELECT users.uid AS uid, users.picture AS users_picture, users.name AS users_name, realname.realname AS realname_realname, realname.uid AS realname_uid, profile_values_profile_firstname.value AS profile_values_profile_firstname_value, profile_values_profile_firstname.uid AS profile_values_profile_firstname_uid, profile_values_profile_lastname.value AS profile_values_profile_lastname_value, profile_values_profile_lastname.uid AS profile_values_profile_lastname_uid, users.mail AS users_mail, field_hospital_value, nid, type, vid FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'personal_profile' LEFT JOIN users_roles users_roles ON users.uid = users_roles.uid AND users_roles.rid = 8 LEFT JOIN realname realname ON users.uid = realname.uid LEFT JOIN profile_values profile_values_profile_firstname ON users.uid = profile_values_profile_firstname.uid AND profile_values_profile_firstname.fid = '3' LEFT JOIN profile_values profile_values_profile_lastname ON users.uid = profile_values_profile_lastname.uid AND profile_values_profile_lastname.fid = '2' WHERE (users.status <> 0) AND (users_roles.rid IS NULL) ORDER BY realname_realname ASC in /var/www/vhosts/mybluepearlvet.com/httpdocs/drupal/sites/all/modules/views/includes/view.inc on line 769.

user warning: Unknown column 'field_hospital_value' in 'field list' query: SELECT users.uid AS uid, users.picture AS users_picture, users.name AS users_name, realname.realname AS realname_realname, realname.uid AS realname_uid, profile_values_profile_firstname.value AS profile_values_profile_firstname_value, profile_values_profile_firstname.uid AS profile_values_profile_firstname_uid, profile_values_profile_lastname.value AS profile_values_profile_lastname_value, profile_values_profile_lastname.uid AS profile_values_profile_lastname_uid, users.mail AS users_mail, field_hospital_value, nid, type, vid FROM users users LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = 'personal_profile' LEFT JOIN users_roles users_roles ON users.uid = users_roles.uid AND users_roles.rid = 8 LEFT JOIN realname realname ON users.uid = realname.uid LEFT JOIN profile_values profile_values_profile_firstname ON users.uid = profile_values_profile_firstname.uid AND profile_values_profile_firstname.fid = '3' LEFT JOIN profile_values profile_values_profile_lastname ON users.uid = profile_values_profile_lastname.uid AND profile_values_profile_lastname.fid = '2' WHERE (users.status <> 0) AND (users_roles.rid IS NULL) ORDER BY realname_realname ASC in /var/www/vhosts/mybluepearlvet.com/httpdocs/drupal/sites/all/modules/views/includes/view.inc on line 769.
danielb’s picture

danielb commented

Do you seriously think I can read what you've pasted there? How come when I paste something it doesn't look retarded?
Observe:

array(
  'finder_id' => '11',
  'base' => 'node',
  'title' => 'Finder 11',
  'description' => '',
  'path' => 'finder/11',
  'block' => '0',
  'settings' => array(
    'form_on_page' => 1,
    'form' => array(
      'prefix' => '',
      'prefix_format' => '1',
      'suffix' => '',
      'suffix_format' => '1',
      'button_text' => 'Find',
      'go_text' => 'Go',
    ),
    'advanced' => array(
      'no_results' => array(
        'no_results' => 'There are no results to display',
      ),
      'filter' => 0,
      'submission' => 1,
      'ahah' => 0,
      'ahah_effect' => 'none',
      'element_combination' => '0',
      'pager' => '2',
      'match' => 'e',
      'goto' => 'go',
      'hide_args' => 0,
      'arg_sep' => ',',
      'empty_symbol' => '',
      'show_links' => 1,
      'show_admin_links' => 1,
      'cache_finder_find' => '0',
      'search' => '1',
      'search_tab' => 'node',
    ),
    'finder_wizard' => array(
      'is_wizard' => 0,
      'settings' => array(
        'step_skip' => 1,
        'invalid_path' => '',
      ),
    ),
    'i18nstrings' => array(
      'title' => array(
        '#i18nstrings' => 'finder:f11:title',
      ),


etc...

I need to be able to understand your view and your finder. Nevermind what that other guy said.

danielb’s picture

danielb commented

I spotted some 'relationships' stuff in your view there, I think I know what's going on, but I don't know how to fix it.
That field_hospital_value - does it exist in your view as a field item, or something else? I can't tell, it looks like it might be an argument or filter.
Try adding it as a field to your view.
Not that it fixes the problem but it might be a suitable workaround in some cases.
There was a related issue regarding relationships: http://drupal.org/node/487980
oh surprise surprise it's a content profile field too!

danielb’s picture

danielb commented
Status: Active » Closed (duplicate)

I will leave a note in the other issue about this one and mark this as a duplicate. If I can work out how to get aliases for fields joined by a relationship then this should all be fine.