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

[Theo]

hmm another error:

Applying revision script
/usr/share/ngcp-db-schema/db_scripts/diff/13659.up: ERROR 1061 (42000) at
line 7: Duplicate key name 'ruid_idx'



On Thu, Aug 22, 2013 at 11:18 PM, Theo <axessofficetheo at gmail.com> wrote:

> 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/b6505929/attachment-0001.html>