I'm using text fields to store the lat and lon data. Perhaps, the field is not being aliased correctly.

SELECT node.title AS node_title, node.nid AS nid, node.created AS node_created, 'node' AS field_data_field_weather_weather_node_entity_type, 'node' AS field_data_field_weather_wind_node_entity_type, 'node' AS field_data_field_weather_latitude_node_entity_type, 'node' AS field_data_field_weather_longitude_node_entity_type, 'node' AS field_data_field_weather_time_node_entity_type
FROM 
{node} node
LEFT JOIN {field_data_field_weather_latitude} field_data_field_weather_latitude ON node.nid = field_data_field_weather_latitude.entity_id AND (field_data_field_weather_latitude.entity_type = 'node' AND field_data_field_weather_latitude.deleted = '0')
LEFT JOIN {field_data_field_weather_longitude} field_data_field_weather_longitude ON node.nid = field_data_field_weather_longitude.entity_id AND (field_data_field_weather_longitude.entity_type = 'node' AND field_data_field_weather_longitude.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN  ('noaa_weather')) )AND( (field_data_field_weather_longitude.field_weather_longitude >= '-80') AND (field_data_field_weather_longitude.field_weather_longitude <= '-80') )AND( (field_data_field_weather_latitude.field_weather_latitude >= '26') AND (field_data_field_weather_latitude.field_weather_latitude <= '26') ))
ORDER BY node_created DESC
Title	Weather table
Path	weather-geojson/?bbox=-80.16082,26.11004,-80.12593,26.13458

Comments

clemens.tolboom’s picture

Category: bug » support
Status: Active » Postponed (maintainer needs more info)

I guess this view doesn't work in table mode too? I suspect views to cause the problem.

Set to 'need more info' so we can close it shortly ;-)

dasjo’s picture

i'm not sure if that's the exact reason, but unfortunately the views_geojson bounding box strategy requires the display be be views_geojson. thus your assumption that it doesn't work for other displays like table should be correct.

clemens.tolboom’s picture

What I meant is the other way around. Changing the display to unformatted list the error probably would still exists.

Anyway the report is not telling the whole error as the title stops abrupt. Shall we close this?

clemens.tolboom’s picture

Issue summary: View changes

Adding more information

pol’s picture

Status: Postponed (maintainer needs more info) » Closed (won't fix)