<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>