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

[Andrew Pogrebennyk]

Theo,

please do mysql -u root kamailio
ALTER TABLE aliases DROP INDEX ruid_idx;

then re-run the script.

On 08/22/2013 11:32 PM, Theo wrote:
> Applying revision script /usr/share/ngcp-db-schema/db_
> scripts/diff/13659.up: ERROR 1061 (42000) at line 7: Duplicate key name
> 'ruid_idx'
> 
> is what I meant to copy and paste
> 
> 
> On Thu, Aug 22, 2013 at 11:31 PM, Theo <axessofficetheo at gmail.com
> <mailto:axessofficetheo at gmail.com>> wrote:
> 
>     Hi
> 
>     No, that's what I am trying to say - the entries are gone but
>     running the upgrade again gives me:
> 
>     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:21 PM, Andrew Pogrebennyk
>     <apogrebennyk at sipwise.com <mailto:apogrebennyk at sipwise.com>> wrote:
> 
>         On 22/08/2013 23:20, Theo wrote:
>         > 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)
> 
>         then just run ngcp-upgrade again.. Good luck!
> 
>         Andrew
> 
> 
>