[Spce-user] sip:provider CE v3.0 released!

[Theo]

Yep that worked! thanks. Busy running upgrade again, will let you know


On Thu, Aug 22, 2013 at 11:15 PM, Andrew Pogrebennyk <
apogrebennyk at sipwise.com> wrote:

> On 22/08/2013 23:04, Theo wrote:
> > ok thinking a little more - I ran your query and found the entries, but
> > my database knowledge is REALLY limited. How would I delete those
> > entries? I tried to be clever and simply replace SELECT with DELETE but
> > that's clearly wrong....
>
> I see, then you can delete them with something like:
>
> delete from location where ruid in (select ruid from (select * from
> location loc group by ruid having count(*) > 1) as ruid);
>
> Andrew
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130822/757c3442/attachment-0001.html>