[Mapstorer-users] problem with first_mapfile

[Hermann K. <Kar...@do...>]

Dear List,

first_mapfile

if I try to open the mapobject
i get MDB2 Error: unknown error _do Query:[Error message: Could not
execute statement]
.......
[Native Message: Error: column >>angle<< does not exist.....]

if I try to open the legend
i get MDB2 Error: unknown error _do Query:[Error message: Could not
execute statement]
.......
[Native Message: Error: column >>template<< does not exist.....]

i executed the queries in pgadmin, the results told me, several columns
do not exist in the tbl_mapobject and in the tbl_legend

anyone who knows what to do

Karl


/*first_mapfile*/

/*Legend
this query produces error*/
--SELECT mapobject_id, legend_id, imagecolor_r, imagecolor_g,
imagecolor_b, interlace, outlinecolor_r, outlinecolor_g, outlinecolor_b,
position, keysize_x, keysize_y, keyspacing_x, keyspacing_y,
postlabelcache, status, transparent,template, chk_legend,
chk_imagecolor, chk_interlace, chk_outlinecolor, chk_position,
chk_keysize, chk_keyspacing, chk_postlabelcache, chk_status,
chk_transparent,chk_template FROM tbl_legend WHERE mapobject_id = 137
/*ERROR:  column >template< does not exist
LINE 4: ...keyspacing_y, postlabelcache, status, transparent,template,
...*/

/*this query works*/
-- SELECT mapobject_id, legend_id, imagecolor_r, imagecolor_g,
imagecolor_b, interlace, outlinecolor_r, outlinecolor_g, outlinecolor_b,
position, keysize_x, keysize_y, keyspacing_x, keyspacing_y,
postlabelcache, status, transparent, chk_legend, chk_imagecolor,
chk_interlace, chk_outlinecolor, chk_position, chk_keysize,
chk_keyspacing, chk_postlabelcache, chk_status, chk_transparent FROM
tbl_legend WHERE mapobject_id = 137

/*MapObject
this query produces error*/
--SELECT mapobject_id, angle, name, config_key, config_value,
datapattern, debug, extent_minx, extent_miny, extent_maxx, extent_maxy,
fontset, imagecolor_r, imagecolor_g, imagecolor_b, imagequality,
imagetype, mapobj_include, mapobj_include2, mapobj_include3,
mapobj_include4, mapobj_include5,interlace, mapobj_maxsize, resolution,
scale, shapepath, size_x, size_y, status, symbolset, templatepattern,
transparent, units, chk_angle, chk_mapobject, chk_name, chk_config,
chk_datapattern, chk_debug, chk_extent, chk_fontset, chk_imagecolor,
chk_imagequality, chk_imagetype, chk_include, chk_include2,
chk_include3, chk_include4, chk_include5, chk_interlace,
chk_maxsize,chk_resolution, chk_scale, chk_shapepath, chk_size,
chk_status, chk_symbolset, chk_templatepattern, chk_transparent,
chk_units FROM tbl_mapobject WHERE mapobject_id = 137
/*ERROR:  Column >angle< does not exist
LINE 12: SELECT mapobject_id, angle, name, config_key, config_value,
...*/

/*this query works*/
-- SELECT mapobject_id, name, config_key, config_value, datapattern,
debug, extent_minx, extent_miny, extent_maxx, extent_maxy, fontset,
imagecolor_r, imagecolor_g, imagecolor_b, imagequality, imagetype,
interlace, resolution, scale, shapepath, size_x, size_y, status,
symbolset, templatepattern, transparent, units, chk_mapobject, chk_name,
chk_config, chk_datapattern, chk_debug, chk_extent, chk_fontset,
chk_imagetype, chk_interlace, chk_resolution, chk_scale, chk_shapepath,
chk_size, chk_status, chk_symbolset, chk_templatepattern,
chk_transparent, chk_units FROM tbl_mapobject WHERE mapobject_id = 137