Query shows no results when adding a map distance filter

This support ticket is created Il y a 5 années et 5 mois. 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.

Aucun de nos assistants n'est disponible aujourd'hui sur le forum Jeu d'outils. Veuillez créer un ticket, et nous nous le traiterons dès notre prochaine connexion. Merci de votre compréhension.

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)

Marqué : Toolset Maps, Views plugin

Ce sujet contient 5 réponses, a 2 voix.

Dernière mise à jour par Luo Yang Il y a 5 années et 4 mois.

Assisté par: Luo Yang.

Auteur

Publications

juillet 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]

juillet 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.

juillet 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:
lien caché

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.

juillet 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

juillet 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.

juillet 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