[MapServer-users] Mapserver 8 rc1
Scott
public at postholer.com
Wed Aug 24 15:09:16 PDT 2022
I've installed 8rc1 and I've run into an issue. I didn't see anything in
the change log, so I'll put it here.
The !BOX! variable that has been historically available doesn't seem to
be supported with CONNECTIONTYPE POSTGIS any longer. For instance:
DATA "geom from (
select
geom
from sometable
where st_intersects(geom, !BOX!)
) as sq using unique geom using srid=4269"
...will throw an error:
<?xml version='1.0' encoding="UTF-8" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM
"http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1">
<ServiceException>
msDrawMap(): Image handling error. Failed to draw layer named
'wptsAll'.
msPostGISLayerWhichShapes(): Query error. Failed to build query SQL.
msPostGISBuildSQL(): General error message. Failed to build SQL
'where'.
</ServiceException>
</ServiceExceptionReport>
If I remove the !BOX! it will work.
Thanks!
Scott
--
www.postholer.com
More information about the MapServer-users
mailing list