[Mapbender-users] Error when WMS updatet or add

[Christoph Baudson]

vollbotz schrieb:
> hi list,
>
> if i would like to update a wms i got the message:
>
> Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: null value
> in column "wms_version" violates not-null constraint in
> /usr/local/fgs/www/htdocs/mapbender/http/php/database-pgsql.php on line 176
> sql error: ERROR: null value in column "wms_version" violates not-null
> constraint ROLLBACK performed....
>   

Mapbender seems to be unable to parse the capabilities document for the 
version number. Can you supply the capabilities XML?

> If i use the [Preview Capabilities] Button on update - it works fine....
>
> If i want to add a new wms i got:
>
> file:
> http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetCapabilities
> Missing parameters:
>
> id:
> version:
> title:
> abstract:
> maprequest:
> capabilitiesrequest:
> featureinforequest:
> gui_wms_mapformat:
> gui_wms_featureinfoformat:
> gui_wms_exceptionformat:
> gui_wms_epsg:
> wms_srs:
> gui_wms_visible:
> gui_wms_opacity:
> support_sld:
> wms Object ( [lastURL] => [wms_id] => [wms_status] => [wms_version] =>
> [wms_title] => [wms_abstract] => [wms_getcapabilities] =>
> [wms_getcapabilities_doc] => [wms_getmap] => [wms_getfeatureinfo] =>
> [wms_getlegendurl] => [wms_upload_url] => [fees] => [accessconstraints] =>
> [contactperson] => [contactposition] => [contactorganization] => [address]
> => [city] => [stateorprovince] => [postcode] => [country] =>
> [contactvoicetelephone] => [contactfacsimiletelephone] =>
> [contactelectronicmailaddress] => [wms_keyword] => Array ( ) [data_type] =>
> Array ( ) [data_format] => Array ( ) [objLayer] => Array ( )
> [wms_supportsld] => [wms_userlayer] => [wms_userstyle] => [wms_remotewfs] =>
> [gui_wms_mapformat] => [gui_wms_featureinfoformat] =>
> [gui_wms_exceptionformat] => [gui_wms_epsg] => [gui_wms_sldurl] =>
> [default_epsg] => 0 [overwrite] => 1 )
> Data not committed
>
> ----------------------------------------------------------
>
> if i add a new one by downloading the capabilities.xml i got:
>
> file: http://200.1.50.21:8080/mapbender/wms/Luftbild.xml
> Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: value too
> long for type character varying(255) in
> /usr/local/fgs/www/htdocs/mapbender/http/php/database-pgsql.php on line 176
> sql error: ERROR: value too long for type character varying(255) ROLLBACK
> performed....
>   

Some data won't fit in the database column...again, please submit the 
capabilities XML.

> -------------------------------------------------------------
> I thing that this problem has happend a few times ago....
> there you should download a new class_wms.php
> (i tried this but it wont help)
>
>   
>> Does anyonw have an idea ??
>>     
>
> - i use mapbender 2.5rc5
> - postgres 8.3.1
> - suse linux sls 10
>
> Thanks (again) a lot !   V°°
>   

Thanks

Christoph

-- 
_______________________________________

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

Siemensstraße 8
53121 Bonn
Germany

Christoph Baudson
Anwendungsentwickler

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

Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________