AW: [mapserver-users] GetFeatureInfo problem

[Schönhammer, Herbert]

Hi,

I observed a similar problem changing from mapserver 4.10.x to mapserver 5.x.x. I got the identical error message, but I'm using postgis.

Defining a wfs, you must define a DATA statement.

In your case something like this:

    DATA 'KGEOM(?) from (SELECT BLOAZ, TAJOL, MERAR, ORT1X, ORT1Y, ORT2X, ORT2Y, KGEOM, TGEOM, SORSZAM, bgeom FROM blokk_a0 WHERE sorszam = 26 as foo using unique xxx using SRID=yyyy'

In my case, the error occured, if the datatype of attribute xxx was a character datatype (like character varying). This is allowed by mapserver 4.x.x.

Mapserver 5.x.x expects a numeric datatype (int or serial or something like this) as datatype for the fid attribute.

So in my case changing the datatype of the fid attribute solved the problem. Perhaps this might ba a solution for you too.

regards
Herbert




>-----Ursprüngliche Nachricht-----
>Von: mapserver-users-bounces at lists.osgeo.org
>[mailto:mapserver-users-bounces at lists.osgeo.org] Im Auftrag
>von Balázs Bámer
>Gesendet: Montag, 9. Februar 2009 22:10
>An: mapserver-users at lists.osgeo.org
>Betreff: [mapserver-users] GetFeatureInfo problem
>
>
>Hi All,
>
>My OS is Ubuntu 8.10, Mapbender is 2.5, WMS is Mapserver 5.2.1 which
>seems all right, I have an experimental MapBender GUI:
>http://att-it.homelinux.net:22080/mapbender/
>user: mapbenderlist, pass: =]-[0p
>For non-Mapbender users, feature info is requested with the 'i' button
>for any feature.
>
>Feature info function hasn't worked for me yet. When I try red
>features (layer szerkesztheto), it seems OK but no info shown at all.
>Same for the point layer.
>For green ones (csakolv), an error message is returned:
>msOracleSpatialLayerGetShape(): OracleSpatial error. Error: ORA-00932:
>inconsistent datatypes: expected %s got %s
> . Query statement: SELECT BLOAZ, TAJOL, MERAR, ORT1X, ORT1Y, ORT2X,
>ORT2Y, KGEOM, TGEOM, SORSZAM, bgeom FROM blokk_a0 WHERE sorszam = 26
>.Check your data statement.
>Which, however, works in SQL Developer. The above message is shown
>also in Mapserver log. You can see my map settings here:
>http://att-it.homelinux.net:22080/cgi-bin/spatial?SERVICE=WMS&V
ERSION=1.1.1&REQUEST=GetCapabilities

What goes wrong for the error and the nothing-shown case?

thank you in advance.
Best regards: Balázs Bámer
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users