[MapServer-users] Mapserver 8 rc1

[Jeff McKenna]

Hi Scott,

Can you open a ticket for this at 
https://github.com/MapServer/MapServer/issues ?  Thanks,

-jeff



-- 
Jeff McKenna
GatewayGeo: Developers of MS4W, MapServer Consulting and Training
co-founder of FOSS4G
http://gatewaygeo.com/



On 2022-08-25 11:19 p.m., Scott wrote:
> 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>
>>
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users