[Mapbender-commits] r7872 -
branches/2.7/resources/db/pgsql/UTF-8/update
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Wed Jun 15 12:10:50 EDT 2011
Author: astrid_emde
Date: 2011-06-15 09:10:50 -0700 (Wed, 15 Jun 2011)
New Revision: 7872
Modified:
branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
Log:
#786 when savewmc is part of the application we nee jq_ui..
Modified: branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql
===================================================================
--- branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql 2011-06-15 15:40:02 UTC (rev 7871)
+++ branches/2.7/resources/db/pgsql/UTF-8/update/update_2.7.1_to_2.7.2_pgsql_UTF-8.sql 2011-06-15 16:10:50 UTC (rev 7872)
@@ -32,3 +32,34 @@
UPDATE gui_element set e_attributes = 'href = "../php/mod_category_filteredGUI.php?sessionID&e_id_css=category_filteredGUI"' where fkey_gui_id = 'Administration_DE' and e_id ='category_filteredGUI' ;
UPDATE gui_element set e_attributes = 'href = "../php/mod_category_filteredGUI.php?sessionID&e_id_css=category_filteredGUI"' where fkey_gui_id = 'Administration' and e_id ='category_filteredGUI' ;
+
+--
+-- refers to #786: after update the applications with savewmc and load wmc do not work as jq_ui_dialog and button are missing
+--
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title,
+e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles,
+e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url)
+Select fkey_gui_id, foo.* from (
+SELECT 'jq_ui_button',e_pos,e_public,e_comment,e_title,e_element, e_src, e_attributes,
+e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag,
+e_js_file, e_mb_mod, e_target, e_requires, e_url FROM gui_element
+WHERE e_id = 'jq_ui_button' AND fkey_gui_id = 'gui1'
+) as foo , gui_element where e_id = 'loadwmc' AND fkey_gui_id IN
+ (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'loadwmc' AND fkey_gui_id NOT IN (
+ SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_ui_button'
+ ));
+
+
+INSERT INTO gui_element(fkey_gui_id, e_id, e_pos, e_public, e_comment, e_title,
+e_element, e_src, e_attributes, e_left, e_top, e_width, e_height, e_z_index, e_more_styles,
+e_content, e_closetag, e_js_file, e_mb_mod, e_target, e_requires, e_url)
+Select fkey_gui_id, foo.* from (
+SELECT 'jq_ui_dialog',e_pos,e_public,e_comment,e_title,e_element, e_src, e_attributes,
+e_left, e_top, e_width, e_height, e_z_index, e_more_styles, e_content, e_closetag,
+e_js_file, e_mb_mod, e_target, e_requires, e_url FROM gui_element
+WHERE e_id = 'jq_ui_dialog' AND fkey_gui_id = 'gui1'
+) as foo , gui_element where e_id = 'loadwmc' AND fkey_gui_id IN
+ (SELECT fkey_gui_id FROM gui_element WHERE e_id = 'loadwmc' AND fkey_gui_id NOT IN (
+ SELECT fkey_gui_id FROM gui_element WHERE e_id = 'jq_ui_dialog'
+ ));
+
More information about the Mapbender_commits
mailing list