[Cartoweb-users] Edit Plugin - Postgis connection problem

Nikos Papadakis nipapada at gmail.com
Thu Sep 18 11:53:18 EDT 2008

Hello again!

I set the connection parameters exactly as in the demoEdit.map file.
But still i get the following error message:

CartoWeb version: 3.4.0 [$Revision: 1.7 $]
class:   SoapFaultWrapper
message:   MapServer error: Error in msDrawMap(): Failed to draw layer named 'bank_store'.

Error in prepare_database(): Error executing POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from (select the_geom,label from volos) as foo WHERE the_geom && setSRID('BOX3D(22.865 39.3060837563439,23 39.4005161436561)'::BOX3D, find_srid('','volos','the_geom') )' 

Postgresql reports the error as 'ERROR:  column "oid" does not exist
LINE 1: ...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ...

I have mapserver version 5.0.2
and a postgis database with a table named 'volos'.
The table has 7 columns which are created with the following script 
(taken from pgAdmin)

  gid serial NOT NULL,
  v_poi_ integer,
  v_poi_id integer,
  city character varying(30),
  city_lat character varying(30),
  label character varying(70),
  the_geom geometry

Finaly,this is the layer part that deals with the database connection.

I hope i have written all necessary information.
Thank you!!!

More information about the Cartoweb-users mailing list