A silly question

RT Users
1

hello world

I’m wondering if the rt1 script run on rt2 despite of the database’s
diferences

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

thanks to all

Ce mel a �t� envoy� avec Meloo http://www.meloo.com

CleanDB.pl (2.73 KB)

2

I’m wondering if the rt1 script run on rt2 despite of the database’s
diferences

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)

Regards

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations