<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>Hi
Dave,</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>I think I have found
one case where the script can corrupt the database. I used it before trying to
upgrade a database from RT2 to RT3 and it made the import
fail.</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>I had ticket A in my
database marked as depending on ticket B. This appears in table
"links"</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003> </SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>Ticket B is now
marked as "solved"</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>Ticket A
has been deleted. I guess it was marked as "DEAD"</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>The inconsistency is
in the "links" database. The link between tickets A and B is not
removed. It probably shouldn't anyway. It now points to a non existing ticket
A.</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>In this situation,
it would probably be better not to delete ticket A.</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial size=2>In a functionning
RT2 database, this inconsistency does not seem to have any negative effects.
Only one ticket was involved in my system.</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2>Blaise</FONT></SPAN></DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=716385221-22012003><FONT face=Arial
size=2>----------------------------------------------------------------</FONT> </SPAN></DIV>
<DIV><SPAN class=716385221-22012003>> </SPAN>See below. This script was
based on Steve Poirier's 'cleanup' script, but <BR><SPAN
class=716385221-22012003>> </SPAN>has been modified to kill what I am calling
'Crazy' tickets -- ones that <BR><SPAN class=716385221-22012003>>
</SPAN>for whatever reason have gotten >200 transactions associated with
them <BR><SPAN class=716385221-22012003>> </SPAN>(this would never
happen naturally in our environment, YMMV). <BR><SPAN
class=716385221-22012003></SPAN><FONT face=Arial>><SPAN
class=716385221-22012003> </SPAN></FONT><BR><SPAN
class=716385221-22012003><FONT face=Arial>> </FONT></SPAN>Also kills 'dead'
tickets as well as optimizes all the tables. I run this <BR><SPAN
class=716385221-22012003>> </SPAN>twice a day.<BR><SPAN
class=716385221-22012003></SPAN><FONT face=Arial><FONT size=2>><SPAN
class=716385221-22012003> </SPAN></FONT></FONT><BR><SPAN
class=716385221-22012003>> </SPAN>Dave<BR><BR></DIV></BODY></HTML>