[Cartoweb-users] Please help: problem with query layers.

[Pierre GIRAUD]

What version of mapserver/mapscript are you using ? Do you have 
postgresql errors ?
In the case mapserver 4.8.1is installed on your server, you are probably 
facing a reported bug : 
http://mapserver.gis.umn.edu/bugs/show_bug.cgi?id=1629

If your server is runing the debian packages, you should upgrade your 
system with the new patched packages for php5-mapscript.

Regards

Xiaoyun Tang wrote:

> Hi:
> Please help!
>
> We have set up Cartoweb 3.2.0 on our server, which retrieve data from 
> out database (PostgreSQL) and display many dots in a the layer 
> (mytest). It looks great!
>
> Now we want to query the layer (mytest) and encounter problems. We are 
> able to query the layer and display the data in a query result table. 
> But when we do it the second time without clicking on  "query_clear" 
> button,  we got errors:
>
>Class : SoapFaultWrapper
>Message : Attribute query returned no results. Layer: mytest, idAttribute: taxon_id, query: taxon_id in ('NCERO0100','NCOCO0090','NCOCO0100','NCOCO0330','NCYCC0050','NCYCC0100','NCYCC0130','NDISC0030','NDISC0035','NDISC0080','NDISC0090','NDISC0100','NDISC0155','NDISC0165','NDISC0225','NDISC0300','NDISC0310','NDISC0350','NDISC0360','NDISC0465','NDISC0505','NDISC0525','NHELI0100','NHELI0140','NHELI0160','NRETI0180','NSPHN0120','NSPHN0140','NSPHN0190','NTRIQ0040')
>
>Backtrace:
>
>file: 254 - /mnt/md0/apache2/htdocs/cartoweb3/coreplugins/mapquery/server/ServerMapquery.php
>call: ServerMapquery->queryLayerByAttributes(Object(ServerContext), "mytest", "taxon_id", "taxon_id in ('NCERO0100','NCOCO0090','NCOCO0100','NCOCO0330','NC...", False)
>
>
>file: 280 - /mnt/md0/apache2/htdocs/cartoweb3/coreplugins/query/server/ServerQuery.php
>call: ServerMapquery->queryByIdSelection(Object(QuerySelection))
>...
>...
>...
>
>and more stack error information.
>
>
> At the same time, we did a test on another layer which is generated 
> from a shape file, and we are able to do queries on that layer.
>
> Here is the definition of "mytest" layer:
>
> LAYER
>   CONNECTIONTYPE postgis
>   NAME "mytest"
>   CONNECTION "user=xxx password=xxx dbname=xxx host=xxx"
> DATA "geom from (select distinct a.geom,d.oid as oid, d.* from 
> neptune_hole_spatial a, neptune_hole_summary b, neptune_hole_taxa c, 
> neptune_taxonomy d where a.hole_id = b.hole_id and b.site_hole = 
> c.site_hole and c.taxon_id = d.taxon_id and fossil_group = 'N') as 
> nanno_hole_taxa using unique oid using SRID=4326"
>   STATUS default
>   TYPE POINT
>   DEBUG ON
>   #FILTER "taxon_id !=null"
>   PROJECTION
>     "init=epsg:4326"
>   END
> CLASS
>       NAME "nanno_hole_taxa"
>       STYLE
>         SYMBOL "circle"
>         SIZE 10
>         COLOR 90 27 191
>       END
>   END
>   TOLERANCE 100
>  TEMPLATE "tt"
>     METADATA
>       "id_attribute_string" "taxon_id|string"
>       "query_returned_attributes" "taxon_id taxon_status genus species" 
>    ## taxon_status, genus, species are column name in database
>     END
> END
>
> Thank you for your help,
> -- 
> Xiaoyun Tang
>
>------------------------------------------------------------------------
>
>_______________________________________________
>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