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.
_______________________________________________
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
