[rt-users] RTx-Shredder Error

[Ruslan Zakirov]

On 2/21/07, Torsten Brumm <torsten.brumm at googlemail.com> wrote:
> So, how do i delete them? Directly inside the DB or???
Directly.

>
> Torsten
>
> 2007/2/21, Ruslan Zakirov <ruslan.zakirov at gmail.com>:
> > You can delete all these links as they point to tickets that don't
> > exist anymore. This was a bug in shredder which leaved links in system
> > in some situations and I think it's fixed.
> >
> > Be very accurate.
> >
> > On 2/21/07, Torsten Brumm <torsten.brumm at googlemail.com> wrote:
> > > Hi Ruslan,
> > >
> > > sorry, i forgot, sometimes its too much to remember ;-9
> > >
> > > Here we go with the statements:
> > >
> > > mysql> SELECT l.* FROM Links l LEFT JOIN Tickets t ON l.LocalTarget =
> t.id
> > >     -> WHERE l.LocalTarget >= 0 AND t.id IS NULL;
> > >
> > [snip]
> >
> > --
> > Best regards, Ruslan.
> >
>
>
>
> --
>
> MFG
>
> Torsten Brumm
>
> http://www.torsten-brumm.de


-- 
Best regards, Ruslan.