Hi, <br><br>Thanks for your Reply,<br><br>I tried at least 3 times deleting & recreating the Database... always I was getting this issue.<br><br>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 <i><b>table_version() </b></i>is returning as -1.<br><br>But the value returned by the Query (String value) is correct.. (except that the data-type.)<br><br>Database shows the correct type for the column.... <br>
<br><span style="font-family: courier new,monospace;">mysql> desc version ;</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+---------------+------------------+------+-----+---------+-------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| Field | Type | Null | Key | Default | Extra |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">+---------------+------------------+------+-----+---------+-------+</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">| table_name | varchar(32) | NO | | | |</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">| table_version | int(10) unsigned | NO | | 0 | |</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">+---------------+------------------+------+-----+---------+-------+</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">2 rows in set (0.00 sec)</span><br style="font-family: courier new,monospace;">
<br><br>I locally changed so that it returns the correct value, in INTEGER.<br><br>Also this <i><b>table_version</b></i> function always finds the result as DB_STRING, it is not only for the <i><b>xcap</b></i> table, but for all the tables... <br>
<br>-- <br>Thanks & Regards,<br>Noble Antony Thattil.
<br><br><div class="gmail_quote">On Fri, Jul 4, 2008 at 2:53 PM, Henning Westerholt <<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">On Friday 04 July 2008, Noble Antony T wrote:<br>
> I have compiled the Openser with RLS module in my desktop, and it seems<br>
> installation went fine...<br>
><br>
> But when I try to start the openser, I am getting the following error.....<br>
> *<br>
> Jul 3 10:11:49 [10721] ERROR:core:table_version: invalid type (2) or nul<br>
> (0) version columns for xcap<br>
> Jul 3 10:11:49 [10721] DBG:core:db_free_rows: freeing 1 rows<br>
> Jul 3 10:11:49 [10721] DBG:core:db_free_rows: row[0]=0x815d530<br>
> Jul 3 10:11:49 [10721] DBG:core:db_free_rows: 0x815d530=pkg_free()<br>
> RES_ROWS Jul 3 10:11:49 [10721] ERROR:presence_xml:mod_init: Wrong version<br>
> v-1 for table <xcap>, need v3<br>
> Jul 3 10:11:49 [10721] ERROR:core:init_mod: failed to initialize module<br>
> presence_xml<br>
> Jul 3 10:11:49 [10721] ERROR:core:main: error while initializing modules<br>
> Jul 3 10:11:49 [10721] DBG:rls:destroy: start*<br>
><br>
> But my MySQL shows, the version of XCAP as<br>
><br>
> *mysql> select * from version where table_name="xcap" ;<br>
</div>> | xcap | 3 |<br>
<div class="Ih2E3d">><br>
> Though the version information is present for the xcap table, this error is<br>
> coming.<br>
<br>
</div>Hi Noble Antony,<br>
<br>
i've tried to reproduce your problem with the 1.3 branch of openser. On my<br>
system i don't observe the error you've described. It seems that there<br>
happens an error during the version table query (first log statement). Does<br>
this happens all the time? Have you tried to install the DB again?<br>
<br>
Cheers,<br>
<font color="#888888"><br>
Henning<br>
</font></blockquote></div><br><br>