Query shows no results when adding a map distance filter

This support ticket is created 4 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

Tagged: Toolset Maps, Views plugin

This topic contains 5 replies, has 2 voices.

Last updated by Luo Yang 4 years, 9 months ago.

Assisted by: Luo Yang.

Author

Posts

July 2, 2019 at 11:31 pm #1282359

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]

July 3, 2019 at 4:51 am #1282517

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.

July 3, 2019 at 5:06 am #1282607

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.

July 3, 2019 at 8:31 am #1282765

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

July 9, 2019 at 7:25 am #1287171

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.

July 10, 2019 at 4:17 am #1288335

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

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.