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

[Jacolin Yves]

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/