My map isn't showing more than 5 markers after moving my site

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

Problem:
The user has created a view with a map but can only get 5 markers on it.

Solution:
The user was using an old version of MySQL that does not support geolocation capabilities. Toolset requires at least MySQL 5.6

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

This support ticket is created 3 years, 7 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: Africa/Casablanca (GMT+01:00)

Tagged: Toolset Maps, Views plugin

This topic contains 5 replies, has 2 voices.

Last updated by richardd-6 3 years, 7 months ago.

Assisted by: Jamal.

Author

Posts

September 18, 2020 at 12:12 pm #1781471

richardd-6

I moved my website from local to a live website, only the markers on hidden link aren't working anymore. Only the first 5 results show. I tried a new maps api key, empty wordpress cache, Toolset cache, make a new map, but I don't get this to work. Can you help me?

September 18, 2020 at 1:27 pm #1781555

Jamal

Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

Hello and thank you for contacting the Toolset support.

I installed the "WP File Manager" in order to check the wp-config.php file for database information(database name).
https://wordpress.org/plugins/wp-file-manager/

I have installed the "WP Data Access" plugin to check the database, and it looks that the Toolset Maps cache table is corrupted, check this screenshot hidden link
https://wordpress.org/plugins/wp-data-access/

I would say that the migration did not migrate the table correctly. You might want to check the differences between the migrated server and the original one.

I will suggest removing the table "wp_toolset_maps_address_cache" at the database level. Then, deactivate and reactivate Toolset Maps to recreate it. Then you will have to visit the map page several times because Toolset Maps will limit the requests to Google's servers.

I removed both plugins from your website.

September 19, 2020 at 6:11 am #1782187

richardd-6

Schermafbeelding 2020-09-19 om 08.08.35.png

Hi Jamal,
I tried your solution but unfortunately it didn't make a difference. Nothing changed.
Also it seems like the cached data stays empty.

September 19, 2020 at 10:10 am #1782379

Jamal

Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

Thank you for your feedback.

Would you allow me SFTP access to your website to install Adminer script in order to manipulate the database? Your next reply will be private to let you share credentials safely. ** Make a database backup before sharing credentials. **

September 19, 2020 at 3:31 pm #1782579

Jamal

Supporter

Languages: English (English ) French (Français )

Timezone: Africa/Casablanca (GMT+01:00)

It seems that this server uses version 5.5.54 of MySQL, which does not support geospatial features. You will notice that your first server has at least MySQL 5.6. Check this screenshot hidden link

If you upgrade your MySQL service or test the copy of your website on another server that has at least MySQL 5.6, geospatial features will work. Please test that and let us know what you will get.

Toolset requires at least MySQL 5.6, check our requirements page here https://toolset.com/toolset-requirements/

September 22, 2020 at 6:11 pm #1786391

richardd-6

My issue is resolved now. Thank you!

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