[OpenSIPS-Users] RES: Error when initializing the OpenSIPS

[Bogdan-Andrei Iancu]

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 <alcindoschleder at gmail.com> 
Date:28/03/2014  22:02  (GMT+02:00) 
To: 'Bogdan-Andrei Iancu' <bogdan at opensips.org> 
Subject: RES: [OpenSIPS-Users] Error when initializing the OpenSIPS 

Hello,
 
Solved the problem adjusting fields order.
 
De: Bogdan-Andrei Iancu [mailto:bogdan at opensips.org] 
Enviada em: quinta-feira, 27 de março de 2014 05:48
Para: OpenSIPS users mailling list; alcindoschleder at gmail.com
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
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140331/7cd42bb5/attachment.htm>