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 : SoapFaultWrapperAt 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.
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.
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 [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
