Skip Navigation

[Resolved] Map 1.8.3 still not working right with MariaDB

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

Problem:

In the Toolset Maps plugin version 1.8.3, if remove the the toolset_maps_distance_radius field from search form, it will return results only within 5 km.

Solution:

This issue is fixed in the latest version of Toolset Maps plugin 2.0.1, you can download it here:

https://toolset.com/account/downloads/

Relevant Documentation:

0% of people find this useful.

This support ticket is created 4 years, 6 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 23 replies, has 3 voices.

Last updated by scottL-3 4 years, 2 months ago.

Assisted by: Luo Yang.

Author
Posts
#1331917

I am trying to: distance search in a View with Maps

Link to a page where the issue can be seen:
Working (maps 1.7.4): hidden link
Not Working (maps 1.8.3): hidden link

I expected to see:
10 or more partners in a radius of 30 miles of the search center.

Instead, I got:
2 partners in a radius of about 2 miles of the search center.

I fixed this on the live site by downgrading to Maps 1.7.4 again. Kept 1.8.3 on staging so you can see the difference. The only difference between these two sites is the Toolset Maps version.

#1331975

Hello,

I have checked the Debug information you provided above, the MYSQL version is 5.5.5.

According to our server requirement document:
https://toolset.com/toolset-requirements/
the minimum requirements to run Toolset plugins: MySQL 5.6 and above.

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

Can you try to upgrade the your MariaDB db version to MariaDB-10.1 or above, see MariaDB document:
hidden link

#1332647

Thanks Luo.

I had Kinsta update the staging site to MariaDB 10.4 and it did not change the results. The search there still returns only 2 results where it should return 10 or more. Now the only difference between staging and live is that live has the older version of Maps (1.7.4) and works properly and staging has the newer version of Maps (1.8.3) AND MariaDB 10.4 and does not work properly for distance search.

#1333047

The problem you mentioned above is abnormal, please try these:

1) In case it is a compatibility problem, please deactivate all other plugins, and switch to wordpress default theme 2019, 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/

3) If the problem still persists, please provide database dump file(ZIP file) of your website, I need to test and debug it in my localhost, thanks
https://toolset.com/faq/provide-supporters-copy-site/

#1333115

Thanks for the details, I am downloading the files, will update here if there is anything found

#1333141
sql-import.JPG

The SQL file you provided above is not valid, I get lots of SQL errors while importing it, see screenshot import-sql.JPG

After import the sql file, there are lots of databse table missing, so please try to export the database dump file with duplicator plugin, you can export database only by following their document:
hidden link

#1333489

Please set my next reply to private and set it so I can attach the SQL file again. I am able to import the file into a local MySQL and see the tables and entries so the issue may have been in the upload process or the zipping of the file. I compressed this one during export, uncompressed it, imported it into a new database successfully so I'll try sending you this one in next reply.

#1334691

OK, I have enabled the private message box again, please provide the new database dump file again, thanks

#1336181

Thanks for the details, I am downloading the files, will update here if there is anything found

#1336203

The database dump file is not valid too, I get the same SQL errors as I mentioned in screenshot:
https://toolset.com/wp-content/uploads/2019/09/1333141-sql_import.jpg

So please follow the document I mentioned above to export the database dump file:
https://toolset.com/faq/provide-supporters-copy-site/

you can export database only by following their document:
hidden link

Private message box enabled again. thanks

#1336225

Thanks for the details, I can import the duplicator package and see the same problem in my localhost, and I am trying to debug it, will update here if there is anything found.

For the database dump file problem, I was using MarioDB console to import the sql file.

#1336287
distance-filter.JPG

Here are what I found, it should be a problem of post view "Test Installer Finder", I have tried to create another new post view, with same distance filter, it works fine, see screenshot: distance-filter.JPG.

I suggest you created another new post view, and test again.

#1336685

Can you escalate this to a developer? If the problem goes away when switching to a different but identical View, then the cache of locations or some other data must be at fault unless the View itself is somehow corrupted. This is a complicated View and if all customers on MariaDB have to rebuild their Views to work with the newer version of Maps, that is not very good for Toolset's business and will make people leery of Toolset. We (Toolset and me) need to know the root cause here not just that re-creating the View makes the problem go away.

I will try to re-create the View and see if it helps here too but I'd really like to know what the actual problem is.

#1337457

Yes, there might be a cache problem, you can disable Views cache by this:
Edit the page "Find an Installer", replace views shortcode from:
[wpv-view name="test-installer-finder"]

To:
[wpv-view name="test-installer-finder" cached="off"]

And test again.

More help:
https://toolset.com/documentation/user-guides/views-shortcodes/#wpv-view
cached (opt):
off
Turns off the caching system for the View.

#1337821

Unfortunately, set cached to off doesn't change the outcome. Same problem.

Also, if I re-create the view in a new view and change the page to use the new view, I get the same result so not sure why it worked differently for you. Are you sure you tested on MariaDB?

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.