[Cartoweb-users] [Edit] layer configuration in postgresql

[Jacolin Yves]

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/