[Mapserver-users] NQUERY Internal Server Error
Düster Horst
Horst.Duester at bd.so.ch
Mon Mar 15 06:57:49 PST 2004
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/>
More information about the MapServer-users
mailing list