[Spce-user] Adding peer gives 'Duplicate entry error

[Andrew Pogrebennyk]

The update is released to 3.1 repositories - for those who have not
sorted it out yet, just run apt-get update/upgrade and
ngcp-update-db-schema as usual. The update also includes the ngcp-panel
fix for deleting the peer_preferences properly when a whole peering
group is being deleted.

On 03/07/2014 01:24 PM, gerry kernan wrote:
> Hi Andrew,
> 
> Thanks, that sorted it.
> 
> Regards
> 
> Gerry
> 
> 
> -----Original Message-----
> From: Andrew Pogrebennyk [mailto:apogrebennyk at sipwise.com] 
> Sent: 07 March 2014 12:19
> To: gerry kernan; 'Spce-user'
> Subject: Re: [Spce-user] Adding peer gives 'Duplicate entry error
> 
> Hi Gerry,
> 
> ok correct - please change select to delete now:
> 
> mysql kamailio -e "DELETE FROM peer_preferences WHERE uuid NOT IN (SELECT flags FROM lcr_gw);"
> 
> Regards,
> Andrew
>