[Serusers] Re: 0.9.0 Invalid table version

[Jan Janak]

The database schema does not match SER version. You will need to
recreate the database using ser_mysql.sh script bundled with the ser
version you are using. I recommend to backup your data first.

   Jan.

On 07-03 17:10, Daniel Poulsen wrote:
> Hi;
> 
> I've noticed that if I disable contact storage mode ("usrloc",
> db_mode", 0), I can start SER just fine.  Does anybody have any
> thoughts on that?  This is a clean install of 0.9.0 with a config that
> worked just fine with 0.8.14.
> 
> Thanks again,
> Dan
> 
> 
> 
> On Fri, 4 Mar 2005 11:44:37 -0500, Daniel Poulsen <dpoulsen at gmail.com> wrote:
> > Hi,
> > 
> > I saw another serusers post on this, but didn't find an answer.  I
> > have a vanilla install of 0.9.0 on a freshly built debian box.  When I
> > run ser, I get:
> > 
> > Mar  4 11:34:52 sip-failover ser[5055]: Maxfwd module- initializing
> > Mar  4 11:34:52 sip-failover ser[5055]: register_udomain(): Invalid
> > table version (use ser_mysql.sh reinstall)
> > Mar  4 11:34:52 sip-failover ser[5055]: domain_fixup(): Error while
> > registering domain
> > Mar  4 11:34:52 sip-failover ser[5055]: ERROR: fix_expr : fix_actions error
> > 
> > If I run ser_mysql.sh reinstall, I get different errors:
> > 
> > Mar  4 11:36:42 sip-failover ser[5102]: table_version(): Invalid
> > number of rows received: 2, uri
> > Mar  4 11:36:42 sip-failover ser[5102]: ERROR: uri_db:mod_init():
> > Error while querying table version
> > Mar  4 11:36:42 sip-failover ser[5102]: init_mod(): Error while
> > initializing module uri_db
> > 
> > As the previous poster defailed, the "invalid number" error occurs
> > because the ser_mysql.sh script creates duplicate entries in the
> > version table.  The quesion is, what table version sill satisfy
> > 'register_udomain()'?
> > 
> > Currently, I have:
> > 
> > mysql> select * from version;
> > +-----------------------+---------------+
> > | table_name            | table_version |
> > +-----------------------+---------------+
> > | subscriber            |             5 |
> > | reserved              |             1 |
> > | phonebook             |             1 |
> > | pending               |             4 |
> > | missed_calls          |             2 |
> > | location              |             6 |
> > | grp                   |             2 |
> > | event                 |             1 |
> > | aliases               |             6 |
> > | active_sessions       |             1 |
> > | acc                   |             2 |
> > | config                |             1 |
> > | silo                  |             3 |
> > | realm                 |             1 |
> > | domain                |             1 |
> > | uri                   |             1 |
> > | server_monitoring     |             1 |
> > | server_monitoring_agg |             1 |
> > | trusted               |             1 |
> > | usr_preferences       |             1 |
> > | preferences_types     |             1 |
> > | admin_privileges      |             1 |
> > | calls_forwarding      |             1 |
> > | speed_dial            |             1 |
> > +-----------------------+---------------+
> > 24 rows in set (0.00 sec)
> > 
> > Thank you for your time,
> > 
> > Dan Poulsen
> >
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers