<!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 Sonntag, 24. Mai 2009, Raśl Alexis Betancor Santana wrote:<br>
> ERROR:core:db_check_table_version: invalid version 2 for table<br>
> carrierfailureroute found, expected 3 (check table structure and<br>
> table "version")<br>
><br>
> If I manualy set carrierfailureroute table version to 3 (UPDATE version SET<br>
> table_version = 3 where table_name = 'carrierfailureroute';) I get the<br>
> opposite error:<br>
><br>
> ERROR:core:db_check_table_version: invalid version 3 for table<br>
> carrierfailureroute found, expected 2 (check table structure and<br>
> table "version")<br>
><br>
> It have no sense ... any clue what's happening ?<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>this is indeed really strange. This are the values in the code:<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>/* table version */<br>
const unsigned int carrierroute_version = 3;<br>
/* table version */<br>
const unsigned int carrierfailureroute_version = 2;<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>and the corresponding entries in the version table.<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>+---------------+---------------------+ <br>
| table_version | table_name | <br>
+---------------+---------------------+ <br>
| 3 | carrierroute | <br>
| 2 | carrierfailureroute | <br>
+---------------+---------------------+ <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 just tested it (1.5.x) again, loads without any problems.<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>May 25 10:19:35 ca ../kamailio[13376]: INFO:carrierroute:mod_init: use database as configuration source<br>
May 25 10:19:35 ca ../kamailio[13376]: INFO:carrierroute:load_route_data_db: carrier 'carrier1' (id 1) has 3 domains<br>
[..]<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>Perhaps you've done some changes to the cr module? Just guessing what could be the reason for this problem..<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>