I am getting a sqlstate error when using distance field/filter on relationship data.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'field_geo_lat' in field list is ambiguous

Below is an export:

<?php
$view = new view;
$view->name = 'geo_test_version';
$view->description = 'Geo test';
$view->tag = 'smb mobile';
$view->base_table = 'node';
$view->human_name = 'Geo test version';
$view->core = 7;
$view->api_version = '3.0-alpha1';
$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['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['query']['options']['field_language'] = 'und';
$handler->display->display_options['query']['options']['field_language_add_to_query'] = 0;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'some';
$handler->display->display_options['pager']['options']['items_per_page'] = '20';
$handler->display->display_options['pager']['options']['offset'] = '0';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
$handler->display->display_options['row_options']['hide_empty'] = 1;
$handler->display->display_options['row_options']['default_field_elements'] = 1;
/* Relationship: Content: Company (field_company) */
$handler->display->display_options['relationships']['field_company_nid']['id'] = 'field_company_nid';
$handler->display->display_options['relationships']['field_company_nid']['table'] = 'field_data_field_company';
$handler->display->display_options['relationships']['field_company_nid']['field'] = 'field_company_nid';
$handler->display->display_options['relationships']['field_company_nid']['label'] = 'Company';
$handler->display->display_options['relationships']['field_company_nid']['required'] = 1;
$handler->display->display_options['relationships']['field_company_nid']['delta'] = '0';
/* Field: Content: Location (field_data_field_geo: Distance from point.) */
$handler->display->display_options['fields']['field_geofield_distance']['id'] = 'field_geofield_distance';
$handler->display->display_options['fields']['field_geofield_distance']['table'] = 'field_data_field_geo';
$handler->display->display_options['fields']['field_geofield_distance']['field'] = 'field_geofield_distance';
$handler->display->display_options['fields']['field_geofield_distance']['relationship'] = 'field_company_nid';
$handler->display->display_options['fields']['field_geofield_distance']['label'] = 'Location';
$handler->display->display_options['fields']['field_geofield_distance']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['element_label_colon'] = 1;
$handler->display->display_options['fields']['field_geofield_distance']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_geofield_distance']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['hide_alter_empty'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['set_precision'] = 1;
$handler->display->display_options['fields']['field_geofield_distance']['precision'] = '0';
$handler->display->display_options['fields']['field_geofield_distance']['format_plural'] = 0;
$handler->display->display_options['fields']['field_geofield_distance']['dist_lat'] = '65.8403';
$handler->display->display_options['fields']['field_geofield_distance']['dist_lon'] = '13.1863';

$handler->display->display_options['inherit_panels_path'] = '0';
$translatables['geo_test_version'] = array(
  t('Master'),
  t('Frontpage'),
);?>

Comments

farald’s picture

Title: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'field_geo_lat' in field list is ambiguous » Views SQLSTATE[23000]: Error when using 'Distance from point' in a relationship
farald’s picture

Issue summary: View changes

Sqlstate

Brandonian’s picture

@farald, which version of the module are you using? You've marked one of the release candidates, but the views code should only be a part of the 2.x branch. Did you pull code from the new dev branch at some point?

farald’s picture

Version: 7.x-1.0-rc1 » 7.x-2.x-dev
Status: Active » Fixed

Yeap, I sure did. 2.x-dev works fine. :)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Issue summary: View changes

Minor