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@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