<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>