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

[Author]

Posts

[Pierre]

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

[Christian Cox]

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.

[Pierre]

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!