[rt-users] RTx-Shredder Error

[Ruslan Zakirov]

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.