[Geomoose-users] Re: Feature Editor Adding Point, Line, Polygon Problems

[Brent Fraser]

Since the error message says it can't find a column named "id" (and your 
table uses "feature_id" as the key column), I expect the problem is a 
configuration problem in your mapbook.xml file.  Check your column names 
in your service definitions (modify, delete, and especially add) in your 
mapbook.xml and confirm it has

<input type="hidden" name="feature:feature_id"/>

Best Regards,
Brent Fraser


On 1/29/2012 3:11 AM, sana butt wrote:
> Hi Brent
> I have added polygon feature and its working, Now I have added point 
> using the same criteria available at feature editor guide, but its not 
> working.
> Could you please test the URL:
> http://216.58.43.167/geomoose2/geomoose.html
> and add point.
> What I have done so far:
> CREATE TABLE test_points
> (
>   feature_id integer NOT NULL,
>   attribute1 character varying(100),
>   attribute2 character varying(100),
>   wkb_geometry geometry,
>   CONSTRAINT pk_test_points PRIMARY KEY (feature_id)
> )
> CREATE SEQUENCE test_points_seq;
> insert into geometry_columns values ('', 'public', 'test_points', 
> 'wkb_geometry', 2, 24, 'GEOMETRY');
> and follow the instructions available in feature editor guide.
> I got this error in firefox.
> URL:
> http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269 
> <http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269>
> Error:
> msDrawMap(): Image handling error. Failed to draw layer named 
> 'points'. prepare_database(): Query error. Error declaring cursor: 
> ERROR: column "id" does not exist LINE 1: 
> ...b_geometry)),'NDR'),feature_id::text from (select id as feat... ^ 
> With query string: DECLARE mycursor BINARY CURSOR FOR SELECT 
> asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),feature_id::text 
> from (select id as feature_id, attribute1, attribute2, 
> astext(wkb_geometry) as wkt_geometry, wkb_geometry from test_points) 
> as mytable WHERE wkb_geometry && setSRID('BOX3D(457184.796930448 
> 4917749.476731,517616.418381552 4948205.476731)'::BOX3D, 24 )
> I dont know, where I made mistake in creating table, etc.
> Could you please help me solving this issue
> Regards
> Sana