I’m wondering if the rt1 script run on rt2 despite of the database’s
Generally, you should not take rt1 scripts and run them on rt2 without
serious examanation of any schema assumptions that the script is doing.
Bad mysterious things happen (the docs mention kneecaps for some reason).
here is a script to clean a mysql database, i test it , it seems to
work, if anyone is interested tell me yours feeling about it
The script quoted would appear to work on the RT 2.0.x series, except that
you’re leaving ticket Watchers hanging. (delete from Watchers where Type
= ‘Requestor’ AND Scope = ‘Ticket’ AND Value = TicketId)
Bruce Campbell RIPE
Systems/Network Engineer NCC
www.ripe.net - PGP562C8B1B Operations