<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span>Hi Bogdan,</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>appologies for my late reply. I got problem with accessing my email account from home. :(</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>Thanks for the
 help in spotting the mistake I did :'(. I'll fix the location table and see how it goes. :)</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span></span></div> <div class="qtdSeparateBR"><br><br></div><div style="display: block;" class="yahoo_quoted"> <div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> On Friday, 6 June 2014, 16:58, Bogdan-Andrei Iancu &lt;bogdan@opensips.org&gt; wrote:<br> </font> </div>  <br><br> <div class="y_msg_container"><div id="yiv6450150371"><div>
    <div class="yiv6450150371moz-cite-prefix"><tt>no, it is not related to that :) -
        see my previous email.<br clear="none">
        <br clear="none">
        Regards,<br clear="none">
      </tt>
      <pre class="yiv6450150371moz-signature">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-freetext" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
      On 06.06.2014 06:35, Pasan Meemaduma wrote:<br clear="none">
    </div>
    <div class="yiv6450150371yqt5758786393" id="yiv6450150371yqt79950"><blockquote type="cite">
      <div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
        <div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi Bogdan,</span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
          <span class="yiv6450150371" style=""></span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I just found that I have got the key
            constraint wrong. Will that be the issue ?</span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
          <span class="yiv6450150371" style=""></span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">| location | CREATE TABLE `location` (<br class="yiv6450150371" style="" clear="none">
            &nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `username` char(64) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `domain` char(64) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `contact` char(255) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `received` char(128) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `path` char(128) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `q` float(10,2) NOT NULL DEFAULT '1.00',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `cseq` int(11) NOT NULL DEFAULT '13',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `last_modified` datetime NOT NULL DEFAULT '1900-01-01
            00:00:01',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `flags` int(11) NOT NULL DEFAULT '0',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `cflags` int(11) NOT NULL DEFAULT '0',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `user_agent` char(255) NOT NULL DEFAULT '',<br class="yiv6450150371" style="" clear="none">
            &nbsp; `socket` char(64) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `methods` int(11) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `sip_instance` char(255) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; `attr` char(255) DEFAULT NULL,<br class="yiv6450150371" style="" clear="none">
            &nbsp; PRIMARY KEY (`id`),<br class="yiv6450150371" style="" clear="none">
            &nbsp; KEY `account_contact_idx` (`username`,`domain`,`contact`)<br class="yiv6450150371" style="" clear="none">
            ) ENGINE=MyISAM AUTO_INCREMENT=25375081 DEFAULT
            CHARSET=latin1 |<br class="yiv6450150371" style="" clear="none">
          </span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br clear="none">
          <span class="yiv6450150371" style=""></span></div>
        <div class="yiv6450150371" style="color:rgb(0, 0, 0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">account_contact_idx is missing callid
            column. Will this has any relation to crash ?<br class="yiv6450150371" style="" clear="none">
          </span></div>
        <div class="yiv6450150371qtdSeparateBR"><br clear="none">
          <br clear="none">
        </div>
        <div class="yiv6450150371yahoo_quoted" style="display:block;">
          <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
            <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
              <div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On Friday, 6 June 2014, 8:48,
                  Pasan Meemaduma <a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-rfc2396E" ymailto="mailto:pasandev@ymail.com" target="_blank" href="mailto:pasandev@ymail.com">&lt;pasandev@ymail.com&gt;</a> wrote:<br class="yiv6450150371" style="" clear="none">
                </font> </div>
              <br class="yiv6450150371" style="" clear="none">
              <br class="yiv6450150371" style="" clear="none">
              <div class="yiv6450150371" style="">
                <div class="yiv6450150371" id="yiv6450150371" style="">
                  <div class="yiv6450150371" style="">
                    <div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
                      <div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi
                          Bogdan,</span></div>
                      <div class="yiv6450150371" style="color:rgb(0, 0,                         0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                        <span class="yiv6450150371" style=""></span></div>
                      <div class="yiv6450150371" style="color:rgb(0, 0,                         0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">Thanks for the reply. I
                          created the table using normal schema it looks
                          fine to me. I was refering to the old url you
                          gave me. There in that table attr was missing
                          :)<br class="yiv6450150371" style="" clear="none">
                        </span></div>
                      <div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
                        this is the url missing attr in location table<br class="yiv6450150371" style="" clear="none">
                        <tt class="yiv6450150371" style=""><a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254">http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254</a>&nbsp;
                          <br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          below is my table schema,<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          mysql&gt; desc location;<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
                          | Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Null |
                          Key | Default&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Extra&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
                          | id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(10) unsigned | NO&nbsp;&nbsp; |
                          PRI | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | auto_increment |<br class="yiv6450150371" style="" clear="none">
                          | username&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(64)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp; |
                          MUL |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | domain&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(64)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | contact&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | received&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(128)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | path&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(128)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | expires&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | datetime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 2020-05-28 21:32:15 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | q&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | float(10,2)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 1.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | callid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | Default-Call-ID&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | cseq&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | last_modified | datetime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 1900-01-01 00:00:01 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | flags&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | cflags&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | user_agent&nbsp;&nbsp;&nbsp; | char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NO&nbsp;&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | socket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(64)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | methods&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | int(11)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | sip_instance&nbsp; | char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
                          | attr&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | char(255)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | YES&nbsp;
                          |&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br class="yiv6450150371" style="" clear="none">
