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

[Theo]

and the entries are gone:

Database changed
mysql> SELECT  * FROM    location loc1 WHERE   EXISTS         (
SELECT  1         FROM    location loc2         WHERE   loc2.ruid =
loc1.ruid         LIMIT 1, 1         );
Empty set (0.00 sec)



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

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