<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body ><div>Hello,</div><div><br></div><div>Your problem is in other place - for location module, the order of the column is not relevant - the queries are explicitly naming the columns.</div><div><br></div><div>Regards,</div><div>Bogdan</div><div><br></div><div><br></div><div><div style="font-size:9px;color:#575757">Sent from Samsung Mobile</div></div><br><br>-------- Original message --------<br>From: Alcindo Schleder <alcindoschleder@gmail.com> <br>Date:28/03/2014 22:02 (GMT+02:00) <br>To: 'Bogdan-Andrei Iancu' <bogdan@opensips.org> <br>Subject: RES: [OpenSIPS-Users] Error when initializing the OpenSIPS <br><br><div class="WordSection1"><p class="MsoNormal"><span style="color:#1F497D">Hello,<o:p></o:p></span></p><p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p><p class="MsoNormal"><span style="color:#1F497D">Solved the problem adjusting fields order.<o:p></o:p></span></p><p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p><div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:PT-BR">De:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:PT-BR"> Bogdan-Andrei Iancu [mailto:bogdan@opensips.org] <br><b>Enviada em:</b> quinta-feira, 27 de março de 2014 05:48<br><b>Para:</b> OpenSIPS users mailling list; alcindoschleder@gmail.com<br><b>Assunto:</b> Re: [OpenSIPS-Users] Error when initializing the OpenSIPS<o:p></o:p></span></p></div></div><p class="MsoNormal"><o:p> </o:p></p><div><p class="MsoNormal"><tt><span style="font-size:10.0pt">Hello,</span></tt><span style="font-size:10.0pt;font-family:"Courier New""><br><br><tt>It seems you have some invalid or mismatching data in location table. Could you please post here the output of </tt><br><tt> select * from location limit 1;</tt><br><br><tt>(full output, with the name of the columns too).</tt><br><br><tt>Regards,</tt></span><br><br><o:p></o:p></p><pre>Bogdan-Andrei Iancu<o:p></o:p></pre><pre>OpenSIPS Founder and Developer<o:p></o:p></pre><pre><a href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a><o:p></o:p></pre><p class="MsoNormal">On 24.03.2014 20:06, Alcindo Schleder wrote:<o:p></o:p></p></div><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><p class="MsoNormal">Hi all.<o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p><p class="MsoNormal">This error occurs when I start the Opensips 1.10.1 and there are recorded data in the table location:<o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:db_str2int: Unexpected characters: [-03-24 14:20:57]<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_str2val: error while converting integer value from string<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_convert_row: failed to convert value<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:db_mysql:db_mysql_fetch_result: error while converting row #0<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:usrloc:preload_udomain: fetching rows failed<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:usrloc:child_init: child(1): failed to preload domain 'location'<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:init_mod_child: failed to initializing module usrloc, rank 1<o:p></o:p></p><p class="MsoNormal">Mar 24 15:06:08 xsip /usr/sbin/opensips[1632]: ERROR:core:main_loop: init_child failed for UDP listener<o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p><p class="MsoNormal"><span style="mso-fareast-language:PT-BR">Alcindo Schleder</span><o:p></o:p></p><p class="MsoNormal"> <o:p></o:p></p><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:PT-BR"><br><br><br><o:p></o:p></span></p><pre>_______________________________________________<o:p></o:p></pre><pre>Users mailing list<o:p></o:p></pre><pre><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><o:p></o:p></pre><pre><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><o:p></o:p></pre></blockquote><p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:PT-BR"><o:p> </o:p></span></p></div></body>