[rt-users] Problem with lost links - can someone confirm my fix (before I break stuff!)

[LAW Andy]

On 7 Jan 2011, at 14:54, Kevin Falcone wrote:

> On Fri, Jan 07, 2011 at 12:35:54PM +0000, LAW Andy wrote:
>> All,
>> 
>> I've been going back through our RT system and I've noticed that
>> links between "old" tickets are missing/broken. I think that I
>> understand the reason for this but I'd appreciate someone confirming
>> it for me before I hack the database (and potentially break things).
> 
> If you've changed your Organization in your RT config, then yes, you
> will need to repair your Links and Transactions table to have the
> correct Organization.  Ensure you have a proper backup before starting
> of course.

Thanks for that confirmation.

You would not believe what level/number of backups that I have :o} (it is a number *far* greater than zero).

In progressing this, I found that I had re-asserted some of the links and so I tripped up with duplicate keys in the Links table. I simply deleted the later records in each case but I suspect that I now have trailing records in the Transactions table. Do I need to clean those out or am I safe to just ignore them?


Later,

Andy
--------
Yada, yada, yada...

The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336 
Disclaimer: This e-mail and any attachments are confidential and intended solely for the use of the recipient(s) to whom they are addressed. If you have received it in error, please destroy all copies and inform the sender.


-- 
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.