4 Jul
2008
4 Jul
'08
5:57 a.m.
Hi,
Thanks for your Reply,
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 ;
+---------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+-------+
| table_name | varchar(32) | NO | | | |
| table_version | int(10) unsigned | NO | | 0 | |
+---------------+------------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
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...
--
Thanks & Regards,
Noble Antony Thattil.
On Fri, Jul 4, 2008 at 2:53 PM, Henning Westerholt <
henning.westerholt(a)1und1.de> wrote:
On Friday 04 July 2008, Noble Antony T wrote:
I have compiled the Openser with RLS module in my
desktop, and it seems
installation went fine...
But when I try to start the openser, I am getting the following
error.....
*
Jul 3 10:11:49 [10721] ERROR:core:table_version: invalid type (2) or nul
(0) version columns for xcap
Jul 3 10:11:49 [10721] DBG:core:db_free_rows: freeing 1 rows
Jul 3 10:11:49 [10721] DBG:core:db_free_rows: row[0]=0x815d530
Jul 3 10:11:49 [10721] DBG:core:db_free_rows: 0x815d530=pkg_free()
RES_ROWS Jul 3 10:11:49 [10721] ERROR:presence_xml:mod_init: Wrong
version
v-1 for table <xcap>, need v3
Jul 3 10:11:49 [10721] ERROR:core:init_mod: failed to initialize module
presence_xml
Jul 3 10:11:49 [10721] ERROR:core:main: error while initializing modules
Jul 3 10:11:49 [10721] DBG:rls:destroy: start*
But my MySQL shows, the version of XCAP as
*mysql> select * from version where table_name="xcap" ;
| xcap | 3 |
Though the version information is present for the xcap table, this error
is
coming.
Hi Noble Antony,
i've tried to reproduce your problem with the 1.3 branch of openser. On my
system i don't observe the error you've described. It seems that there
happens an error during the version table query (first log statement). Does
this happens all the time? Have you tried to install the DB again?
Cheers,
Henning