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