[Mapbender-users] uploading WFS capabilities

[Astrid Emde]

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 
wfs.wfs_title

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
  CCGIS GbR
  Siemensstraße 8
  53121 Bonn
  Germany

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