Sort by location not working – Fatal Error
Hi, I have added acf fields in format ( lat, long), and indexed all products.
Added location to sort filter, but on selecting it, nothing changes, and on reloading page with url containing sort filter(?s=report&wpsolr_sort=geolocation_str_desc), I can see this errorFatal error: Uncaught Elasticsearch\Common\Exceptions\BadRequest400Exception: {"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"can't sort on geo_point field without using specific sorting feature, like geo_distance"}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":Geolocation extension is added and configured too as per the documentation
Can you help me with this ?Yes,
I changed the custom field type of geolocation to text sortable, and it works, but I use it as geolocation its throwing fatal error
Is it okay to go with this?
One more issue is this code isnt working:
I did print_r($post), got these values into it
this is my acf field :
This is the field getting sent to index, I checked in debug turned on while send data
How can we debug this ?
Failing in these both scenarios, I am getting use my location checkbox, browser message to allow location, but this page breaks. If I use text sortble for geolocation field, results arent sorted without any fatal error.
?s=report&wpsolr_sort=geolocation_str_desc
?s=report&wpsolr_is_geo=n&wpsolr_lat=15.3921558&wpsolr_long=73.9947563Its just a normal text field :
I tried adding Lat,log and also (lat,log) in values, both having issues. Which is the correct way, with or without brackets?
As this error says “can’t sort on geo_point field without using specific sorting feature, like geo_distance”. Adding wpsolr_sort=geo_distance stops the error, but functionality not working.
?s=best&wpsolr_is_geo=y&wpsolr_lat=17.457964&wpsolr_long=78.3687756&wpsolr_sort=geo_distance_desc
On Adding wpsolr_sort=geo_distance_desc to url, these are the results I am getting, no fatal error, but not sorted as per distance.
This is the Query monitor logged wpsolr query, as I avoided the fatal error with that string param in url
{ "from": 0, "size": 20, "track_total_hits": true, "highlight": { "require_field_match": false, "pre_tags": [""], "post_tags": ["<\/b>"], "fields": { "title": { "fragment_size": 100, "number_of_fragments": 1 } } }, "_source": ["id", "PID", "type", "meta_type_s", "title", "numcomments", "comments", "displaydate", "displaymodified", "*categories_str", "author", "*post_thumbnail_href_str", "*post_href_str", "snippet_s", "wpsolr_distance_geolocation_acf"], "query": { "function_score": { "functions": [{ "filter": { "match": { "product_visibility_str": "featured" } }, "weight": 1.1 }], "query": { "bool": { "must": { "query_string": { "fields": ["product_visibility_str^1.1", "title^9", "content^1.5"], "query": "(best)", "default_operator": "AND" } }, "filter": { "bool": { "must": [{ "bool": { "must_not": [{ "terms": { "post_status_s": ["draft", "pending", "trash", "future", "private", "auto-draft"] } }] } }, { "bool": { "must_not": [{ "terms": { "type": ["shop_order"] } }] } }, { "bool": { "should": [{ "bool": { "must_not": [{ "terms": { "type": ["product"] } }] } }, { "bool": { "should": [{ "bool": { "must_not": [{ "exists": { "field": "product_visibility_str" } }] } }, { "bool": { "must_not": [{ "terms": { "product_visibility_str": ["exclude-from-search"] } }] } }] } }] } }, { "bool": { "should": [{ "bool": { "must_not": [{ "bool": { "must": { "exists": { "field": "is_excluded_s" } } } }] } }, { "terms": { "is_excluded_s": ["n"] } }] } }, { "bool": { "must_not": [{ "terms": { "_id": ["wpsolr_doc_id_attachment"] } }] } }] } } } } } }, "post_filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "script_fields": { "wpsolr_distance_geolocation_acf": { "script": { "source": "doc[params.field].empty ? params.empty_value : doc[params.field].planeDistance(params.lat,params.lon)*0.001", "params": { "field": "geolocation_acf_ll", "empty_value": 40000, "lat": 17.457964, "lon": 78.3687756 }, "lang": "painless" } } }, "aggs": { "flat_hierarchy_industry_str": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "flat_hierarchy_industry_str": { "filter": { "match_all": {} }, "aggs": { "flat_hierarchy_industry_str": { "terms": { "field": "flat_hierarchy_industry_str", "size": 200000, "order": { "_key": "asc" } } } } } } }, "flat_hierarchy_geography_str": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "flat_hierarchy_geography_str": { "filter": { "match_all": {} }, "aggs": { "flat_hierarchy_geography_str": { "terms": { "field": "flat_hierarchy_geography_str", "size": 200000, "order": { "_key": "asc" } } } } } } }, "flat_hierarchy_report_type_str": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "flat_hierarchy_report_type_str": { "filter": { "match_all": {} }, "aggs": { "flat_hierarchy_report_type_str": { "terms": { "field": "flat_hierarchy_report_type_str", "size": 200000, "order": { "_key": "asc" } } } } } } }, "flat_hierarchy_themes_str": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "flat_hierarchy_themes_str": { "filter": { "match_all": {} }, "aggs": { "flat_hierarchy_themes_str": { "terms": { "field": "flat_hierarchy_themes_str", "size": 200000, "order": { "_key": "asc" } } } } } } }, "publication_date_dt": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "publication_date_dt": { "filter": { "match_all": {} }, "aggs": { "publication_date_dt": { "stats": { "field": "publication_date_dt" } } } } } }, "_price_f": { "filter": { "bool": { "must": [{ "bool": { "must": [{ "terms": { "type": ["product"] } }] } }] } }, "aggs": { "_price_f": { "filter": { "match_all": {} }, "aggs": { "_price_f": { "range": { "field": "_price_f", "ranges": [{ "to": "0" }, { "from": 0, "to": 2000 }, { "from": 2000, "to": 4000 }, { "from": 4000, "to": 6000 }, { "from": 6000, "to": 8000 }, { "from": 8000, "to": 10000 }, { "from": "10000" }] } } } } } } } }
You must be logged in to reply to this topic.