Load Capabilities

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Load Capabilities

Gerd GD. Dreier
Hello

Why it is not possible to load this Capabilities?

WMS Url
http://www.gisguide.de/bin/mapserv.exe?map=../map/leitungen.map&&request=capabilities&wmtver=1.0.0

The XML Information loads correctly

Error Message:
file: http://www.gisguide.de/bin/mapserv.exe?map=../map/leitungen.map&&request=capabilities&wmtver=1.0.0INSERT INTO layer(fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_dataurl, layer_queryable, layer_minscale, layer_maxscale) VALUES(890,,'','','','',0,0,0)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''','','','',0,0,0)' at line 1
UPDATE ERROR -> KILL PROCESS AND ROLLBACK....................no update

INSERT INTO gui_wms (fkey_gui_id, fkey_wms_id, gui_wms_position, gui_wms_mapformat, gui_wms_featureinfoformat, gui_wms_exceptionformat, gui_wms_epsg)VALUES('OrkanWeb', 890, 9, '', '', '', '');
Cannot add or update a child row: a foreign key constraint fails
UPDATE ERROR -> KILL PROCESS AND ROLLBACK....................no update



Gruß Gerd Dreier
D&T Ingenieure GmbH
Konrad-Zuse-Straße 3, 37671 Höxter,
Tel: 05271 / 923-45  Fax: 923-44
Home: http://www.DT-Ingenieure.de
e-Mail: [hidden email]




-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Mapbender-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/mapbender-users
Reply | Threaded
Open this post in threaded view
|

Re: Load Capabilities

Arnulf
Gerd GD. Dreier wrote:

> Hello
>
> Why it is not possible to load this Capabilities?
>
> WMS Url
> http://www.gisguide.de/bin/mapserv.exe?map=../map/leitungen.map&&request=capabilities&wmtver=1.0.0
>
> The XML Information loads correctly
>
> Error Message:
> file: http://www.gisguide.de/bin/mapserv.exe?map=../map/leitungen.map&&request=capabilities&wmtver=1.0.0INSERT INTO layer(fkey_wms_id, layer_pos, layer_parent, layer_name, layer_title, layer_dataurl, layer_queryable, layer_minscale, layer_maxscale) VALUES(890,,'','','','',0,0,0)
> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''','','','',0,0,0)' at line 1
> UPDATE ERROR -> KILL PROCESS AND ROLLBACK....................no update
>
> INSERT INTO gui_wms (fkey_gui_id, fkey_wms_id, gui_wms_position, gui_wms_mapformat, gui_wms_featureinfoformat, gui_wms_exceptionformat, gui_wms_epsg)VALUES('OrkanWeb', 890, 9, '', '', '', '');
> Cannot add or update a child row: a foreign key constraint fails
> UPDATE ERROR -> KILL PROCESS AND ROLLBACK....................no update

Hi,
seems like nobody has answered yet? Everybody is so busy these days...

Probably your server is not allowed to open a URL as a file which is
necessary to analyze and dump it to the Mapbender database. The effect
ist that the PHP skript does not receive anything and thuis thinks the
Capabilities documebnt is broken. Read the details in the Wiki:
http://wms1.ccgis.de/ewiki/index.php?id=allow_url_fopen

+++
I just checked:
http://www.gisguide.de/bin/mapserv.exe?map=../map/leitungen.map

The server is not available, so your problem might also be that the
MapsServer cannot be found via URL. If you post me the correct link
(offlist if required) I can test it.

Best, Arnulf.

> Gruß Gerd Dreier
> D&T Ingenieure GmbH
> Konrad-Zuse-Straße 3, 37671 Höxter,
> Tel: 05271 / 923-45  Fax: 923-44
> Home: http://www.DT-Ingenieure.de
> e-Mail: [hidden email]
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Mapbender-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/mapbender-users



-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
Mapbender-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/mapbender-users