[mapserver-users] EXPRESSION error with MapServer 6.2

2012-11-29 Thread Astrid Emde
Hello,

I have a MapServer 6.2 question. I run MapServer 6.2 on Windows Server 2008.

I noticed a strange behaviour with the EXPRESSION definition while I am
migrating my mapfiles to MapServer 6.0

This is my table:
CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe
(
  ogc_fid serial NOT NULL,
  gml_id character(16), -- Identifikator, global eindeutig
  ...
  bauwerksfunktion integer,
  wkb_geometry geometry
  ...
);


DATA wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry
FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique
ogc_fid USING SRID=25832

As bauwerksfunktion is an integer column my EXPRESSION definition was like
this in MaServer  6.0

EXPRESSION ([bauwerksfunktion] = 1210)
EXPRESSION ([bauwerksfunktion] = 1215 OR [bauwerksfunktion] = 1220 OR
[bauwerksfunktion] = 1250 OR [bauwerksfunktion] = 1260)

Now with MapServer 6.2 it does not work anymore:
* instead of a map I get an Internal Server Error

My Logfile says:
[Thu Nov 29 15:03:31 2012].824000 msEvalExpression(): General error
message. Invalid item index.

I also checked http://mapserver.org/mapfile/expressions.html

Does anyone has an idea?

-- 
Thanks for your help

Astrid Emde

..
FOSSGIS 2013, Die Konferenz für Open Source GIS mit OpenData und
OpenStreetMap erstmals in der Schweiz!
12.-14. Juni, HSR, Rapperswil, http://www.fossgis.de
..


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] EXPRESSION error with MapServer 6.2

2012-11-29 Thread Lime, Steve D (DNR)
Hmmm... Seems like bug. There weren't any major changes to the EXPRESSION code 
but I imagine at least small modifications were made. I have access to similar 
data here, let me try a local test.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Astrid Emde
Sent: Thursday, November 29, 2012 9:16 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] EXPRESSION error with MapServer 6.2

Hello,

I have a MapServer 6.2 question. I run MapServer 6.2 on Windows Server 2008.

I noticed a strange behaviour with the EXPRESSION definition while I am 
migrating my mapfiles to MapServer 6.0

This is my table:
CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe
(
  ogc_fid serial NOT NULL,
  gml_id character(16), -- Identifikator, global eindeutig
  ...
  bauwerksfunktion integer,
  wkb_geometry geometry
  ...
);


DATA wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry FROM 
ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique ogc_fid USING 
SRID=25832

As bauwerksfunktion is an integer column my EXPRESSION definition was like this 
in MaServer  6.0

EXPRESSION ([bauwerksfunktion] = 1210)
EXPRESSION ([bauwerksfunktion] = 1215 OR [bauwerksfunktion] = 1220 OR 
[bauwerksfunktion] = 1250 OR [bauwerksfunktion] = 1260)

Now with MapServer 6.2 it does not work anymore:
* instead of a map I get an Internal Server Error

My Logfile says:
[Thu Nov 29 15:03:31 2012].824000 msEvalExpression(): General error message. 
Invalid item index.

I also checked http://mapserver.org/mapfile/expressions.html

Does anyone has an idea?

--
Thanks for your help

Astrid Emde

..
FOSSGIS 2013, Die Konferenz für Open Source GIS mit OpenData und OpenStreetMap 
erstmals in der Schweiz!
12.-14. Juni, HSR, Rapperswil, http://www.fossgis.de 
..


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] EXPRESSION error with MapServer 6.2

2012-11-29 Thread Jeff Lake

shot in the dark ..
But I believe the error your getting in an actual MySQL error ..
your table name is a bit long ...

-Jeff Lake
MichiganWxSystem.com
AllisonHouse.com
TheWeatherCenter.net
GRLevelXStuff.com

On 11/29/2012 10:16, Astrid Emde wrote:

Hello,

I have a MapServer 6.2 question. I run MapServer 6.2 on Windows Server 2008.

I noticed a strange behaviour with the EXPRESSION definition while I am
migrating my mapfiles to MapServer 6.0

This is my table:
CREATE TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe
(
   ogc_fid serial NOT NULL,
   gml_id character(16), -- Identifikator, global eindeutig
   ...
   bauwerksfunktion integer,
   wkb_geometry geometry
   ...
);


DATA wkb_geometry from (SELECT ogc_fid, bauwerksfunktion, wkb_geometry
FROM ax_bauwerkoderanlagefuerindustrieundgewerbe) as foo using unique
ogc_fid USING SRID=25832

As bauwerksfunktion is an integer column my EXPRESSION definition was like
this in MaServer  6.0

EXPRESSION ([bauwerksfunktion] = 1210)
EXPRESSION ([bauwerksfunktion] = 1215 OR [bauwerksfunktion] = 1220 OR
[bauwerksfunktion] = 1250 OR [bauwerksfunktion] = 1260)

Now with MapServer 6.2 it does not work anymore:
* instead of a map I get an Internal Server Error

My Logfile says:
[Thu Nov 29 15:03:31 2012].824000 msEvalExpression(): General error
message. Invalid item index.

I also checked http://mapserver.org/mapfile/expressions.html

Does anyone has an idea?



___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users