<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">Hi,<br>
      <br>
      the procedure is correct. In this specific case it would also be
      sufficient to update just the package ngcp-panel. (apt-get install
      ngcp-panel). If the issue is non-critical for you, you can also
      wait for the maintenance window.<br>
      <br>
      - Gerhard<br>
      <br>
      On 08/06/2015 07:01 PM, Abel Alejandro wrote:<br>
    </div>
    <blockquote
cite="mid:CAKiNg20mkuHPSDDE5rZt=37D9EXiMUD15fP900euQZaY6+zsfQ@mail.gmail.com"
      type="cite">
      <div dir="ltr">Hello,
        <div><br>
        </div>
        <div>The procedure would be:</div>
        <div><br>
        </div>
        apt-get update && apt-get upgrade && \
        ngcp-update-db-schema && ngcp-update-cfg-schema
        && \ ngcpcfg apply
        <div><br>
        </div>
        <div>Do you think I can apply without dropping calls or better
          wait for maint window?</div>
        <div><br>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Thu, Aug 6, 2015 at 12:52 PM,
          Gerhard Jungwirth <span dir="ltr"><<a
              moz-do-not-send="true"
              href="mailto:gjungwirth@sipwise.com" target="_blank">gjungwirth@sipwise.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
            <br>
            thanks for the bugreport. This issue has now been fixed with
            the latest release of ngcp-panel (mr3.8.2.12). Please update
            and tell us if that solves your issue.<br>
            <br>
            Gerhard
            <div>
              <div class="h5"><br>
                <br>
                On 08/04/2015 04:40 PM, Andrew Pogrebennyk wrote:<br>
              </div>
            </div>
            <blockquote class="gmail_quote" style="margin:0 0 0
              .8ex;border-left:1px #ccc solid;padding-left:1ex">
              <div>
                <div class="h5">
                  Ok, thanks for dump.. I will check with our web dev.
                  This may take a<br>
                  couple of days before I get back to you, though.<br>
                  <br>
                  Andrew<br>
                  <br>
                  On 08/04/2015 04:38 PM, Abel Alejandro wrote:<br>
                  <blockquote class="gmail_quote" style="margin:0 0 0
                    .8ex;border-left:1px #ccc solid;padding-left:1ex">
                    The count looks the same but the ORDER of the DID
                    that do not appear on<br>
                    the Edit form is different. The BAD did are <a
                      moz-do-not-send="true" href="tel:17877487645"
                      value="+17877487645" target="_blank">17877487645</a>
                    and <a moz-do-not-send="true"
                      href="tel:17879057355" value="+17879057355"
                      target="_blank">17879057355</a><br>
                    <br>
                    <br>
                    mysql> select count(*) from
                    provisioning.voip_dbaliases where<br>
                    subscriber_id=47;<br>
                    +----------+<br>
                    | count(*) |<br>
                    +----------+<br>
                    |       85 |<br>
                    +----------+<br>
                    1 row in set (0.00 sec)<br>
                    <br>
                    mysql> select count(*) from billing.voip_numbers
                    where subscriber_id=43;<br>
                    +----------+<br>
                    | count(*) |<br>
                    +----------+<br>
                    |       85 |<br>
                    +----------+<br>
                    1 row in set (0.00 sec)<br>
                    <br>
                    mysql> select * from billing.voip_numbers where
                    subscriber_id=43;<br>
+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+<br>
                    | id    | cc | ac  | sn      | reseller_id |
                    subscriber_id | status |<br>
                    ported | list_timestamp      |<br>
