Skip Navigation

[Resolved] Google Map only shows 5 first posts as markers on map

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

Problem: I have a created site that uses Google Maps to display markers from a View of posts. In the development environment, everything works fine. In the production environment, maps only show markers from the first 5 results. The site content is identical on both environments, but in production I see the following errors in my server logs:

WordPress databasfel: [FUNCTION www_dpower_se.ST_X does not exist]
SELECT address_passed, ST_X(point) as lon, ST_Y(point) as lat FROM jlbm_toolset_maps_address_cache
 
WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Sandbyhovsvägen 8 SE-590 95 Loftahammar Sweden', 'Sandbyhovsvägen 8, 590 95 Loftahammar, Sweden', ST_PointFromText('POINT(16.694151 57.901720)') )
 
WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Östra Hamnen 6 SE-430 91 Hönö Sweden', 'Östra Hamnen 6, 475 42 Hönö, Sweden', ST_PointFromText('POINT(11.650538 57.681713)') )
 
WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Beckholmsvägen 18 SE-115 21 Stockholm Sweden', 'Beckholmsvägen 18, 115 21 Stockholm, Sweden', ST_PointFromText('POINT(18.100019 59.322282)') )
 
WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Torsby 222 SE-473 97 Henån Sweden', 'TORSBY 222, 473 97 Henån, Sweden', ST_PointFromText('POINT(11.596219 58.159667)') )
 
WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Box 27 SE-185 21 Vaxholm Sweden', 'Vaxholm, Sweden', ST_PointFromText('POINT(18.326380 59.403297)') )

Solution: It appears that the version of MySQL installed in production is lower than 5.6. The minimum requirement for Toolset is 5.6, because some functions are not available in lower version numbers. For best results, please update MySQL to 5.6 or higher on your server. Your hosting company should be able to upgrade this for you.

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

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

Our next available supporter will start replying to tickets in about 2.14 hours from now. Thank you for your understanding.

Sun Mon Tue Wed Thu Fri Sat
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

This topic contains 2 replies, has 2 voices.

Last updated by Pierre 4 years, 4 months ago.

Assisted by: Christian Cox.

Author
Posts
#1392861

This is actually a late response to a closed ticket that I was unable to open again.

Been sitting here all night now trying to figure out what's wrong.
Comparing my dev-site and the public site's configuration. It's identical.
I've also tried to change the theme, turn off plugins etc. But it just won't show more than 5 results in the map.(?)

If you have a look at this dev site you see how it is supposed to work: hidden link

But when looking at the public site something is wrong: hidden link
I have turned on DEBUG = true on both sites. As you can see (pasted below as well) there's a bunch of errors on the public-site.
I'm not sure this is the cause to only 5 markers on the map though. I also compared the database tables for this table (jlbm_toolset_maps_address_cache).
On the dev site, there were at least 6 pages of rows with addresses. On the public web's sql-db the same table had zero rows!?

OH, and I have also pressed on the "Load stored data"-button that can be found under the MAPS-settings tab for toolset. It doesn't seem to do much more than disappear when I click on it (?)

The generated php error from DEBUG = True:

WordPress databasfel: [FUNCTION www_dpower_se.ST_X does not exist]
SELECT address_passed, ST_X(point) as lon, ST_Y(point) as lat FROM jlbm_toolset_maps_address_cache

WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Sandbyhovsvägen 8 SE-590 95 Loftahammar Sweden', 'Sandbyhovsvägen 8, 590 95 Loftahammar, Sweden', ST_PointFromText('POINT(16.694151 57.901720)') )

WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Östra Hamnen 6 SE-430 91 Hönö Sweden', 'Östra Hamnen 6, 475 42 Hönö, Sweden', ST_PointFromText('POINT(11.650538 57.681713)') )

WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Beckholmsvägen 18 SE-115 21 Stockholm Sweden', 'Beckholmsvägen 18, 115 21 Stockholm, Sweden', ST_PointFromText('POINT(18.100019 59.322282)') )

WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Torsby 222 SE-473 97 Henån Sweden', 'TORSBY 222, 473 97 Henån, Sweden', ST_PointFromText('POINT(11.596219 58.159667)') )

WordPress databasfel: [FUNCTION www_dpower_se.ST_PointFromText does not exist]
INSERT INTO jlbm_toolset_maps_address_cache ( `address_passed`, `address`, `point` ) VALUES ( 'Box 27 SE-185 21 Vaxholm Sweden', 'Vaxholm, Sweden', ST_PointFromText('POINT(18.326380 59.403297)') )

Thanks!
//Pierre

#1392873

Hi, what MySQL version is installed on your dev site? I can see from your debug information you have MySQLVersion 5.5.59 running on the production site. MySQL 5.6 is the minimum requirement for Toolset's distance filter functionality because some distance calculation functions are not available in lower MySQL versions. My guess is that the dev site has MySQL 5.6+, so these issues do not occur.

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

Your host company may be able to update your MySQL version on the production server quite easily. If so, please try that and let me know if the problem is not completely resolved. If not, I can take a closer look.

#1396717

My issue is resolved now. Thank you!

Told my server provider to uppgrade php and mysql to recommended versions. Worked flawless after that!
Big thanks!

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