|
From: Hermann K. <Kar...@do...> - 2008-08-22 14:22:16
|
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 |