+---------------+------------------+------+-----+---------------------+----------------+<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          attr holds NULL values for all entries.<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          do I have to run below in gdb after running bt
                          full right ?<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          this is what i got<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          (gdb) f 1<br class="yiv6450150371" style="" clear="none">
                          #1&nbsp; 0x00007f64823a60a2 in dbrow2info
                          (contact=0x7fffe0246180, vals=0x7f648287a260)
                          at udomain.c:306<br class="yiv6450150371" style="" clear="none">
                          306&nbsp;&nbsp;&nbsp; in udomain.c<br class="yiv6450150371" style="" clear="none">
                          (gdb) p (vals+6)-&gt;val.string_val<br class="yiv6450150371" style="" clear="none">
                          $2 = 0x0<br class="yiv6450150371" style="" clear="none">
                          (gdb) <br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                          -----------------without running bt full
                          ------------- just in case :)<br class="yiv6450150371" style="" clear="none">
                          (gdb) f 1<br class="yiv6450150371" style="" clear="none">
                          #1&nbsp; 0x00007f64823a60a2 in dbrow2info
                          (contact=0x7fffe0246180, vals=0x7f648287a260)
                          at udomain.c:306<br class="yiv6450150371" style="" clear="none">
                          306&nbsp;&nbsp;&nbsp; udomain.c: No such file or directory.<br class="yiv6450150371" style="" clear="none">
                          (gdb) p (vals+6)-&gt;val.string_val<br class="yiv6450150371" style="" clear="none">
                          $1 = 0x0<br class="yiv6450150371" style="" clear="none">
                          <br class="yiv6450150371" style="" clear="none">
                        </tt></div>
                      <div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
                        <br class="yiv6450150371" style="" clear="none">
                      </div>
                      <div class="yiv6450150371" id="yiv6450150371yqt85628" style="">
                        <div class="yiv6450150371" style="display:block;">
                          <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
                            <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
                              <div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On Thursday, 5 June 2014,
                                  17:07, Bogdan-Andrei Iancu
                                  <a rel="nofollow" shape="rect" class="yiv6450150371moz-txt-link-rfc2396E" ymailto="mailto:bogdan@opensips.org" target="_blank" href="mailto:bogdan@opensips.org">&lt;bogdan@opensips.org&gt;</a> wrote:<br class="yiv6450150371" style="" clear="none">
                                </font> </div>
                              <br class="yiv6450150371" style="" clear="none">
                              <br class="yiv6450150371" style="" clear="none">
                              <div class="yiv6450150371" style="">
                                <div class="yiv6450150371" id="yiv6450150371" style="">
                                  <div class="yiv6450150371" style="">
                                    <div class="yiv6450150371" style="">Thanks for
                                      the backtrace. In DB, what do you
                                      have for the "attr" value ? NULL
                                      or an empty string ?<br class="yiv6450150371" style="" clear="none">
                                      <br class="yiv6450150371" style="" clear="none">
                                      In gdb, could you do:<br class="yiv6450150371" style="" clear="none">
                                      &nbsp;&nbsp;&nbsp; f 1<br class="yiv6450150371" style="" clear="none">
                                      &nbsp;&nbsp;&nbsp; p (vals+6)-&gt;val.string_val<br class="yiv6450150371" style="" clear="none">
                                      <br class="yiv6450150371" style="" clear="none">
                                      Thanks,<br class="yiv6450150371" style="" clear="none">
                                      <pre class="yiv6450150371" style="">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
                                      On 05.06.2014 06:15, Pasan
                                      Meemaduma wrote:
                                      <div class="yiv6450150371" id="yiv6450150371yqtfd39564" style=""><br class="yiv6450150371" style="" clear="none">
                                      </div>
                                    </div>
                                    <div class="yiv6450150371" id="yiv6450150371yqtfd99965" style="">
                                      <blockquote class="yiv6450150371" style="" type="cite">
                                        <div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
                                          <div class="yiv6450150371" style=""><span class="yiv6450150371" style="">oops
                                              sorry I forgot
                                              opensips-dbg :) bt
                                              reattached.</span></div>
                                          <div class="yiv6450150371" style="color:rgb(0, 0,                                             0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                            <span class="yiv6450150371" style=""></span></div>
                                          <div class="yiv6450150371" style="color:rgb(0, 0,                                             0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I have change
                                              some sensitive values with
                                              'x' as below, hope it wont
                                              affect u r investigations</span></div>
                                          <div class="yiv6450150371" style="color:rgb(0, 0,                                             0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                            <span class="yiv6450150371" style=""></span></div>
                                          <div class="yiv6450150371" style="color:rgb(0, 0,                                             0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; contact =
                                              {s = 0xf91eab <a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx" target="_blank" href="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx">"sip:xxxxxxxxxx@xxx.xxx.xxx.xx"</a>,
                                              len = 29}<br class="yiv6450150371" style="" clear="none">
                                            </span></div>
                                          <div class="yiv6450150371" style=""><br class="yiv6450150371" style="" clear="none">
                                            <br class="yiv6450150371" style="" clear="none">
                                          </div>
                                          <div class="yiv6450150371" style="display:block;">
                                            <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:10pt;">
                                              <div class="yiv6450150371" style="font-family:times new roman, new york, times, serif;font-size:12pt;">
                                                <div class="yiv6450150371" dir="ltr" style=""> <font class="yiv6450150371" style="" face="Arial" size="2"> On
                                                    Thursday, 5 June
                                                    2014, 8:34, Pasan
                                                    Meemaduma <a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:pasandev@ymail.com" target="_blank" href="mailto:pasandev@ymail.com">&lt;pasandev@ymail.com&gt;</a>
                                                    wrote:<br class="yiv6450150371" style="" clear="none">
                                                  </font> </div>
                                                <br class="yiv6450150371" style="" clear="none">
                                                <br class="yiv6450150371" style="" clear="none">
                                                <div class="yiv6450150371" style="">
                                                  <div class="yiv6450150371" id="yiv6450150371" style="">
                                                    <div class="yiv6450150371" style="">
                                                      <div class="yiv6450150371" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
                                                        <div class="yiv6450150371" style=""><span class="yiv6450150371" style="">Hi
                                                          Bogdan,</span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I
                                                          double checked
                                                          the schema and
                                                          it is correct.
                                                          btw doc needs
                                                          fixing its
                                                          missing attr
                                                          column which
                                                          is needed by
                                                          1.10 for
                                                          location table
                                                          otherwise I'll
                                                          get below
                                                          error.</span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">Jun&nbsp;

                                                          5 12:57:26&nbsp;
                                                          x/usr/sbin/opensips[30176]:
                                                          CRITICAL:db_mysql:wrapper_single_mysql_real_query:

                                                          driver error
                                                          (1054):
                                                          Unknown column
                                                          'attr' in
                                                          'field list'<br class="yiv6450150371" style="" clear="none">
                                                          Jun&nbsp; 5
                                                          12:57:26 x
                                                          /usr/sbin/opensips[30177]:
                                                          DBG:core:db_do_init:
                                                          connection
                                                          0x7f4dc04c1c28
                                                          inserted in
                                                          pool as
                                                          0x7f4dc04c1d30<br class="yiv6450150371" style="" clear="none">
                                                          Jun&nbsp; 5
                                                          12:57:26 x
                                                          /usr/sbin/opensips[30176]:
                                                          ERROR:core:db_do_query:
                                                          error while
                                                          submitting
                                                          query -
                                                          [select
                                                          username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,attr

                                                          from location
                                                          ]<br class="yiv6450150371" style="" clear="none">
                                                          Jun&nbsp; 5
                                                          12:57:26
                                                          anacardium3backup
                                                          /usr/sbin/opensips[30176]:

                                                          ERROR:usrloc:preload_udomain:
                                                          db_query (1)
                                                          failed<br class="yiv6450150371" style="" clear="none">
                                                          <br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;">:)<br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><span class="yiv6450150371" style="">I got
                                                          the backtrace
                                                          as you
                                                          requested , It
                                                          doesn't seems
                                                          right to me.&nbsp;
                                                          does it make
                                                          any sense ? or
                                                          did I miss
                                                          something
                                                          getting it ?</span></div>
                                                        <div class="yiv6450150371" style="color:rgb(0,                                                           0,                                                           0);font-size:13.3333px;font-family:times new roman, new york, times, serif;background-color:transparent;font-style:normal;"><br class="yiv6450150371" style="" clear="none">
                                                          <span class="yiv6450150371" style=""></span></div>
                                                        <br class="yiv6450150371" style="" clear="none">
                                                      </div>
                                                    </div>
                                                  </div>
                                                  <br class="yiv6450150371" style="" clear="none">
                                                </div>
                                              </div>
                                            </div>
                                          </div>
                                        </div>
                                      </blockquote>
                                      <br class="yiv6450150371" style="" clear="none">
                                    </div>
                                  </div>
                                </div>
                                <br class="yiv6450150371" style="" clear="none">
                                <br class="yiv6450150371" style="" clear="none">
                              </div>
                            </div>
                          </div>
                        </div>
                      </div>
                    </div>
                  </div>
                </div>
                <br class="yiv6450150371" style="" clear="none">
                <div class="yiv6450150371" id="yiv6450150371yqt03407" style="">_______________________________________________<br class="yiv6450150371" style="" clear="none">
                  Users mailing list<br class="yiv6450150371" style="" clear="none">
                  <a rel="nofollow" shape="rect" class="yiv6450150371" style="" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br class="yiv6450150371" style="" clear="none">
                  <a rel="nofollow" shape="rect" class="yiv6450150371" style="" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br class="yiv6450150371" style="" clear="none">
                </div>
                <br class="yiv6450150371" style="" clear="none">
                <br class="yiv6450150371" style="" clear="none">
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote></div>
    <br clear="none">
  </div></div><br><br></div>  </div> </div>  </div> </div></body></html>