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