[MapServer-users] Mapserver 8 rc1

[Scott]

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 <public at postholer.com 
> <mailto:public at 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 at lists.osgeo.org <mailto:MapServer-users at lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/mapserver-users
>     <https://lists.osgeo.org/mailman/listinfo/mapserver-users>
>