[Spce-user] unable to add phone number

[Marc Storck]

The system is running the very latest versions:

root at sipwise:~# apt-get update && apt-get upgrade &&  ngcp-update-db-schema && ngcp-update-cfg-schema &&  ngcpcfg apply
Hit http://debian.mirror.root.lu wheezy Release.gpg
…
…
Fetched 461 kB in 2s (190 kB/s)          
Reading package lists... Done
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

This is what is in oss.log:

Oct 10 11:02:02 sipwise /usr/sbin/apache2: Failed to update subscriber. (DBIx::Class::ResultSet::create(): DBI Exception: DBD::mysql::st execute failed: Duplicate entry '123456789-sipwise.2ld.tld' for key 'alias_idx' [for Statement "INSERT INTO `provisioning`.`voip_dbaliases` ( `domain_id`, `subscriber_id`, `username`) VALUES ( ?, ?, ? )" with ParamValues: 0='3', 1='7', 2="123456789"] at /usr/share/perl5/NGCP/Panel/Controller/Subscriber.pm line 1580#012)

Regards,

Marc Storck
-- 
Chief Information Officer
voipGATE S.A.
http://mstorck.voipgate.tel

On Oct 10, 2013, at 10:54 AM, Daniel Grotti <dgrotti at sipwise.com> wrote:

> Signed PGP part
> Hi,
> 
> Can't reproduce it, I mean I get only "Duplicate entry" if I try to
> add a number already in use by another subscriber.
> 
> Can you update your version to the latest packages ? (apt-get update
> && apt-get upgrade)
> 
> Daniel
> 
> 
> 
> On 10/10/2013 10:27 AM, Marc Storck wrote:
> > 123456789 is the Primary Number shown in the Subscriber Master
> > Data.
> > 
> > (When I click onto Edit. The Primary Numbers is now named E164.
> > (why?))
> > 
> > In the Edit Subscriber Master Data I can click Add another number.
> > Which adds a line titeled Alias Number.
> > 
> > I enter 987654321 as the alias number and the system complains that
> > the Primary Number already exists when clicking onto Save.
> > 
> > Regards,
> > 
> > Marc
> > 
> > On Oct 10, 2013, at 10:18 AM, Daniel Grotti <dgrotti at sipwise.com>
> > wrote:
> > 
> >> Signed PGP part Hi,
> >> 
> >> Which number are you talking about ? Alias number ? allowed_clis
> >> ? which field ?
> >> 
> >> Daniel
> >> 
> >> 
> >> 
> >> On 10/10/2013 10:10 AM, Marc Storck wrote:
> >>> Sorry I wasn't specific enough.
> >>> 
> >>> User A already has the number 123456789 and I want to add the 
> >>> number 987654321.
> >>> 
> >>> The system complains about the number 123456789 already exists,
> >>> but I'm not trying to add that one. It seems that the GUI tries
> >>> to add all the numbers instead of adding only the new ones.
> >>> 
> >>> Regards,
> >>> 
> >>> Marc
> >>> 
> >>> On Oct 9, 2013, at 5:40 PM, Jeremie Chism <jchism2 at gmail.com> 
> >>> wrote:
> >>> 
> >>>> Looks like that number is already in sipwise on another 
> >>>> subscriber.
> >>>> 
> >>>> Sent from my iPhone
> >>>> 
> >>>>> On Oct 9, 2013, at 9:39 AM, Marc Storck
> >>>>> <mstorck at voipgate.com> wrote:
> >>>>> 
> >>>>> Hello,
> >>>>> 
> >>>>> wehen I try to add a phone number to a subscriber I do get
> >>>>> the following error message:
> >>>>> 
> >>>>> Failed to update subscriber. (Duplicate entry 
> >>>>> '123456789-sipwise.sld.tld')
> >>>>> 
> >>>>> The alias phone number is not added to the subscriber.
> >>>>> 
> >>>>> I'm using the very latest Sipwise CE 3.0.
> >>>>> 
> >>>>> Does anybody have a clue?
> >>>>> 
> >>>>> Regards,
> >>>>> 
> >>>>> Marc _______________________________________________
> >>>>> Spce-user mailing list Spce-user at lists.sipwise.com 
> >>>>> http://lists.sipwise.com/listinfo/spce-user
> >>> 
> >>> 
> >>> 
> >>> _______________________________________________ Spce-user
> >>> mailing list Spce-user at lists.sipwise.com 
> >>> http://lists.sipwise.com/listinfo/spce-user
> >>> 
> >> 
> >> 
> >> _______________________________________________ Spce-user mailing
> >> list Spce-user at lists.sipwise.com 
> >> http://lists.sipwise.com/listinfo/spce-user
> >
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4422 bytes
Desc: not available
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20131010/3598d8f8/attachment-0001.p7s>