[Mapbender-users] uploading WFS capabilities

Astrid Emde astrid.emde at ccgis.de
Tue Jul 25 09:23:32 EDT 2006

Daniel Goetz schrieb:
> Hi mapbender-community,
> I build up a little wfs-server (on a local umn-mapserver installation; ms4w 1.5.3). Now I want to implement this wfs-service in mapbender. 
> Therefor I orientated myself on the WFS-Configuration Guide from the mapbender-wiki (http://www.mapbender.org/index.php/WFS_Konfiguration). So I logged in and went to the "admin_1" user interface. There I created a new GUI and then I wanted to upload the Capabilities of my WFS. But when I choose a GUI in the "Load WFS" menue (where to laod the WFS-Capabilities) there appears an error message saying:
> Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: missing FROM-clause entry for table "gui_wfs" in C:\ms4w\Apache\htdocs\mapbender\http\php\database-pgsql.php on line 121
> Note that this warning appears right after I have chosen a GUI where to load the WFS-Capabilities (no upload has taken place till this point).
> So I opened the database-pgsql.php but to be honest I am not that good in php reading and writing, so I do not understand what's going on in this file. But I activated the echoing of the sql-statements in line 122 of the database-pgsql.php. The SQL statement that causes the error-message is the following:
> SQL: SELECT Distinct wfs.wfs_title from gui_wfs, gui LEFT JOIN wfs ON gui_wfs.fkey_wfs_id=wfs.wfs_id and gui_wfs.fkey_gui_id=gui.gui_id where gui.gui_name='WFS_Test' order by wfs.wfs_title

Hello Daniel,

  it seam, that you do not use an actual Mapbender.

The SQL in the file mod_loadWFSCapabilities.php changed.

SELECT Distinct wfs.wfs_title from gui_wfs LEFT JOIN wfs ON 
gui_wfs.fkey_wfs_id=wfs.wfs_id where gui_wfs.fkey_gui_id = 'r' order by 

Maybe it would be good to update on the actual Mapbender version, as the 
WFS handling enhanced.

Mapbender Version 2.4 is coming out in the next days.

Schönen Gruß

Astrid Emde


  Astrid Emde
  Siemensstraße 8
  53121 Bonn

   astrid.emde at ccgis.de
  Tel.:      ++49 (0) 228 90826 19
  Fax.:      ++49 (0) 228 90826 11
  Zentrale:  ++49 (0) 228 90826 0

More information about the Mapbender_users mailing list