[rt-users] RTx-Shredder Error

[Torsten Brumm]

So, how do i delete them? Directly inside the DB or???

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20070221/d2f793fe/attachment.htm>