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 |
|---|---|---|---|---|---|---|
| - | 10:00 – 13:00 | 10:00 – 13:00 | 10:00 – 13:00 | 10:00 – 13:00 | 10: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/Kolkata (GMT+05:30)
This topic contains 2 replies, has 2 voices.
Last updated by 1 year, 4 months ago.
Assisted by: Minesh.
We are testing our site in preparation to upgrade MySQL from 5.4 to 8.
The site has two different ways to search: 1) search for counselors within X miles of a zip code who provide in-person services, or 2) search for counselors who provide remote services within a given state.
If you search on hidden link, which is running on MySQL 5.4, you can see how the two different searches work.
However, If you do a zip code search on hidden link (use username "script" and password "abundant" to access the site), which is a copy of the site running on MySQL 8.0, you'll see that the two different searches are being combined. It shows the locations of counselors who provide in-person services, but if any of those counselors also provide remote services in other states, those states are included in the search results. The search results map therefore shows large regions of the country.
We need to figure out how to make searches in MySQL 8 behave like they do in MySQL 5.
I've included screenshots of how the two search results screens differ. The debug information I've provided is from the MySQL 8.0 site.
