problems when installing rc6

[Manns, Marc]

Some javascript/style in this post has been disabled (why?)

Hi List,

i tried to install the new Version number (2.5rc6).
If you make a fully new installation you will run through an error  while filling the database.

###########
ERROR: column "wms_mb_getcapabilities_doc" of relation "wms" does not exist
#########

The reason for this error is the pgsql_schema.sql

the statement of the wms-table creating is not correct.

(Here a short snapout from line 630-663).
#######################################################################

CREATE TABLE wms (
    wms_id serial NOT NULL,
    wms_version character varying(50) DEFAULT ''::character varying NOT NULL,
    wms_title character varying(255) DEFAULT ''::character varying NOT NULL,
    wms_abstract text,
    wms_getcapabilities character varying(255) DEFAULT ''::character varying NOT NULL,
    wms_getmap character varying(255) DEFAULT ''::character varying NOT NULL,
    wms_getfeatureinfo character varying(255) DEFAULT ''::character varying NOT NULL,
    wms_getlegendurl character varying(255),
    wms_filter character varying(255),
    wms_getcapabilities_doc text,
    wms_owsproxy character varying(50),
    wms_upload_url character varying(255),
    fees character varying(255),
    accessconstraints text,
    contactperson character varying(255),
    contactposition character varying(255),
    contactorganization character varying(255),
    address character varying(255),
    city character varying(255),
    stateorprovince character varying(255),
    postcode character varying(255),
    country character varying(255),
    contactvoicetelephone character varying(255),
    contactfacsimiletelephone character varying(255),
    contactelectronicmailaddress character varying(255),
>>>>    wms_mb_getcapabilies_doc text,<<<
    wms_owner integer,
    wms_timestamp integer,
    wms_supportsld boolean,
    wms_userlayer boolean,
    wms_userstyle boolean,
    wms_remotewfs boolean
);

##################################################################

line 656 must rewrite from

wms_mb_getcapabilies_doc >>  wms_mb_getcapabilities_doc

after this changing everything runs fine.

Greetings

Marc

_______________________________________________
Mapbender_users mailing list
Mapbender_users@...
http://lists.osgeo.org/mailman/listinfo/mapbender_users

[Christoph Baudson]

Thanks for letting us know.

The changes have somehow not made it into the schema dump. Please run
the update SQL file

update_2.5rc6_pgsql.sql

in the update folder (even on a fresh installation).



Manns, Marc schrieb:

>
>
> Hi List,
>
> i tried to install the new Version number (2.5rc6).
> If you make a fully new installation you will run through an error  
> while filling the database.
>
> ###########
> ERROR: column "wms_mb_getcapabilities_doc" of relation "wms" does not
> exist
> #########
>
> The reason for this error is the pgsql_schema.sql
>
> the statement of the wms-table creating is not correct.
>
>
> (Here a short snapout from line 630-663).
> #######################################################################
>
> CREATE TABLE wms (
>     wms_id serial NOT NULL,
>     wms_version character varying(50) DEFAULT ''::character varying
> NOT NULL,
>     wms_title character varying(255) DEFAULT ''::character varying NOT
> NULL,
>     wms_abstract text,
>     wms_getcapabilities character varying(255) DEFAULT ''::character
> varying NOT NULL,
>     wms_getmap character varying(255) DEFAULT ''::character varying
> NOT NULL,
>     wms_getfeatureinfo character varying(255) DEFAULT ''::character
> varying NOT NULL,
>     wms_getlegendurl character varying(255),
>     wms_filter character varying(255),
>     wms_getcapabilities_doc text,
>     wms_owsproxy character varying(50),
>     wms_upload_url character varying(255),
>     fees character varying(255),
>     accessconstraints text,
>     contactperson character varying(255),
>     contactposition character varying(255),
>     contactorganization character varying(255),
>     address character varying(255),
>     city character varying(255),
>     stateorprovince character varying(255),
>     postcode character varying(255),
>     country character varying(255),
>     contactvoicetelephone character varying(255),
>     contactfacsimiletelephone character varying(255),
>     contactelectronicmailaddress character varying(255),
> >>>>    wms_mb_getcapabilies_doc text,<<<
>     wms_owner integer,
>     wms_timestamp integer,
>     wms_supportsld boolean,
>     wms_userlayer boolean,
>     wms_userstyle boolean,
>     wms_remotewfs boolean
> );
>
>
> ##################################################################
>
>
> line 656 must rewrite from
>
> wms_mb_getcapabilies_doc >>  wms_mb_getcapabilities_doc
>
> after this changing everything runs fine.
>
>
> Greetings
>
> Marc
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Mapbender_users mailing list
> Mapbender_users@...
> http://lists.osgeo.org/mailman/listinfo/mapbender_users
>  

--
_______________________________________

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@...
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________

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



_______________________________________________
Mapbender_users mailing list
Mapbender_users@...
http://lists.osgeo.org/mailman/listinfo/mapbender_users