+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+<br>
                    |   911 |  1 | 787 | 7052432 |          10 |       
                        43 | active |<br>
                        0 | 2014-06-17 13:11:32 |<br>
                    |  8972 |  1 | 787 | 2687353 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8973 |  1 | 787 | 6524000 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8974 |  1 | 787 | 6524001 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8975 |  1 | 787 | 6524002 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8976 |  1 | 787 | 6524003 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8977 |  1 | 787 | 6524004 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8978 |  1 | 787 | 8054100 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8979 |  1 | 787 | 8346242 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8980 |  1 | 787 | 9354000 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8981 |  1 | 787 | 9354001 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:44 |<br>
                    |  8982 |  1 | 787 | 9354002 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8983 |  1 | 787 | 9354004 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8984 |  1 | 787 | 9350102 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8985 |  1 | 787 | 8492888 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8986 |  1 | 787 | 6525000 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8987 |  1 | 787 | 6525001 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8988 |  1 | 787 | 6525002 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8989 |  1 | 787 | 6525003 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8990 |  1 | 787 | 6524005 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8991 |  1 | 787 | 6524006 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8992 |  1 | 787 | 6524007 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8993 |  1 | 787 | 6524008 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8994 |  1 | 787 | 6524009 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8995 |  1 | 787 | 6525004 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8996 |  1 | 787 | 2968286 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  8997 |  1 | 787 | 2968284 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9004 |  1 | 787 | 9576222 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9006 |  1 | 787 | 9667163 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9007 |  1 | 787 | 9667586 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9008 |  1 | 787 | 9667589 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9009 |  1 | 787 | 9667592 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9011 |  1 | 787 | 9619786 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9012 |  1 | 787 | 9619787 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9013 |  1 | 787 | 9619788 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9014 |  1 | 787 | 9619789 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9015 |  1 | 787 | 7109657 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9016 |  1 | 787 | 6657891 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9017 |  1 | 787 | 6657892 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9018 |  1 | 787 | 7050939 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9019 |  1 | 787 | 7050940 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9020 |  1 | 787 | 7050948 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9021 |  1 | 787 | 7086472 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9022 |  1 | 787 | 7086473 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9023 |  1 | 787 | 9455094 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9024 |  1 | 787 | 9455096 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9025 |  1 | 787 | 9455097 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9026 |  1 | 787 | 9455098 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9028 |  1 | 787 | 7052433 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9030 |  1 | 787 | 7052436 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9031 |  1 | 787 | 7052437 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9032 |  1 | 787 | 7109659 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9033 |  1 | 787 | 7109661 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9034 |  1 | 787 | 7107631 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9035 |  1 | 787 | 7107632 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9036 |  1 | 787 | 9667014 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9037 |  1 | 787 | 9667019 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9038 |  1 | 787 | 9667017 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9039 |  1 | 787 | 9667029 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9040 |  1 | 787 | 3957441 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9041 |  1 | 787 | 9619794 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9042 |  1 | 787 | 9619793 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9043 |  1 | 787 | 7057382 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9044 |  1 | 787 | 7057383 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9045 |  1 | 787 | 2667259 |          10 |       
                        43 | active |<br>
                        0 | 2014-09-23 10:02:45 |<br>
                    |  9514 |  1 | 787 | 9619790 |          10 |       
                        43 | active |<br>
                        0 | 2014-11-14 14:38:30 |<br>
                    |  9610 |  1 | 787 | 7650130 |          10 |       
                        43 | active |<br>
                        0 | 2015-01-07 11:17:19 |<br>
                    |  9611 |  1 | 787 | 7657386 |          10 |       
                        43 | active |<br>
                        0 | 2015-01-07 11:17:19 |<br>
                    |  9612 |  1 | 787 | 7729149 |          10 |       
                        43 | active |<br>
                        0 | 2015-01-07 11:17:19 |<br>
                    |  9755 |  1 | 787 | 7845000 |          10 |       
                        43 | active |<br>
                        0 | 2015-03-26 10:45:52 |<br>
                    |  9758 |  1 | 787 | 7845051 |          10 |       
                        43 | active |<br>
                        0 | 2015-03-26 16:01:08 |<br>
                    |  9780 |  1 | 787 | 7265929 |          10 |       
                        43 | active |<br>
                        0 | 2015-04-09 13:26:54 |<br>
                    |  9781 |  1 | 787 | 7286969 |          10 |       
                        43 | active |<br>
                        0 | 2015-04-09 13:26:54 |<br>
                    |  9843 |  1 | 787 | 7551210 |          10 |       
                        43 | active |<br>
                        0 | 2015-06-11 11:14:59 |<br>
                    |  9844 |  1 | 787 | 7487645 |          10 |       
                        43 | active |<br>
                        0 | 2015-08-02 10:41:06 |<br>
                    |  9845 |  1 | 787 | 7551235 |          10 |       
                        43 | active |<br>
                        0 | 2015-06-11 11:14:59 |<br>
                    |  9846 |  1 | 787 | 7551260 |          10 |       
                        43 | active |<br>
                        0 | 2015-06-11 11:14:59 |<br>
                    |  9847 |  1 | 787 | 7551300 |          10 |       
                        43 | active |<br>
                        0 | 2015-06-11 11:14:59 |<br>
                    |  9850 |  1 | 787 | 9057355 |          10 |       
                        43 | active |<br>
                        0 | 2015-08-02 10:41:06 |<br>
                    | 10096 |  1 | 787 | 4740636 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 13:42:56 |<br>
                    | 10097 |  1 | 787 | 4740637 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 15:38:45 |<br>
                    | 10098 |  1 | 787 | 4740638 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 15:38:45 |<br>
                    | 10099 |  1 | 787 | 4740639 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 15:38:45 |<br>
                    | 10100 |  1 | 787 | 4740640 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 15:38:45 |<br>
                    | 10101 |  1 | 787 | 4740641 |          10 |       
                        43 | active |<br>
                        0 | 2015-07-30 15:38:45 |<br>
