So, how do i delete them? Directly inside the DB or???
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
_______________________________________________ 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
