<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>problems when installing rc6</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">Hi List, </FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">i tried to install the new Version number (2.5rc6).</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">If you make a fully new installation you will run through an error while filling the database.</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">###########</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">ERROR: column "wms_mb_getcapabilities_doc" of relation "wms" does not exist</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">#########</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">The reason for this error is the pgsql_schema.sql</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">the statement of the wms-table creating is not correct.</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">(Here a short snapout from line 630-663).</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">#######################################################################</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">CREATE TABLE wms (</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_id serial NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_version character varying(50) DEFAULT ''::character varying NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_title character varying(255) DEFAULT ''::character varying NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_abstract text,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_getcapabilities character varying(255) DEFAULT ''::character varying NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_getmap character varying(255) DEFAULT ''::character varying NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_getfeatureinfo character varying(255) DEFAULT ''::character varying NOT NULL,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_getlegendurl character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_filter character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_getcapabilities_doc text,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_owsproxy character varying(50),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_upload_url character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> fees character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> accessconstraints text,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactperson character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactposition character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactorganization character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> address character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> city character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> stateorprovince character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> postcode character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> country character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactvoicetelephone character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactfacsimiletelephone character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> contactelectronicmailaddress character varying(255),</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">>>>> wms_mb_getcapabilies_doc text,<<<</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_owner integer,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_timestamp integer,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_supportsld boolean,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_userlayer boolean,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_userstyle boolean,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New"> wms_remotewfs boolean</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">);</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">##################################################################</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">line 656 must rewrite from </FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">wms_mb_getcapabilies_doc >> wms_mb_getcapabilities_doc </FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">after this changing everything runs fine.<BR>
</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">Greetings </FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">Marc<BR>
</FONT></SPAN>
</P>
</BODY>
</HTML>