[Cartoweb-users] error configuring demoEdit plugin

[Oliver Christen]

Hi

please check if you have an "oid" column in your table in postgres.
otherwise, you may try to you add a "using unique" in your data string specifing the column id to use for unique identifiant.
edit the mapfile and look for the layers EDITPOLY, EDITLINE and EDITPOINT and add the corresponding strings:

"using unique parc_id" for EDITPOLY

"using unique id" for EDITLINE and EDITPOINT

like this:
DATA 'the_geom from (select the_geom, oid, parc_id, name, culture, surf, parc_type  from edit_poly) as foo using unique parc_id'
DATA 'the_geom from (select the_geom, oid, id, name, length from edit_line) as foo using unique id'
DATA 'the_geom from (select the_geom, oid, id, name, surname, place, age from edit_point) as foo using unique id'

you may also have to add "using SRID=the_data_projection" if the data projection is different from your mapfile projection

regards
Oliver
  ----- Original Message ----- 
  From: Ramkumar Acharyulu 
  To: cartoweb-users at lists.maptools.org 
  Sent: Tuesday, April 27, 2010 7:57 AM
  Subject: [Cartoweb-users] error configuring demoEdit plugin


  Dear Bruno,

  I had a similar problem as reported by jefe, as i used CW3.5 with PostGRE8.4/PostGIS 1.5.1.

  Noting from your reply i downgraded to PostGRE8.3 and PostGIS1.3.5. But the problem still remains.
  Could you please immediately help me as i need to complete a project in time.

  Let me repeat the error content:


FailureCartoWeb version: 3.5.0 [$Revision: 1.9 $]> class:   SoapFaultWrapper> message:   MapServer error: Error in msPOSTGISLayerRetrievePGVersion(): Error 
> executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select > substring(version() from 12 for (position('on' in version()) - 13))> > Error in msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS statement 
> (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for > (position('on' in version()) - 13))> > Error in msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS statement 
> (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for > (position('on' in version()) - 13))> > > Backtrace:> > file: 230 - C:\ms4w\apps\cartoweb3\coreplugins\images\server\ServerImages.php
> call: ServerContext->checkMsErrors()> > file: 311 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php> call: ServerImages->drawMainmap(Object(Images))> > file: 349 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
> call: Cartoserver->doGetMap(Object(MapRequest))> > file: 370 - C:\ms4w\apps\cartoweb3\server\Cartoserver.php
  -- 
  N. Ram kumar Acharyulu



------------------------------------------------------------------------------


  _______________________________________________
  Cartoweb-users mailing list
  Cartoweb-users at lists.maptools.org
  http://lists.maptools.org/mailman/listinfo/cartoweb-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20100427/32785055/attachment.htm