<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Lucida Console'; font-size:9pt; font-weight:400; font-style:normal;">On Montag, 25. Mai 2009, Raśl Alexis Betancor Santana wrote:<br>
> [..]<br>
> > > [uri_db_mod.c]<br>
> > ><br>
> > > and SUBSCRIBER_TABLE_VERSION has value 6<br>
> > ><br>
> > > is there something I'm doing wrong?, last time I compile myself this I<br>
> > > was forced to comment that block of code on the uri_db sources.<br>
> ><br>
> > paste the output of "select * from version" here and if you can get it<br>
> > in postgres, the equivalent in mysql of "describe version".<br>
><br>
> Hi Daniel, the "real problem" is this line ..<br>
><br>
> [...]<br>
> ver = uridb_db_ver(&db_url, &db_table);<br>
> [...]<br>
><br>
> Because with it you allways get the version of uri table, but then on the<br>
> if block you check it against URI_TABLE_VERSION or<br>
> SUBSCRIBER_TABLE_VERSION. The solution was "UPDATE version SET<br>
> table_version=6 WHERE table_name ='uri';" so it get's the correct version<br>
> of SUBSCRIBER_TABLE_VERSION<br>
><br>
> The check code should be fixed to get the table version of the table you<br>
> are using (uri or subscriber) and not allways get the version of uri.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hi Raśl,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>i think the real problem is in your configuration:<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>modparam("uri_db", "db_table", "uri")<br>
modparam("uri_db", "use_uri_table", 0)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>You specify "uri" as table for the module to use, but then you say it should not use the uri table for checks. This should be the reason that it report the version error in startup. If you set the latter parameter to 1, it will check against the subscriber table as usual.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Cheers,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Henning</p></body></html>