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