<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Ramesh,<br>
<br>
glad to hear your problem seems to be solved.<br>
<br>
The columns you mentioned are added in some update-sqls (e.g.
update_2.7rc1_to_2.7rc2_pgsql_UTF-8.sql) which should have been
run automatically while installing mapbender. Did you use the
install.bat under resources\db\install.bat? It should have created
some logfiles in the same dir (log_update.txt, err_update.txt...),
please take a look for errormessages concerning the mentioned
columns.<br>
I would like to solve this issue for future users...<br>
<br>
Bye<br>
Thomas<br>
<br>
Am 26.07.2012 09:33, schrieb Ramesh De Silva:<br>
</div>
<blockquote
cite="mid:CACVncoK6jXj78Tx66-noNH9d8BASonoayahVjMgcihdwXX_C5A@mail.gmail.com"
type="cite">Dear Thomas,
<div><br>
</div>
<div>Thanks for the directions.
<span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">By referring
to the log file; I found that "mod_loadwms.php" is referring
to a non existing column (uuid) in the relation "wms". So I
just added a new column in the relation "wms" in postgres
level. Then; when I tried to load the WMS; again I got a
similar issue for another relation (this time relation
"layer"). I did the same workaround. After that I was able to
load the WMS without any errors.</span> </div>
<div><br>
</div>
<div>I wonder whether it requires to address this issue in
"pgsql_schema_2.5.sql".</div>
<div><br>
</div>
<div>Thanks again.</div>
<div><br>
</div>
<div>Cheers</div>
<div>Ramesh</div>
<div><br>
<div class="gmail_quote">
On Thu, Jul 26, 2012 at 1:59 PM, Thomas Baschetti <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:info@thomas-baschetti.de" target="_blank">info@thomas-baschetti.de</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hi,<br>
<br>
do you see any errors in your logfiles (php and
postgresql)? Perhaps you have to activate logging to see
something there.<br>
Which MS4W-Version are you using?<br>
<br>
<br>
Thomas<br>
<br>
<br>
<br>
<br>
Am 26.07.2012 05:29, schrieb Ramesh De Silva:<br>
</div>
<blockquote type="cite">
<div>
<div class="h5">Hi,
<div><br>
</div>
<div>When I try to Load a new WMS ( which is running
in the same machine) using the "Load WMS" option
provided in admin interface; I come across the
following error message. I use Mapbender version
2.7.3. </div>
<div><br>
</div>
<div><b>f<span>ile: <a moz-do-not-send="true"
href="http://***.***.***.192/cgi-bin/mapserv.exe?map=/ms4w/apps/srilanka/sl.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0sql"
target="_blank">http://***.***.***.192/cgi-bin/mapserv.exe?map=/ms4w/apps/srilanka/sl.map&REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.0sql</a>
error: ERROR: unnamed prepared statement does
not exist ROLLBACK performed....</span></b></div>
<div><span style="font-family:'Times New
Roman';font-size:medium"><br>
</span></div>
<div><font size="3" face="Times New Roman">But if I
try to load the same WMS temporary using the
"Adding WMS" option in GUI Template Application;
it works fine. </font><span
style="font-family:'Times New
Roman';font-size:medium">Assuming it is a
database error; I tried with different versions
of PostgreSQL ( V 8.2 and 9.1.4); but the result
was the same.</span></div>
<div><font size="3" face="Times New Roman"><br>
</font></div>
<div><font size="3" face="Times New Roman">Also if I
use an older Mapbender version ( V 2.4) the WMS
loads permanently without any error. </font></div>
<div><font size="3" face="Times New Roman"><br>
</font></div>
<div><font size="3" face="Times New Roman">Please
provide me any possible solution for this issue.</font></div>
<div><font size="3" face="Times New Roman"><br>
</font></div>
<div><font size="3" face="Times New Roman">Thank
you.</font></div>
<div><font size="3" face="Times New Roman"><br>
</font></div>
<div><font size="3" face="Times New Roman">Cheers</font></div>
<div><font size="3" face="Times New Roman">Ramesh</font></div>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<div class="im">
<pre>_______________________________________________
Mapbender_users mailing list
<a moz-do-not-send="true" href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a>
<a moz-do-not-send="true" href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a>
</pre>
</div>
</blockquote>
<span class="HOEnZb"><font color="#888888"> <br>
</font></span></div>
</blockquote>
</div>
</div>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="172">--
Thomas Baschetti - Systemanalyse Geographische Informationssysteme
Hakenstraße 8D
49074 Osnabrück
Tel: 0541 25 91 90 | mobil 01577 189 25 91
E-Mail: <a class="moz-txt-link-abbreviated" href="mailto:info@thomas-baschetti.de">info@thomas-baschetti.de</a>
<a class="moz-txt-link-abbreviated" href="http://www.thomas-baschetti.de">www.thomas-baschetti.de</a>
Ust-IdNr.: DE264355072
</pre>
</body>
</html>