ms_error log is telling me it's unable to build the SQL query. There are
no errors in the postgresql log.
Even if I comment the line out I get an error, such as:
--where st_intersects(geom, !BOX!)
or:
/* !BOX! */
If it exists any where in the DATA block, it fails.
Here's the ms error log:
[Thu Aug 25 13:46:55 2022].451955 msPostGISBuildSQL(): General error
message. Failed to build SQL 'where'.
[Thu Aug 25 13:46:55 2022].451980 msPostGISLayerWhichShapes(): Query
error. Failed to build query SQL.
[Thu Aug 25 13:46:55 2022].452010 msDrawMap(): Image handling error.
Failed to draw layer named 'wptByTrailType'.
On 8/25/22 13:03, Steve Lime wrote:
Hmmm... Wasn't an intentional omission. If you have logging turned on
and can see the resulting SQL, does the !BOX! get replaced but just
incorrectly or is the !BOX! still in the SQL.
On Wed, Aug 24, 2022 at 5:16 PM Scott <pub...@postholer.com
<mailto:pub...@postholer.com>> wrote:
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
<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 <http://www.postholer.com>
_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org <mailto:MapServer-users@lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapserver-users
<https://lists.osgeo.org/mailman/listinfo/mapserver-users>
_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users