[OpenSIPS-Users] Opensips 2.3 db version error

[Răzvan Crainea]

Hello!

It definitely looks like you don't hve the right DB schema for the 
aliases table. It should have the same schema as the location table.

Best regards,

Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com

On 06/02/2017 12:36 PM, maatohewetbi wrote:
> I wanted to install Opensips 2.3, and everythings goes well, but after this
> process I can't start opensips and have those lines in log:
> 
> /Jun  2 11:17:06 OpenSips-Reseller /sbin/opensips[11692]:
> ERROR:core:db_check_table_version: invalid version 1009 for table aliases
> found, expected 1011
> Jun  2 11:17:06 OpenSips-Reseller /sbin/opensips[11692]:
> ERROR:usrloc:register_udomain: error during table version check./
> 
> I'm sure I used right version. After changing this version by hand, I still
> get other errors:
> 
> /Jun  2 11:34:51 OpenSips-Reseller /sbin/opensips[11980]:
> CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error (1054):
> Unknown column 'contact_id' in 'field list'
> Jun  2 11:34:51 OpenSips-Reseller /sbin/opensips[11980]:
> ERROR:core:db_do_query: error while submitting query - [select
> username,contact_id,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,attr
> from aliases ]/
> 
> It looks like DB creator is wrong, can anyone give an advise?
> 
> 
> 
> 
> --
> View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/Opensips-2-3-db-version-error-tp7607579.html
> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
> 
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>