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

[Theo]

Hi Andrew

That did the trick! Thanks.

Still problems with apache but have started a new thread on that one.

Cheers


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

> 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
> >
> >
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130823/7cbb8f19/attachment-0001.html>