+-------+----+-----+---------+-------------+---------------+--------+--------+---------------------+<br>
                    <br>
                    mysql> select * from provisioning.voip_dbaliases
                    where subscriber_id=47;<br>
+-------+-------------+-----------+---------------+------------+<br>
                    | id    | username    | domain_id | subscriber_id |
                    is_primary |<br>
+-------+-------------+-----------+---------------+------------+<br>
                    |  9221 | <a moz-do-not-send="true"
                      href="tel:17877052432" value="+17877052432"
                      target="_blank">17877052432</a> |         3 |     
                          47 |          1 |<br>
                    |  9222 | <a moz-do-not-send="true"
                      href="tel:17872687353" value="+17872687353"
                      target="_blank">17872687353</a> |         3 |     
                          47 |          0 |<br>
                    |  9223 | <a moz-do-not-send="true"
                      href="tel:17876524000" value="+17876524000"
                      target="_blank">17876524000</a> |         3 |     
                          47 |          0 |<br>
                    |  9224 | <a moz-do-not-send="true"
                      href="tel:17876524001" value="+17876524001"
                      target="_blank">17876524001</a> |         3 |     
                          47 |          0 |<br>
                    |  9225 | <a moz-do-not-send="true"
                      href="tel:17876524002" value="+17876524002"
                      target="_blank">17876524002</a> |         3 |     
                          47 |          0 |<br>
                    |  9226 | <a moz-do-not-send="true"
                      href="tel:17876524003" value="+17876524003"
                      target="_blank">17876524003</a> |         3 |     
                          47 |          0 |<br>
                    |  9227 | <a moz-do-not-send="true"
                      href="tel:17876524004" value="+17876524004"
                      target="_blank">17876524004</a> |         3 |     
                          47 |          0 |<br>
                    |  9228 | <a moz-do-not-send="true"
                      href="tel:17878054100" value="+17878054100"
                      target="_blank">17878054100</a> |         3 |     
                          47 |          0 |<br>
                    |  9229 | <a moz-do-not-send="true"
                      href="tel:17878346242" value="+17878346242"
                      target="_blank">17878346242</a> |         3 |     
                          47 |          0 |<br>
                    |  9230 | <a moz-do-not-send="true"
                      href="tel:17879354000" value="+17879354000"
                      target="_blank">17879354000</a> |         3 |     
                          47 |          0 |<br>
                    |  9231 | <a moz-do-not-send="true"
                      href="tel:17879354001" value="+17879354001"
                      target="_blank">17879354001</a> |         3 |     
                          47 |          0 |<br>
                    |  9232 | <a moz-do-not-send="true"
                      href="tel:17879354002" value="+17879354002"
                      target="_blank">17879354002</a> |         3 |     
                          47 |          0 |<br>
                    |  9233 | <a moz-do-not-send="true"
                      href="tel:17879354004" value="+17879354004"
                      target="_blank">17879354004</a> |         3 |     
                          47 |          0 |<br>
                    |  9234 | <a moz-do-not-send="true"
                      href="tel:17879350102" value="+17879350102"
                      target="_blank">17879350102</a> |         3 |     
                          47 |          0 |<br>
                    |  9235 | <a moz-do-not-send="true"
                      href="tel:17878492888" value="+17878492888"
                      target="_blank">17878492888</a> |         3 |     
                          47 |          0 |<br>
                    |  9236 | <a moz-do-not-send="true"
                      href="tel:17876525000" value="+17876525000"
                      target="_blank">17876525000</a> |         3 |     
                          47 |          0 |<br>
                    |  9237 | <a moz-do-not-send="true"
                      href="tel:17876525001" value="+17876525001"
                      target="_blank">17876525001</a> |         3 |     
                          47 |          0 |<br>
                    |  9238 | <a moz-do-not-send="true"
                      href="tel:17876525002" value="+17876525002"
                      target="_blank">17876525002</a> |         3 |     
                          47 |          0 |<br>
                    |  9239 | <a moz-do-not-send="true"
                      href="tel:17876525003" value="+17876525003"
                      target="_blank">17876525003</a> |         3 |     
                          47 |          0 |<br>
                    |  9240 | <a moz-do-not-send="true"
                      href="tel:17876524005" value="+17876524005"
                      target="_blank">17876524005</a> |         3 |     
                          47 |          0 |<br>
                    |  9241 | <a moz-do-not-send="true"
                      href="tel:17876524006" value="+17876524006"
                      target="_blank">17876524006</a> |         3 |     
                          47 |          0 |<br>
                    |  9242 | <a moz-do-not-send="true"
                      href="tel:17876524007" value="+17876524007"
                      target="_blank">17876524007</a> |         3 |     
                          47 |          0 |<br>
                    |  9243 | <a moz-do-not-send="true"
                      href="tel:17876524008" value="+17876524008"
                      target="_blank">17876524008</a> |         3 |     
                          47 |          0 |<br>
                    |  9244 | <a moz-do-not-send="true"
                      href="tel:17876524009" value="+17876524009"
                      target="_blank">17876524009</a> |         3 |     
                          47 |          0 |<br>
                    |  9245 | <a moz-do-not-send="true"
                      href="tel:17876525004" value="+17876525004"
                      target="_blank">17876525004</a> |         3 |     
                          47 |          0 |<br>
                    |  9246 | <a moz-do-not-send="true"
                      href="tel:17872968286" value="+17872968286"
                      target="_blank">17872968286</a> |         3 |     
                          47 |          0 |<br>
                    |  9247 | <a moz-do-not-send="true"
                      href="tel:17872968284" value="+17872968284"
                      target="_blank">17872968284</a> |         3 |     
                          47 |          0 |<br>
                    |  9254 | <a moz-do-not-send="true"
                      href="tel:17879576222" value="+17879576222"
                      target="_blank">17879576222</a> |         3 |     
                          47 |          0 |<br>
                    |  9256 | <a moz-do-not-send="true"
                      href="tel:17879667163" value="+17879667163"
                      target="_blank">17879667163</a> |         3 |     
                          47 |          0 |<br>
                    |  9257 | <a moz-do-not-send="true"
                      href="tel:17879667586" value="+17879667586"
                      target="_blank">17879667586</a> |         3 |     
                          47 |          0 |<br>
                    |  9258 | <a moz-do-not-send="true"
                      href="tel:17879667589" value="+17879667589"
                      target="_blank">17879667589</a> |         3 |     
                          47 |          0 |<br>
                    |  9259 | <a moz-do-not-send="true"
                      href="tel:17879667592" value="+17879667592"
                      target="_blank">17879667592</a> |         3 |     
                          47 |          0 |<br>
                    |  9261 | <a moz-do-not-send="true"
                      href="tel:17879619786" value="+17879619786"
                      target="_blank">17879619786</a> |         3 |     
                          47 |          0 |<br>
                    |  9262 | <a moz-do-not-send="true"
                      href="tel:17879619787" value="+17879619787"
                      target="_blank">17879619787</a> |         3 |     
                          47 |          0 |<br>
                    |  9263 | <a moz-do-not-send="true"
                      href="tel:17879619788" value="+17879619788"
                      target="_blank">17879619788</a> |         3 |     
                          47 |          0 |<br>
                    |  9264 | <a moz-do-not-send="true"
                      href="tel:17879619789" value="+17879619789"
                      target="_blank">17879619789</a> |         3 |     
                          47 |          0 |<br>
                    |  9265 | <a moz-do-not-send="true"
                      href="tel:17877109657" value="+17877109657"
                      target="_blank">17877109657</a> |         3 |     
                          47 |          0 |<br>
                    |  9266 | <a moz-do-not-send="true"
                      href="tel:17876657891" value="+17876657891"
                      target="_blank">17876657891</a> |         3 |     
                          47 |          0 |<br>
                    |  9267 | <a moz-do-not-send="true"
                      href="tel:17876657892" value="+17876657892"
                      target="_blank">17876657892</a> |         3 |     
                          47 |          0 |<br>
                    |  9268 | <a moz-do-not-send="true"
                      href="tel:17877050939" value="+17877050939"
                      target="_blank">17877050939</a> |         3 |     
                          47 |          0 |<br>
                    |  9269 | <a moz-do-not-send="true"
                      href="tel:17877050940" value="+17877050940"
                      target="_blank">17877050940</a> |         3 |     
                          47 |          0 |<br>
                    |  9270 | <a moz-do-not-send="true"
                      href="tel:17877050948" value="+17877050948"
                      target="_blank">17877050948</a> |         3 |     
                          47 |          0 |<br>
                    |  9271 | <a moz-do-not-send="true"
                      href="tel:17877086472" value="+17877086472"
                      target="_blank">17877086472</a> |         3 |     
                          47 |          0 |<br>
                    |  9272 | <a moz-do-not-send="true"
                      href="tel:17877086473" value="+17877086473"
                      target="_blank">17877086473</a> |         3 |     
                          47 |          0 |<br>
                    |  9273 | <a moz-do-not-send="true"
                      href="tel:17879455094" value="+17879455094"
                      target="_blank">17879455094</a> |         3 |     
                          47 |          0 |<br>
                    |  9274 | <a moz-do-not-send="true"
                      href="tel:17879455096" value="+17879455096"
                      target="_blank">17879455096</a> |         3 |     
                          47 |          0 |<br>
                    |  9275 | <a moz-do-not-send="true"
                      href="tel:17879455097" value="+17879455097"
                      target="_blank">17879455097</a> |         3 |     
                          47 |          0 |<br>
                    |  9276 | <a moz-do-not-send="true"
                      href="tel:17879455098" value="+17879455098"
                      target="_blank">17879455098</a> |         3 |     
                          47 |          0 |<br>
                    |  9278 | <a moz-do-not-send="true"
                      href="tel:17877052433" value="+17877052433"
                      target="_blank">17877052433</a> |         3 |     
                          47 |          0 |<br>
                    |  9280 | <a moz-do-not-send="true"
                      href="tel:17877052436" value="+17877052436"
                      target="_blank">17877052436</a> |         3 |     
                          47 |          0 |<br>
                    |  9281 | <a moz-do-not-send="true"
                      href="tel:17877052437" value="+17877052437"
                      target="_blank">17877052437</a> |         3 |     
                          47 |          0 |<br>
                    |  9282 | <a moz-do-not-send="true"
                      href="tel:17877109659" value="+17877109659"
                      target="_blank">17877109659</a> |         3 |     
                          47 |          0 |<br>
                    |  9283 | <a moz-do-not-send="true"
                      href="tel:17877109661" value="+17877109661"
                      target="_blank">17877109661</a> |         3 |     
                          47 |          0 |<br>
                    |  9284 | <a moz-do-not-send="true"
                      href="tel:17877107631" value="+17877107631"
                      target="_blank">17877107631</a> |         3 |     
                          47 |          0 |<br>
                    |  9285 | <a moz-do-not-send="true"
                      href="tel:17877107632" value="+17877107632"
                      target="_blank">17877107632</a> |         3 |     
                          47 |          0 |<br>
                    |  9286 | <a moz-do-not-send="true"
                      href="tel:17879667014" value="+17879667014"
                      target="_blank">17879667014</a> |         3 |     
                          47 |          0 |<br>
                    |  9287 | <a moz-do-not-send="true"
                      href="tel:17879667019" value="+17879667019"
                      target="_blank">17879667019</a> |         3 |     
                          47 |          0 |<br>
                    |  9288 | <a moz-do-not-send="true"
                      href="tel:17879667017" value="+17879667017"
                      target="_blank">17879667017</a> |         3 |     
                          47 |          0 |<br>
                    |  9289 | <a moz-do-not-send="true"
                      href="tel:17879667029" value="+17879667029"
                      target="_blank">17879667029</a> |         3 |     
                          47 |          0 |<br>
                    |  9290 | <a moz-do-not-send="true"
                      href="tel:17873957441" value="+17873957441"
                      target="_blank">17873957441</a> |         3 |     
                          47 |          0 |<br>
                    |  9291 | <a moz-do-not-send="true"
                      href="tel:17879619794" value="+17879619794"
                      target="_blank">17879619794</a> |         3 |     
                          47 |          0 |<br>
                    |  9292 | <a moz-do-not-send="true"
                      href="tel:17879619793" value="+17879619793"
                      target="_blank">17879619793</a> |         3 |     
                          47 |          0 |<br>
                    |  9293 | <a moz-do-not-send="true"
                      href="tel:17877057382" value="+17877057382"
                      target="_blank">17877057382</a> |         3 |     
                          47 |          0 |<br>
                    |  9294 | <a moz-do-not-send="true"
                      href="tel:17877057383" value="+17877057383"
                      target="_blank">17877057383</a> |         3 |     
                          47 |          0 |<br>
                    |  9295 | <a moz-do-not-send="true"
                      href="tel:17872667259" value="+17872667259"
                      target="_blank">17872667259</a> |         3 |     
                          47 |          0 |<br>
                    |  9785 | <a moz-do-not-send="true"
                      href="tel:17879619790" value="+17879619790"
                      target="_blank">17879619790</a> |         3 |     
                          47 |          0 |<br>
                    |  9916 | <a moz-do-not-send="true"
                      href="tel:17877650130" value="+17877650130"
                      target="_blank">17877650130</a> |         3 |     
                          47 |          0 |<br>
                    |  9917 | <a moz-do-not-send="true"
                      href="tel:17877657386" value="+17877657386"
                      target="_blank">17877657386</a> |         3 |     
                          47 |          0 |<br>
                    |  9918 | <a moz-do-not-send="true"
                      href="tel:17877729149" value="+17877729149"
                      target="_blank">17877729149</a> |         3 |     
                          47 |          0 |<br>
                    | 10116 | <a moz-do-not-send="true"
                      href="tel:17877845000" value="+17877845000"
                      target="_blank">17877845000</a> |         3 |     
                          47 |          0 |<br>
                    | 10122 | <a moz-do-not-send="true"
                      href="tel:17877845051" value="+17877845051"
                      target="_blank">17877845051</a> |         3 |     
                          47 |          0 |<br>
                    | 10147 | <a moz-do-not-send="true"
                      href="tel:17877265929" value="+17877265929"
                      target="_blank">17877265929</a> |         3 |     
                          47 |          0 |<br>
                    | 10148 | <a moz-do-not-send="true"
                      href="tel:17877286969" value="+17877286969"
                      target="_blank">17877286969</a> |         3 |     
                          47 |          0 |<br>
                    | 10227 | <a moz-do-not-send="true"
                      href="tel:17877551210" value="+17877551210"
                      target="_blank">17877551210</a> |         3 |     
                          47 |          0 |<br>
                    | 10229 | <a moz-do-not-send="true"
                      href="tel:17877551235" value="+17877551235"
                      target="_blank">17877551235</a> |         3 |     
                          47 |          0 |<br>
                    | 10230 | <a moz-do-not-send="true"
                      href="tel:17877551260" value="+17877551260"
                      target="_blank">17877551260</a> |         3 |     
                          47 |          0 |<br>
                    | 10231 | <a moz-do-not-send="true"
                      href="tel:17877551300" value="+17877551300"
                      target="_blank">17877551300</a> |         3 |     
                          47 |          0 |<br>
                    | 10505 | <a moz-do-not-send="true"
                      href="tel:17874740636" value="+17874740636"
                      target="_blank">17874740636</a> |         3 |     
                          47 |          0 |<br>
                    | 10506 | <a moz-do-not-send="true"
                      href="tel:17874740637" value="+17874740637"
                      target="_blank">17874740637</a> |         3 |     
                          47 |          0 |<br>
                    | 10507 | <a moz-do-not-send="true"
                      href="tel:17874740638" value="+17874740638"
                      target="_blank">17874740638</a> |         3 |     
                          47 |          0 |<br>
                    | 10508 | <a moz-do-not-send="true"
                      href="tel:17874740639" value="+17874740639"
                      target="_blank">17874740639</a> |         3 |     
                          47 |          0 |<br>
                    | 10509 | <a moz-do-not-send="true"
                      href="tel:17874740640" value="+17874740640"
                      target="_blank">17874740640</a> |         3 |     
                          47 |          0 |<br>
                    | 10510 | <a moz-do-not-send="true"
                      href="tel:17874740641" value="+17874740641"
                      target="_blank">17874740641</a> |         3 |     
                          47 |          0 |<br>
                    | 10524 | <a moz-do-not-send="true"
                      href="tel:17879057355" value="+17879057355"
                      target="_blank">17879057355</a> |         3 |     
                          47 |          0 |<br>
                    | 10525 | <a moz-do-not-send="true"
                      href="tel:17877487645" value="+17877487645"
                      target="_blank">17877487645</a> |         3 |     
                          47 |          0 |<br>
