[Mapbender-users] Search Rout

Siline srunsiline at gmail.com
Thu Jan 16 23:34:57 PST 2020


Hello,

I found error, but I still can't fix the error. please help.
This is error:
An exception occurred while executing 'SELECT t.`line_id`, t.`line_ref_num`,
t.`chainage`, t.`line_name`, ST_AsGeoJSON(ST_Transform(t.`line_wkt`,
?::int)) as geom FROM gis_line_t1 t WHERE (t.line_ref_num LIKE ?) AND
(ST_Transform(ST_SetSRID(ST_MakeBox2D(ST_Point(?, ?), ST_Point(?, ?)), ?),
ST_Srid(t.`line_wkt`)) && t.`line_wkt`)' with params [32648, "%0806T1001%",
5579.905, 1088581.723, 1029359.857, 1650396.77, 32648]:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in
your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near '::int)) as geom FROM gis_line_t1 t
WHERE (t.line_ref_num LIKE '%0806T1001%' at line 1

Best,
Siline



--
Sent from: http://osgeo-org.1560.x6.nabble.com/mapbender-users-f4220788.html


More information about the Mapbender_users mailing list