Skip Navigation

[Resolved] Locations Distance Filter Not Working

This thread is resolved. Here is a description of the problem and solution.

Problem:

Setup a post view with distance filter, but I get result:
No items found.

Solution:

It is a server problem, you can upgrade to MYSQL 5.6 or above, and test again.

Relevant Documentation:

https://toolset.com/toolset-requirements/

This support ticket is created 5 years, 3 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.

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)

This topic contains 5 replies, has 2 voices.

Last updated by benjaminJ-3 5 years, 3 months ago.

Assisted by: Luo Yang.

Author
Posts
#1320641

I am trying to: Filter Map Icons by Distance

Link to a page where the issue can be seen: hidden link

I expected to see: Map Icons within 100miles

Instead, I got: No items found.

#1320889

Hello,

Thanks for the details, I can see the problem in your website, and trying to download the duplicator package files, will update here if there is any found.

#1320933
distance-filter.JPG

Since your duplicator package is too big to download, so I export your website database dump file into my localhost, it works fine in a fresh wordpress installation + the latest version of Toolset plugin, see screenshot distance-filter.JPG

I have checked again in your website:
Dashboard-> Toolset-> Settings-> Maps, click button "Load stored data", there should be some cached address Latitude and Longitude values, but it is empty in your website.
Toolset Maps plugin is using above cached data to do the distance filter, so the problem is abnormal.

There might be a compatibility/server issue in your website, please try these:
1) deactivate all other plugins, and switch to wordpress default theme 2019, deactivate all custom PHP/JS code snippets, and test again

2) Also check if there is any PHP/JS error in your website:
https://toolset.com/documentation/programmer-reference/debugging-sites-built-with-toolset/

#1321717

Ran again with 2019 themes and no plugins activated. No PHP errors or console errors. No locations being cached.

#1321757

It might be a server problem, your website is using Mysql 5.5.62, but according to our document:
https://toolset.com/toolset-requirements/
the minimum requirements to run Toolset plugins: MySQL 5.6 and above.

It is same as WordPress requirement:
https://wordpress.org/about/requirements/

Please try to upgrade to mysql 5.6 or above, and test again.

#1321777

You're a life saver, I just launched that server and I did not realize they auto installed such an old version of MySQL. Thank you!