[Resolved] Query shows no results when adding a map distance filter

[Author]

Posts

[nicholasM]

I have a view setup showing results on a google map. As soon as I add a Query search to this view like below, I get NO results found in my query. The messed up part is even after I delete the filter that I added to the query I can NOT get the results to even come back how it was once I try and get a filter working like this https://toolset.com/documentation/user-guides/display-on-google-maps/how-to-display-custom-search-results-on-a-map/ it's just broken, there is no way to get the results to even show again without completely recreating a new view??

[wpv-filter-start hide="false"]
[wpv-filter-controls]
[wpv-control-distance default_distance="20" default_unit="mi" compare_field="location_address" distance_center_url_param="toolset_maps_distance_center" distance_radius_url_param="toolset_maps_distance_radius" distance_unit_url_param="toolset_maps_distance_unit"]
[/wpv-filter-controls]
[wpv-filter-end]

[Luo Yang]

Hello,

Thanks for the details, I am trying to duplicate the same problem in my localhost, will update here if there is anything news.

[Luo Yang]

I can get the same result with MariaDB in my locahost, and below error message:

WordPress database error: [FUNCTION wordpress.ST_Distance_Sphere does not exist]

The function ST_Distance_Sphere() was added in MYSQL 5.7.6:
hidden link

but you are using MySQL 5.5.62, so it conducts the problem.

According to our document:
https://toolset.com/toolset-requirements/
The minimal requirement is: MySQL 5.6 and above.

So it should be a bug of Toolset Maps plugin, I have escalated this issue, will update here if there is any news.

[Luo Yang]

Here is the feedback from our developers:
We are working on it. Currently, please try these:
1) Backup your website
2) Downgrade to Maps 1.7.4, no data should be lost and things should continue working as before
You can download it here:
https://toolset.com/download/toolset-maps/#changelog

[Luo Yang]

Hello,

Here is the feedback from our developers:
This is fixed in Toolset Maps plugin version 1.8.2, it is under QA status, will be released soon.

And According to our document:
https://toolset.com/toolset-requirements/
The minimal requirement is: MySQL 5.6 and above.

So you will need to upgrade the MySQL server to 5.6 or above.

[Luo Yang]

Toolset Maps plugin version 1.8.2 is released, you can download it here:
https://toolset.com/account/downloads/

Please test it and feedback if it is fixed, thanks