Hello, Your problem is in other place - for location module, the order of the column is not relevant - the queries are explicitly naming the columns.
Regards, Bogdan Sent from Samsung Mobile -------- Original message -------- From: Alcindo Schleder <[email protected]> Date:28/03/2014 22:02 (GMT+02:00) To: 'Bogdan-Andrei Iancu' <[email protected]> Subject: RES: [OpenSIPS-Users] Error when initializing the OpenSIPS Hello, Solved the problem adjusting fields order. De: Bogdan-Andrei Iancu [mailto:[email protected]] Enviada em: quinta-feira, 27 de março de 2014 05:48 Para: OpenSIPS users mailling list; [email protected] Assunto: Re: [OpenSIPS-Users] Error when initializing the OpenSIPS Hello, It seems you have some invalid or mismatching data in location table. Could you please post here the output of select * from location limit 1; (full output, with the name of the columns too). Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 24.03.2014 20:06, Alcindo Schleder wrote: Hi all. This error occurs when I start the Opensips 1.10.1 and there are recorded data in the table location: Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:db_str2int: Unexpected characters: [-03-24 14:20:57] Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_str2val: error while converting integer value from string Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_convert_row: failed to convert value Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_fetch_result: error while converting row #0 Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:usrloc:preload_udomain: fetching rows failed Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location' Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1 Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:main_loop: init_child failed for UDP listener Alcindo Schleder _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
