[Cartoweb-users] Error when querying a postgis table

[Pierre GIRAUD]

Salut Jérôme,

the problem you encountered is due to a Mapserver bug.
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1629

It is now fixed in the current stable version of Mapserver.

When the Cartoweb 3.3 will come out (during June), there will be a 
windows installer including this new version.

Pierre

jerome wrote:

> Hello at all,
>
> I'm newbie with Cartoweb. I've installed Cartoweb3.2.0 with Apache2 
> (Win32) / PHP5 / MapServer 4.8.1. I've created a new project 
> successfully and I can query all datas that commes with shapefiles. 
> Unfortunatly, I can't query postgis datas. When I reference a postgis 
> table (or a postgis query) in the mapfile, I can view it but if I try 
> to query one or more feature in the layer, I obtain this message :
>
> class:   SoapFaultWrapper
> message:   Attribute query returned no results. Layer: quartierbqea, 
> idAttribute: type_quartierbqea, query: type_quartierbqea in ('zones 
> occasionnelles')
> Backtrace:
> file: 254 - 
> C:\wamp\www\cartoweb3\coreplugins\mapquery\server\ServerMapquery.php
> call: ServerMapquery->queryLayerByAttributes(Object(ServerContext), 
> "quartierbqea", "type_quartierbqea", "type_quartierbqea in ('zones 
> occasionnelles')", False)
>
> file: 381 - 
> C:\wamp\www\cartoweb3\coreplugins\query\server\ServerQuery.php
> call: ServerMapquery->queryByIdSelection(Object(QuerySelection))
>
> file: 464 - 
> C:\wamp\www\cartoweb3\coreplugins\query\server\ServerQuery.php
> call: ServerQuery->hilight(Array(2), Array(2))
>
> file: 74 - C:\wamp\www\cartoweb3\server\ServerPluginHelper.php
> call: ServerQuery->handlePreDrawing(Object(QueryRequest))
>
> file: 133 - C:\wamp\www\cartoweb3\server\ServerPluginHelper.php
> call: ServerPluginHelper->callHandleFunction(Object(ServerQuery), 
> "handlePreDrawing")
>
> file: UNKNOWN - UNKNOWN
> call: ClientResponderHelper->handlePreDrawingHelper(Object(ServerQuery))
>
> etc....
>
> the layer in the mapfile is called by :
>  LAYER
>    NAME "quartierbqea"
>    TYPE POLYGON
>    CONNECTION "user=postgres dbname=Gesalp host=192.168.2.6"
>    CONNECTIONTYPE POSTGIS
>    DATA "geomquartierbqea25 from (select 
> gid,geomquartierbqea25,type_quartierbqea FROM 
> quartierseteautomnebouquetin) as foo using unique gid using SRID=27582"
>    TEMPLATE "ttt"
>    CLASS
>      NAME "type_quartierbqea"
>      STYLE
>    COLOR 134 100 10
>    OUTLINECOLOR 0 0 0
>      END
>    END
>    METADATA
>      "id_attribute_string" "type_quartierbqea"
>    END
>  END
>
> Do I make something wrong ?
> Many thanks
>
> Jerome Caba
> National Park of Vanoise
>
>
>
> _______________________________________________
> Cartoweb-users mailing list
> Cartoweb-users at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/cartoweb-users



-- 
_________________________________________________________
Pierre GIRAUD
Géomaticien, Analyste

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex 

Tel : 00 33 4 79 44 44 93
Mail : pierre.giraud at camptocamp.com
http://www.camptocamp.com