Hi, The problem came from an error on the parameter : "id_attribut_string" instead of "id_attribute_string" (the e was missing !)
Y. Le Jeudi 6 Avril 2006 17:52, vous avez écrit : > What if you try with "oid" as "id_attribute_string" ? > > Pierre GIRAUD > > Jacolin Yves wrote: > >Hi, > >I am testing the edit plugin. I got a problem with it : > >if I use the edit_poly postgresql layer (ie EDITPOLY layer in mapfile) all > >work fine ! But I imported a shapefile with shp2pgsql in my database. I > > can create new shapes and edit their attribut, but the selection failed > > so I can not update, delete my shape. > > > >The mapfile contains : > > LAYER > > NAME espece > > STATUS ON > > TYPE POLYGON > > CONNECTIONTYPE POSTGIS > > CONNECTION 'dbname=edit_db user=postgres password=postgres > > host=localhost' DATA 'the_geom from (select the_geom, oid, gid, nom, > > code, patrimon from espece) as foo' > > TEMPLATE 'ttt' > > LABELITEM "nom" > > CLASS > > NAME "class" > > STYLE > > COLOR 50 50 255 > > OUTLINECOLOR 255 50 50 > > END > > LABEL > > FONT "Vera" > > TYPE TRUETYPE > > SIZE 7 > > OUTLINECOLOR 255 255 255 > > COLOR 0 0 0 > > POSITION cc > > END > > END > > METADATA > > 'id_attribut_string' 'gid' #query > > 'query_returned_attributes' 'gid nom code patrimon' > > 'edit_table' 'espece' # PostGIS table > > 'edit_geometry_column' 'the_geom' # PostGIS geometry column > > 'edit_geometry_type' 'polygon' # PostGIS geometry type > > 'edit_srid' '-1' > > 'edit_attributes' 'gid,nom|string,code|string,patrimon|integer' # > > list of the editable fields > > 'edit_filter' '' # Mapserver filter > > END > > END > > > >That is very similar to the EDITPOLY layer. My layer got this fields : > >gid integer NOT NULL > >nextval('public.espece_gid_seq'::text) > >id integer > >nom character varying(100) > >code character varying(10) > >patrimon smallint > >the_geom geometry > > > >gid and id seems to have same fonction (idenfication). gid would be > > created by shp2pgsql ?! > > > >The error message that appears after trying to select a shape is : > >class: SoapFaultWrapper > >message: Error [8, Undefined > >index: , /var/www/html/cartoweb3/plugins/edit/server/ServerEdit.php, 429] > >Backtrace: > > > >file: 275 - /var/www/html/cartoweb3/common/Common.php > >call: Common::cartowebErrorHandler() > > > >file: 429 - /var/www/html/cartoweb3/plugins/edit/server/ServerEdit.php > >call: Common::cartowebErrorHandler() > > > >Have you got an idea ? > > > >Y. -- Yves Jacolin http://yjacolin.gloobe.org ---- Stagaire Conservatoire Régional des Espaces Naturels de la région Centre http://cahiersnaturalistes.free.fr/cpnrc/ -- Yves Jacolin http://yjacolin.gloobe.org ---- Stagaire Conservatoire Régional des Espaces Naturels de la région Centre http://cahiersnaturalistes.free.fr/cpnrc/ _______________________________________________ Cartoweb-users mailing list Cartoweb-users@lists.maptools.org http://lists.maptools.org/mailman/listinfo/cartoweb-users