Issue:

When using PHPmyAdmin version 5.2.1 tools to edit or insert a geometry object it throws error: #1416 – Cannot get geometry object from data you send to the GEOMETRY field.

This issue was reproducible in PHPmyAdmin version 5.2.1 but not reproducible in version of 5.1.3.

Specifically, when I use the internal tool to manually input the Lat and lng values it generates the SQL query below which inserts escape characters(‘) into the query sting.

UPDATE `allpages_geodata` SET `geoData` = ST_GeomFromText(''POINT(2.9501061323936 42.27264217835078)',0') WHERE `allpages_geodata`.`pageId` = 'a0205'

I also tried swapping around the lat and lng in the tool and multiple browsers(cache cleared) and it still throws the same error.