Hi,<br><br>yes, as you told, it was very strange for me too... :)<br><br>I have changed the code locally, and Openser is running now.......<br><br>may this information be helpful for some others... <br><br><font size="2"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">stinbng46:/home/nthattil/tmp/src_openser_install# sudo aptitude search mysqlclient</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v liblibmysqlclient15-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient10-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">iB libmysqlclient12 - mysql database client library</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient12-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient14-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient15 -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">i libmysqlclient15-dev - MySQL database development files</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">iB libmysqlclient15off - MySQL database client library</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">v libmysqlclient6-dev -</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><br>
<br>stinbng46:/home/nthattil/tmp/src_openser_install# mysql -V</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><br>stinbng46:/home/nthattil/tmp/src_openser_install# mysql -u root -p</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Enter password:</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Welcome to the MySQL monitor. Commands end with ; or \g.</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Your MySQL connection id is 127</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Server version: 5.0.32-Debian_7etch5-log Debian etch distribution</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Type 'help;' or '\h' for help. Type '\c' to clear the buffer.</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<br style="font-family: courier new,monospace; color: rgb(0, 0, 153);"><span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">mysql> quit</span><br style="font-family: courier new,monospace; color: rgb(0, 0, 153);">
<span style="font-family: courier new,monospace; color: rgb(0, 0, 153);">Bye</span><br style="font-family: courier new,monospace;"></font><br>-- <br>Thanks & Regards,<br>Noble Antony Thattil.
<br><br><br><br><div class="gmail_quote">On Fri, Jul 4, 2008 at 3:45 PM, Henning Westerholt <<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Friday 04 July 2008, Noble Antony T wrote:<br>
</div><div class="Ih2E3d">> I tried at least 3 times deleting & recreating the Database... always I was<br>
> getting this issue.<br>
><br>
> What I observed is, the version table Query returns the data-type of the<br>
> Version as DB_STRING (2), where as, it should have been DB_INT, so the<br>
> function *table_version() *is returning as -1.<br>
><br>
> But the value returned by the Query (String value) is correct.. (except<br>
> that the data-type.)<br>
><br>
> Database shows the correct type for the column....<br>
><br>
> mysql> desc version ;<br>
</div><div class="Ih2E3d">> | table_version | int(10) unsigned | NO | | 0 | |<br>
><br>
</div><div class="Ih2E3d">> I locally changed so that it returns the correct value, in INTEGER.<br>
><br>
> Also this *table_version* function always finds the result as DB_STRING, it<br>
> is not only for the *xcap* table, but for all the tables...<br>
<br>
</div>Hi,<br>
<br>
this is indeed strange. Can you give some details about your system? What<br>
version of the mysql-client and -server do you use?<br>
<font color="#888888"><br>
Henning<br>
</font></blockquote></div><br><br>