+-------+-------------+-----------+---------------+------------+<br>
                    85 rows in set (0.02 sec)<br>
                    <br>
                    mysql><br>
                    <br>
                    On Tue, Aug 4, 2015 at 10:05 AM, Andrew Pogrebennyk<br>
                    <<a moz-do-not-send="true"
                      href="mailto:apogrebennyk@sipwise.com"
                      target="_blank">apogrebennyk@sipwise.com</a>
                    <mailto:<a moz-do-not-send="true"
                      href="mailto:apogrebennyk@sipwise.com"
                      target="_blank">apogrebennyk@sipwise.com</a>>>
                    wrote:<br>
                    <br>
                         Hi,<br>
                         I've encountered this issue once but was unable
                    to find out what is<br>
                         causing it. Please provide the dump of all
                    numbers from the billing and<br>
                         provisioning DBs:<br>
                    <br>
                         select * from provisioning.voip_dbaliases where
                    subscriber_id=73;<br>
                         select * from billing.voip_numbers where
                    subscriber_id=69;<br>
                    <br>
                         The id of subscriber in billing.voip_numbers
                    table is the one you see in<br>
                         your browser's address bar when you go to
                    subscriber details. The id in<br>
                         provisioning database you can figure out by
                    alias.<br>
                    <br>
                         Please check if the two tables look in sync to
                    you. Also, after you get<br>
                         the lists of numbers please specify which ones
                    of those are missing when<br>
                         you get into Edit mode.<br>
                    <br>
                         Regards,<br>
                         Andrew<br>
                    <br>
                         On 08/02/2015 04:43 PM, Abel Alejandro wrote:<br>
                         > Hello,<br>
                         ><br>
                         > We have a bug (it happens to anyone so its
                    not a local browser issue)<br>
                         > when we modify a particular subscriber in
                    order to add new extra<br>
                         alias,<br>
                         > it keeps deleting a specific set number of
                    aliases because they do not<br>
                         > appear automatically when we "Edit" the
                    subscriber. We have to<br>
                         manually<br>
                         > keep putting the numbers of existing alias
                    on the Alias edit form so<br>
                         > they do not get deleted.<br>
                         ><br>
                         > Any tips how to troubleshoot?<br>
                    <br>
                    <br>
                    <br>
                    <br>
                    -- <br>
                    /Abel Alejandro/<br>
                    <br>
                    <a moz-do-not-send="true"
                      href="tel:787%20586%208313" value="+17875868313"
                      target="_blank">787 586 8313</a> | <a
                      moz-do-not-send="true" href="tel:787%20705%200555"
                      value="+17877050555" target="_blank">787 705 0555</a><br>
                    <mailto:<a moz-do-not-send="true"
                      href="mailto:joquendo@alliedtechnologygrouppr.com"
                      target="_blank">joquendo@alliedtechnologygrouppr.com</a>><br>
                    <br>
                    400 Calle Calaf 477<br>
                    San Juan, PR 00918<br>
                    <a moz-do-not-send="true"
                      href="mailto:aalejandro@alliedtechnologygrouppr.com"
                      target="_blank">aalejandro@alliedtechnologygrouppr.com</a><br>
                    <mailto:<a moz-do-not-send="true"
                      href="mailto:aalejandro@alliedtechnologygrouppr.com"
                      target="_blank">aalejandro@alliedtechnologygrouppr.com</a>><br>
                  </blockquote>
                </div>
              </div>
              _______________________________________________<br>
              Spce-user mailing list<br>
              <a moz-do-not-send="true"
                href="mailto:Spce-user@lists.sipwise.com"
                target="_blank">Spce-user@lists.sipwise.com</a><br>
              <a moz-do-not-send="true"
                href="https://lists.sipwise.com/listinfo/spce-user"
                rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
            </blockquote>
            <br>
          </blockquote>
        </div>
        <br>
        <br clear="all">
        <div><br>
        </div>
        -- <br>
        <div class="gmail_signature">
          <div dir="ltr"><span
style="font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);color:rgb(102,102,102)"><i><font
                  face="'trebuchet ms', sans-serif" size="4">Abel
                  Alejandro</font></i></span>
            <div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span
                style="color:rgb(51,51,51);font-family:'trebuchet
                ms',sans-serif">787 586 8313 </span><span
                style="font-family:'trebuchet ms',sans-serif"><font
                  color="#ff6600">|</font></span><span
                style="color:rgb(51,51,51);font-family:'trebuchet
                ms',sans-serif"> 787 705 0555</span>
              <div>
                <div><br>
                </div>
                <div><span
                    style="color:rgb(102,102,102);font-family:'trebuchet
                    ms',sans-serif">400 Calle Calaf 477</span></div>
                <div>
                  <div style="text-align:left"><span
                      style="color:rgb(102,102,102);font-family:'trebuchet
                      ms',sans-serif">San Juan, PR 00918</span></div>
                </div>
              </div>
            </div>
            <div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255);text-align:left"><a
                moz-do-not-send="true"
                href="mailto:aalejandro@alliedtechnologygrouppr.com"
                target="_blank">aalejandro@alliedtechnologygrouppr.com</a></div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>