Hi,

yes, as you told, it was very strange for me too... :)

I have changed the code locally, and Openser is running now.......

may this information be helpful for some others...

stinbng46:/home/nthattil/tmp/src_openser_install# sudo aptitude search mysqlclient
v   liblibmysqlclient15-dev                               -
v   libmysqlclient-dev                                    -
v   libmysqlclient10-dev                                  -
iB  libmysqlclient12                                      - mysql database client library
v   libmysqlclient12-dev                                  -
v   libmysqlclient14-dev                                  -
v   libmysqlclient15                                      -
i   libmysqlclient15-dev                                  - MySQL database development files
iB  libmysqlclient15off                                   - MySQL database client library
v   libmysqlclient6-dev                                   -


stinbng46:/home/nthattil/tmp/src_openser_install# mysql -V
mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

stinbng46:/home/nthattil/tmp/src_openser_install# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 127
Server version: 5.0.32-Debian_7etch5-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> quit
Bye

--
Thanks & Regards,
Noble Antony Thattil.



On Fri, Jul 4, 2008 at 3:45 PM, Henning Westerholt <henning.westerholt@1und1.de> wrote:
On Friday 04 July 2008, Noble Antony T wrote:
> I tried at least 3 times deleting & recreating the Database... always I was
> getting this issue.
>
> What I observed is, the version table Query returns the data-type of the
> Version as DB_STRING (2), where as, it should have been DB_INT, so the
> function *table_version() *is returning as -1.
>
> But the value returned by the Query (String value) is correct.. (except
> that the data-type.)
>
> Database shows the correct type for the column....
>
> mysql> desc version ;
> | table_version | int(10) unsigned | NO   |     | 0       |       |
>
> I locally changed so that it returns the correct value, in INTEGER.
>
> Also this *table_version* function always finds the result as DB_STRING, it
> is not only for the *xcap* table, but for all the tables...

Hi,

this is indeed strange. Can you give some details about your system? What
version of the mysql-client and -server do you use?

Henning