On 2/21/07, Torsten Brumm <[EMAIL PROTECTED]> wrote:
So, how do i delete them? Directly inside the DB or???
Directly.
Torsten
2007/2/21, Ruslan Zakirov <[EMAIL PROTECTED]>:
> 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 <[EMAIL PROTECTED]> 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.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
