[Cartoweb-users] Error when querying a postgis table

jerome jerome.caba at vanoise.com
Tue Jun 6 11:23:12 EDT 2006


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





More information about the Cartoweb-users mailing list