[OpenSIPS-Devel] invalid version 2 for table uri found, expected 7

[Andrew Pogrebennyk]

Andrew Pogrebennyk wrote:
> Hi,
> I have run into the problem with uri module in the opensips-1.5.3:
> 
> Oct 28 12:58:48 [29302] ERROR:core:db_check_table_version: invalid 
> version 2 for table uri found, expected 7
> Oct 28 12:58:48 [29302] ERROR:uri_db:mod_init: Invalid table version.
> 
> I used opensipsdbctl to migrate the 1.3 db, but as I see the 
> uri_db-create.sql contains INSERT INTO version ... values ('uri','2'), 
> in trunk also. But I can't find where expected version is hardcoded in 
> the uri module. Is it a known/fixed bug or I am missing something?

Got it. In 1.3.x there was a special subscriber_table option and 
use_uri_table worked as a switch between the two configured tables (uri 
and subscriber). When I upgraded to 1.5.3 I removed the obsolete 
parameters and ended up with db_table="uri" and use_uri_table=0 and that 
is when I got an error - due to:

checkver = db_check_table_version( &db_funcs, db_conn, &db_table,
                 use_uri_table?URI_TABLE_VERSION:SUBSCRIBER_TABLE_VERSION );

db_check_table_version() was called with wrong version. Just ignore this.

-- 
Sincerely,
Andrew Pogrebennyk