[Mapbender-commits] r10375 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-12-18 04:33:08 -0800 (Wed, 18 Dec 2019)
New Revision: 10375

Modified:
   trunk/mapbender/http/php/transformPoint.php
Log:
Fix for postgis 2.3+ -> target epsg should be cast as integer

Modified: trunk/mapbender/http/php/transformPoint.php
===================================================================
--- trunk/mapbender/http/php/transformPoint.php	2019-12-18 08:00:24 UTC (rev 10374)
+++ trunk/mapbender/http/php/transformPoint.php	2019-12-18 12:33:08 UTC (rev 10375)
@@ -42,7 +42,7 @@
     // die('<pre>' . print_r($multipoint, 1) . '</pre>');
     $targetProjSricCode = intval($targetProj["srsProjNumber"]);
     $currentProjSricCode = intval($currentProj["srsProjNumber"]);
-    $sql = "SELECT ST_AsGeoJson(ST_Transform(ST_GeomFromText($1,$2),$3)) As target_geom";
+    $sql = "SELECT ST_AsGeoJson(ST_Transform(ST_GeomFromText($1,$2),$3::int)) As target_geom";
     $v = array($multipoint, intval($targetProjSricCode), intval($currentProjSricCode));
     $t = array('s', 'i', 'i');
     $res = db_prep_query($sql, $v, $t);