I have a geolocation search map on 2 pages. Both worked up until recently - I have not looked at them since the recent Maps update a day or 2 ago. When that update ran I let it convert the maps data and/or delete the cache or whatever it was asking to do. Now, none of the locations are showing up in search results on the map. I’ve not changed anything with the map on my pages, only allowed the Maps plugin to update.
The homepage will show a map that lists locations within 25 miles by default. The “near me” page lets you enter a location to search. There are currently limited locations in the database. Search for Miami, FL or Atlanta, GA and you should get results.
Home: hidden link
Near page: hidden link
It may be helpful to know that displaying locations on a map works - I have pages like the following that load specific locations and the map displays them. It really looks to be a problem with the geolocation search returning no results now, or not being able to find matches anymore:
hidden link
Hi Lane,
Thank you for contacting us and I'd be happy to assist.
I performed some tests on my website with a similar view and distance filtering, but couldn't reproduce the issue.
To troubleshoot why the distance search is not working as expected, I'll suggest the following steps:
1. Please make sure that all involved caches have been cleared, after the Maps plugin and its data updated.
2. If you've included any custom code to specifically alter the distance filter or query filters in general for these views, please temporarily remove it and then test the search again.
3. To rule out any conflict with third-party code, you can also temporarily disable all non-Toolset plugins and switch to a default theme like Twenty Nineteen and then see if the issue gets resolved.
4. In case, the issue still persists, I'll need a clone/snapshot of your website, to troubleshoot this in more depth.
https://toolset.com/faq/provide-supporters-copy-site/
( your next reply will be private )
I hope this helps and please let me know how it goes.
regards,
Waqar
Hi Lane,
Thank you for sharing the duplicator package.
During troubleshooting and research, I was able to confirm that this behavior is related to the recently identified issue, which affects websites which have MySQL version older than 5.7.6:
https://toolset.com/errata/maps-1-8-and-1-8-1-require-mysql-5-7-6-or-higher/
This is already been worked on and I'll update you as soon as this is fixed.
For now, you can ask your host to upgrade MySQL version to 5.7.6 or higher and if that is not possible, downgrade the Toolset Maps plugin to older ( 1.7.4 ) version.
regards,
Waqar
Thank you, Waqar.
I'm running on Ubuntu 16.04. This version of Ubuntu currently only offers MySQL 5.7.26 so I don't have a "supported" path to upgrade MySQL beyond 5.7.26. I spun up a quick test instance of Ubuntu 18.04 and apt is offering the same version of MySQL on that newer OS release as well.
# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.6 LTS
Release: 16.04
Codename: xenial
# apt search mysql
....
mysql-server/xenial-updates,xenial-security,now 5.7.26-0ubuntu0.16.04.1 all [installed]
MySQL database server (metapackage depending on the latest version)
mysql-server-5.7/xenial-updates,xenial-security,now 5.7.26-0ubuntu0.16.04.1 amd64 [installed
,automatic]
MySQL database server binaries and system database setup
mysql-server-core-5.7/xenial-updates,xenial-security,now 5.7.26-0ubuntu0.16.04.1 amd64 [inst
alled,automatic]
MySQL database server binaries
mysql-source-5.7/xenial-updates,xenial-security 5.7.26-0ubuntu0.16.04.1 amd64
MySQL source
mysql-testsuite/xenial-updates,xenial-security 5.7.26-0ubuntu0.16.04.1 all
MySQL regression tests
mysql-testsuite-5.7/xenial-updates,xenial-security 5.7.26-0ubuntu0.16.04.1 amd64
MySQL 5.7 testsuite
....
I've reverted the Maps plugin back to 1.7.4 and confirm functionality to my website has been restored. Looking forward to the pending Maps update!
Thanks!
Hi Lane,
Thank you for confirming this and I'll keep you updated with the progress.
regards,
Waqar
Hi Lane,
I'm happy to update that Toolset Maps 1.8.2 has been released, which addresses this distance search issue.
( ref: https://toolset.com/download/toolset-maps/#changelog )
Please update to this latest version and let us know in case the issue still persists.
regards,
Waqar