[Gelöst] Distance selection was working, now not working

[Author]

Artikel

[DavidW2160]

I am trying to: Use the Views + Maps distance filter

Link to a page where the issue can be seen:
versteckter Link
versteckter Link

I expected to see: the same listing(s) on both pages

Instead, I got: the no-filter page shows the listing(s), the filter page does not. The only difference between the two pages is a distance filter from my address in Cottage Grove, OR 97424, and the listing(s) are also in the same city/zip

This seems to have occurred abruptly with the download of the most recent maps plugin (update) and after conversion of the cache.

The filter set within the view also seems to generate a cached address in San Francisco, no matter what address I tell it in the view distance filter. See uploaded image. This should have been 725 E Whiteaker Ave, Cottage Grove OR 97424

[Luo Yang]

Hello,

Thanks for the details, I can see the problem in your website, the distance filter does not work as expected.
I am trying to duplicate the same problem in my localhost, will update here if there is anything found.

[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:
versteckter Link

but you are using MySQL 5.5.5, 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

[DavidW2160]

I can't vouch for the accuracy of this post, but there's a potential replacement function for MariaDB users like us:

https://stackoverflow.com/questions/44409012/function-st-distance-sphere-does-not-exist-in-mariadb

CREATE FUNCTION `st_distance_sphere`(`pt1` POINT, `pt2` POINT) RETURNS
decimal(10,2)
BEGIN
return 6371000 * 2 * ASIN(SQRT(
POWER(SIN((ST_Y(pt2) - ST_Y(pt1)) * pi()/180 / 2),
2) + COS(ST_Y(pt1) * pi()/180 ) * COS(ST_Y(pt2) *
pi()/180) * POWER(SIN((ST_X(pt2) - ST_X(pt1)) *
pi()/180 / 2), 2) ));
END

[Luo Yang]

Thanks for the link, I have shared it with our developers.

And we have add a new errata for this issue:
https://toolset.com/errata/maps-1-8-and-1-8-1-require-mysql-5-7-6-or-higher/

[zacharyL]

I can confirm that I'm having this same issue on versteckter Link

Location filters worked when I initially developed the site, but after updating the Toolset Maps plugin, I found that they no longer function as they once did.

Update: I can also confirm that the previous version of the Toolset Maps plugin allows the distance filter to operate. I just dialed it back now. Will wait for the next release before updating again.

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

[zacharyL]

I have just confirmed that version update 1.8.2 fixes my problem. Give them my thanks!

[Luo Yang]

Thanks for the confirmation.

[DavidW2160]

1.8.2 fixed this issue for me. Thank you!

[DavidW2160]

My issue is resolved now. Thank you!