[Mapserver-users] NQUERY Internal Server Error

[Daniel Morissette]

That's possibly the same as bug 569:
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=569

The workaround until it is fixed would be to move the TEMPLATE from the 
layer level to the class level.

Daniel



Düster Horst wrote:
> I'm a little bit confused about a query problem I'm faced with. Today I did
> the upgrade from MS 3.6.7 to MS 4.0.1. I made all the necessary migration
> steps (I hope). NQUERY with the most layers work fine, but one layer
> produces an "Internal Server Error". Apache error_log says "Premature End of
> Header". After some modifications of the concerned layer I found out a
> strange fact. Take a look at the attached Mapfile snippet. 
>  
> Some layer information:
> The underlaying data are stored in a Postgres-7.2.4/PostGIS-0.8.1 DB with
> 4500 recs. 
> The values of the attribute o_art are between 100 and 41500. 
>  
> with   
> DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >= 1000
> and o_art < 30412) as foo usinng SRID=-1"
> NQUERY works
>  
> with   
> DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >= 1000
> and o_art < 30413) as foo usinng SRID=-1"
> NQUERY does not work -> Internal Server Error
> 
> with   
> DATA "wkb_geometry from arp_ripl_poly"
> NQUERY does not work -> Internal Server Error
>  
>  
> LAYER
>   NAME basdat #Grundnutzung#Legende#
>   TYPE Polygon
>   STATUS ON
>   TOLERANCE 10
>   MAXSCALE 80000
>   DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >=
> 1000 and o_art < 30412) as foo usinng SRID=-1"
>   CONNECTIONTYPE POSTGIS
>   CONNECTION "dbname=xxx host=xxx user=xxx"
>   TEMPLATE "qry_tpl.html"
>   CLASS
>     EXPRESSION ([o_art]=5000)
>     NAME "<table><tr><td valign=top>   -</td><td> dem Landwirtschaftsgebiet
> überlagert</td></tr></table>"
>     COLOR 255 255 0
>     OUTLINECOLOR 0 0 0
>     SYMBOL "simple-line"
>   END  # CLASS
> END  
> 
> I would be appreciative about any hint.
>  
> With best regards
>  
> Dr. Horst Düster 
> GIS-Koordinator
>  
> Amt für Geoinformation
> Abteilung SO!GIS Koordination
> Werkhofstr. 65
> 4509 Solothurn 
> 
> Tel.: 032 627 25 32 
> Fax: 032 627 22 14
> 
> horst.duester at bd.so.ch <mailto:horst.duester at bd.so.ch> 
> www.sogis.so.ch <http://www.sogis.so.ch/> 
> 
>