<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 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 href="tel:17877487645" value="+17877487645" target="_blank">17877487645</a> and <a 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 href="tel:17877052432" value="+17877052432" target="_blank">17877052432</a> | 3 | 47 | 1 |<br>
| 9222 | <a href="tel:17872687353" value="+17872687353" target="_blank">17872687353</a> | 3 | 47 | 0 |<br>
| 9223 | <a href="tel:17876524000" value="+17876524000" target="_blank">17876524000</a> | 3 | 47 | 0 |<br>
| 9224 | <a href="tel:17876524001" value="+17876524001" target="_blank">17876524001</a> | 3 | 47 | 0 |<br>
| 9225 | <a href="tel:17876524002" value="+17876524002" target="_blank">17876524002</a> | 3 | 47 | 0 |<br>
| 9226 | <a href="tel:17876524003" value="+17876524003" target="_blank">17876524003</a> | 3 | 47 | 0 |<br>
| 9227 | <a href="tel:17876524004" value="+17876524004" target="_blank">17876524004</a> | 3 | 47 | 0 |<br>
| 9228 | <a href="tel:17878054100" value="+17878054100" target="_blank">17878054100</a> | 3 | 47 | 0 |<br>
| 9229 | <a href="tel:17878346242" value="+17878346242" target="_blank">17878346242</a> | 3 | 47 | 0 |<br>
| 9230 | <a href="tel:17879354000" value="+17879354000" target="_blank">17879354000</a> | 3 | 47 | 0 |<br>
| 9231 | <a href="tel:17879354001" value="+17879354001" target="_blank">17879354001</a> | 3 | 47 | 0 |<br>
| 9232 | <a href="tel:17879354002" value="+17879354002" target="_blank">17879354002</a> | 3 | 47 | 0 |<br>
| 9233 | <a href="tel:17879354004" value="+17879354004" target="_blank">17879354004</a> | 3 | 47 | 0 |<br>
| 9234 | <a href="tel:17879350102" value="+17879350102" target="_blank">17879350102</a> | 3 | 47 | 0 |<br>
| 9235 | <a href="tel:17878492888" value="+17878492888" target="_blank">17878492888</a> | 3 | 47 | 0 |<br>
| 9236 | <a href="tel:17876525000" value="+17876525000" target="_blank">17876525000</a> | 3 | 47 | 0 |<br>
| 9237 | <a href="tel:17876525001" value="+17876525001" target="_blank">17876525001</a> | 3 | 47 | 0 |<br>
| 9238 | <a href="tel:17876525002" value="+17876525002" target="_blank">17876525002</a> | 3 | 47 | 0 |<br>
| 9239 | <a href="tel:17876525003" value="+17876525003" target="_blank">17876525003</a> | 3 | 47 | 0 |<br>
| 9240 | <a href="tel:17876524005" value="+17876524005" target="_blank">17876524005</a> | 3 | 47 | 0 |<br>
| 9241 | <a href="tel:17876524006" value="+17876524006" target="_blank">17876524006</a> | 3 | 47 | 0 |<br>
| 9242 | <a href="tel:17876524007" value="+17876524007" target="_blank">17876524007</a> | 3 | 47 | 0 |<br>
| 9243 | <a href="tel:17876524008" value="+17876524008" target="_blank">17876524008</a> | 3 | 47 | 0 |<br>
| 9244 | <a href="tel:17876524009" value="+17876524009" target="_blank">17876524009</a> | 3 | 47 | 0 |<br>
| 9245 | <a href="tel:17876525004" value="+17876525004" target="_blank">17876525004</a> | 3 | 47 | 0 |<br>
| 9246 | <a href="tel:17872968286" value="+17872968286" target="_blank">17872968286</a> | 3 | 47 | 0 |<br>
| 9247 | <a href="tel:17872968284" value="+17872968284" target="_blank">17872968284</a> | 3 | 47 | 0 |<br>
| 9254 | <a href="tel:17879576222" value="+17879576222" target="_blank">17879576222</a> | 3 | 47 | 0 |<br>
| 9256 | <a href="tel:17879667163" value="+17879667163" target="_blank">17879667163</a> | 3 | 47 | 0 |<br>
| 9257 | <a href="tel:17879667586" value="+17879667586" target="_blank">17879667586</a> | 3 | 47 | 0 |<br>
| 9258 | <a href="tel:17879667589" value="+17879667589" target="_blank">17879667589</a> | 3 | 47 | 0 |<br>
| 9259 | <a href="tel:17879667592" value="+17879667592" target="_blank">17879667592</a> | 3 | 47 | 0 |<br>
| 9261 | <a href="tel:17879619786" value="+17879619786" target="_blank">17879619786</a> | 3 | 47 | 0 |<br>
| 9262 | <a href="tel:17879619787" value="+17879619787" target="_blank">17879619787</a> | 3 | 47 | 0 |<br>
| 9263 | <a href="tel:17879619788" value="+17879619788" target="_blank">17879619788</a> | 3 | 47 | 0 |<br>
| 9264 | <a href="tel:17879619789" value="+17879619789" target="_blank">17879619789</a> | 3 | 47 | 0 |<br>
| 9265 | <a href="tel:17877109657" value="+17877109657" target="_blank">17877109657</a> | 3 | 47 | 0 |<br>
| 9266 | <a href="tel:17876657891" value="+17876657891" target="_blank">17876657891</a> | 3 | 47 | 0 |<br>
| 9267 | <a href="tel:17876657892" value="+17876657892" target="_blank">17876657892</a> | 3 | 47 | 0 |<br>
| 9268 | <a href="tel:17877050939" value="+17877050939" target="_blank">17877050939</a> | 3 | 47 | 0 |<br>
| 9269 | <a href="tel:17877050940" value="+17877050940" target="_blank">17877050940</a> | 3 | 47 | 0 |<br>
| 9270 | <a href="tel:17877050948" value="+17877050948" target="_blank">17877050948</a> | 3 | 47 | 0 |<br>
| 9271 | <a href="tel:17877086472" value="+17877086472" target="_blank">17877086472</a> | 3 | 47 | 0 |<br>
| 9272 | <a href="tel:17877086473" value="+17877086473" target="_blank">17877086473</a> | 3 | 47 | 0 |<br>
| 9273 | <a href="tel:17879455094" value="+17879455094" target="_blank">17879455094</a> | 3 | 47 | 0 |<br>
| 9274 | <a href="tel:17879455096" value="+17879455096" target="_blank">17879455096</a> | 3 | 47 | 0 |<br>
| 9275 | <a href="tel:17879455097" value="+17879455097" target="_blank">17879455097</a> | 3 | 47 | 0 |<br>
| 9276 | <a href="tel:17879455098" value="+17879455098" target="_blank">17879455098</a> | 3 | 47 | 0 |<br>
| 9278 | <a href="tel:17877052433" value="+17877052433" target="_blank">17877052433</a> | 3 | 47 | 0 |<br>
| 9280 | <a href="tel:17877052436" value="+17877052436" target="_blank">17877052436</a> | 3 | 47 | 0 |<br>
| 9281 | <a href="tel:17877052437" value="+17877052437" target="_blank">17877052437</a> | 3 | 47 | 0 |<br>
| 9282 | <a href="tel:17877109659" value="+17877109659" target="_blank">17877109659</a> | 3 | 47 | 0 |<br>
| 9283 | <a href="tel:17877109661" value="+17877109661" target="_blank">17877109661</a> | 3 | 47 | 0 |<br>
| 9284 | <a href="tel:17877107631" value="+17877107631" target="_blank">17877107631</a> | 3 | 47 | 0 |<br>
| 9285 | <a href="tel:17877107632" value="+17877107632" target="_blank">17877107632</a> | 3 | 47 | 0 |<br>
| 9286 | <a href="tel:17879667014" value="+17879667014" target="_blank">17879667014</a> | 3 | 47 | 0 |<br>
| 9287 | <a href="tel:17879667019" value="+17879667019" target="_blank">17879667019</a> | 3 | 47 | 0 |<br>
| 9288 | <a href="tel:17879667017" value="+17879667017" target="_blank">17879667017</a> | 3 | 47 | 0 |<br>
| 9289 | <a href="tel:17879667029" value="+17879667029" target="_blank">17879667029</a> | 3 | 47 | 0 |<br>
| 9290 | <a href="tel:17873957441" value="+17873957441" target="_blank">17873957441</a> | 3 | 47 | 0 |<br>
| 9291 | <a href="tel:17879619794" value="+17879619794" target="_blank">17879619794</a> | 3 | 47 | 0 |<br>
| 9292 | <a href="tel:17879619793" value="+17879619793" target="_blank">17879619793</a> | 3 | 47 | 0 |<br>
| 9293 | <a href="tel:17877057382" value="+17877057382" target="_blank">17877057382</a> | 3 | 47 | 0 |<br>
| 9294 | <a href="tel:17877057383" value="+17877057383" target="_blank">17877057383</a> | 3 | 47 | 0 |<br>
| 9295 | <a href="tel:17872667259" value="+17872667259" target="_blank">17872667259</a> | 3 | 47 | 0 |<br>
| 9785 | <a href="tel:17879619790" value="+17879619790" target="_blank">17879619790</a> | 3 | 47 | 0 |<br>
| 9916 | <a href="tel:17877650130" value="+17877650130" target="_blank">17877650130</a> | 3 | 47 | 0 |<br>
| 9917 | <a href="tel:17877657386" value="+17877657386" target="_blank">17877657386</a> | 3 | 47 | 0 |<br>
| 9918 | <a href="tel:17877729149" value="+17877729149" target="_blank">17877729149</a> | 3 | 47 | 0 |<br>
| 10116 | <a href="tel:17877845000" value="+17877845000" target="_blank">17877845000</a> | 3 | 47 | 0 |<br>
| 10122 | <a href="tel:17877845051" value="+17877845051" target="_blank">17877845051</a> | 3 | 47 | 0 |<br>
| 10147 | <a href="tel:17877265929" value="+17877265929" target="_blank">17877265929</a> | 3 | 47 | 0 |<br>
| 10148 | <a href="tel:17877286969" value="+17877286969" target="_blank">17877286969</a> | 3 | 47 | 0 |<br>
| 10227 | <a href="tel:17877551210" value="+17877551210" target="_blank">17877551210</a> | 3 | 47 | 0 |<br>
| 10229 | <a href="tel:17877551235" value="+17877551235" target="_blank">17877551235</a> | 3 | 47 | 0 |<br>
| 10230 | <a href="tel:17877551260" value="+17877551260" target="_blank">17877551260</a> | 3 | 47 | 0 |<br>
| 10231 | <a href="tel:17877551300" value="+17877551300" target="_blank">17877551300</a> | 3 | 47 | 0 |<br>
| 10505 | <a href="tel:17874740636" value="+17874740636" target="_blank">17874740636</a> | 3 | 47 | 0 |<br>
| 10506 | <a href="tel:17874740637" value="+17874740637" target="_blank">17874740637</a> | 3 | 47 | 0 |<br>
| 10507 | <a href="tel:17874740638" value="+17874740638" target="_blank">17874740638</a> | 3 | 47 | 0 |<br>
| 10508 | <a href="tel:17874740639" value="+17874740639" target="_blank">17874740639</a> | 3 | 47 | 0 |<br>
| 10509 | <a href="tel:17874740640" value="+17874740640" target="_blank">17874740640</a> | 3 | 47 | 0 |<br>
| 10510 | <a href="tel:17874740641" value="+17874740641" target="_blank">17874740641</a> | 3 | 47 | 0 |<br>
| 10524 | <a href="tel:17879057355" value="+17879057355" target="_blank">17879057355</a> | 3 | 47 | 0 |<br>
| 10525 | <a 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 href="mailto:apogrebennyk@sipwise.com" target="_blank">apogrebennyk@sipwise.com</a> <mailto:<a 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 href="tel:787%20586%208313" value="+17875868313" target="_blank">787 586 8313</a> | <a href="tel:787%20705%200555" value="+17877050555" target="_blank">787 705 0555</a><br>
<mailto:<a href="mailto:joquendo@alliedtechnologygrouppr.com" target="_blank">joquendo@alliedtechnologygrouppr.com</a>><br>
<br>
400 Calle Calaf 477<br>
San Juan, PR 00918<br>
<a href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a><br>
<mailto:<a href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a>><br>
</blockquote></div></div>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a 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 size="4" face="'trebuchet ms', sans-serif">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)"><blockquote style="margin:0px 0px 0px 40px;border-style:none;padding:0px"></blockquote><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><a href="mailto:joquendo@alliedtechnologygrouppr.com" style="color:rgb(17,85,204)" target="_blank"></a><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 href="mailto:aalejandro@alliedtechnologygrouppr.com" target="_blank">aalejandro@alliedtechnologygrouppr.com</a></div></div></div>
</div>