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
Comment #1
clemens.tolboomI 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 ;-)
Comment #2
dasjoi'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.
Comment #3
clemens.tolboomWhat 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?
Comment #3.0
clemens.tolboomAdding more information
Comment #4
pol