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 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 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 href="mailto:Mapbender_users@lists.osgeo.org" target="_blank">Mapbender_users@lists.osgeo.org</a>
<a 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>
<br>
<pre 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 href="mailto:info@thomas-baschetti.de" target="_blank">info@thomas-baschetti.de</a>
<a href="http://www.thomas-baschetti.de" target="_blank">www.thomas-baschetti.de</a>
Ust-IdNr.: DE264355072
</pre>
</font></span></div>
<br>_______________________________________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapbender_users</a><br>
<br></blockquote></div><br></div>