[Users] Fwd:Invalid table version

[buxalex at libero.it]

Hello Bogdan,

as usual you are right!  :o)
I tried to use the table subscriber as follow:

  if (method=="INVITE") {
       setflag(2);
       record_route();
       if (!lookup("subscriber")) {
            sl_send_reply("401", "Dialled Number not Authorizied");
       exit;
       if (!lookup("location")) {
           sl_send_reply("404", "Dialled number off line !");
       exit;
       };
       };

Of course commenting the part related to subscriber table it works fine.
My idea was to check whether the dialled number is only off line or it is not existent; this because I would like to have the choice to send a registered vocal message (or for mow an email) to dialled numbers.

I tried to put 1003 in table domain and subscriber, but now I get this error:

 ACC - initializing
 AVPops - initializing
 submit_query: Unknown column 'contact' in 'field list'
 db_query: Error while submitting query
 preload_udomain(): Error while doing db_query
 register_udomain(): Error while preloading domain 'subscriber'
 domain_fixup(): Error while registering domain
 fix_actions: fixing failed (code=-1) at cfg line 211
 ERROR: fix_expr : fix_actions error


Can I fix this problem with configuration, or should I modify the logic to access the db (I mean I shouldn't use the subscriber table)?

Thanks a lot
Alessandro









---------- Initial Header -----------

>From      : "Bogdan-Andrei Iancu" bogdan at voice-system.ro
To          : "buxalex at libero.it" buxalex at libero.it
Cc          : "users" users at openser.org
Date      : Tue, 11 Apr 2006 20:34:58 +0300
Subject : Re: [Users] Fwd:Invalid table version







> Hi,
> 
> the error is generated by the usrloc module - the used tables must have 
> version 1003; are you using a different tablet then "location" or 
> "aliases"? if not, check in version table their records.
> 
> regards,
> bogdan
> 
> buxalex at libero.it wrote:
> 
> >Hello,
> >I tried also to drop and the to install the db, but still I get the same error....
> >
> >Please anybody can help me?
> >
> >I am using openser version 1.1.0 dev17 tls
> >
> >thanks in advance
> >Alessandro
> >----------------------------------------------------------------
> >Hello,
> >
> >running openser with mysql db (through monitor), I retrieve:
> >
> >ACC - initializing
> >Apr 11 18:58:32 dhc27-53-93pc /usr/local/sbin/openser[7806]: register_udomain(): Invalid table version (use openser_mysql.sh reinstall)
> >
> >If I comment the module ACC loading I get the same error for the other modules.
> >I reinstalled, as suggested from the log the db, but still I get the error.
> >
> >in table version I can see that the domain table has version 1
> >
> >Any idea? This is a test db, do you suggest to erase it and to install it again?
> >
> >thanks a lot
> >Alessandro
> >
> >
> >
> >_______________________________________________
> >Users mailing list
> >Users at openser.org
> >http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >  
> >
> 
>