[Mapbender-dev] where updating fails

Christoph Baudson (WhereGroup) christoph.baudson at wheregroup.com
Fri Jan 4 06:11:56 EST 2008

The update process is very painful at the moment. I start this thread to 
gather where things go wrong. Please add, so we can find out what we 
have to improve.

Example: in Mapbender 2.5 we have a new table gui_wfs_conf. In the 
current update script we have a line like this

INSERT INTO gui_wfs_conf (fkey_gui_id, fkey_wfs_conf_id) VALUES 
('gui_digitize', 1);

which links the GUI "gui_digitize" to wfs_conf with Id 1. This is done 
to restrict access to this WFS conf to users who have access to 

Of course, an update SQL should link "all" GUIs that use configured WFS. 
As far as I can see, we would need to check the element vars for 
wfs_conf_id_string, see if the wfs conf id is listed, and then link 
them. Tricky, at least in SQL.


W h e r e G r o u p GmbH & Co. KG

Siemensstraße 8
53121 Bonn

Christoph Baudson

Fon: +49 (0)228 / 90 90 38 - 25
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
Amtsgericht Bonn, HRA 6788

WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm

More information about the Mapbender_dev mailing list