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

[Kevin Falcone]

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.

-kevin

> When I look at the tickets, I see things like:
> 
> Fri Feb 01 12:00:46 2008	fred - Dependency by added
> 
> 
> 
> The system is reporting that there is a Dependency relationship but not picking up which ticket is at the other end of it.
> 
> 
> Picking around in the database itsefl, I see that the relationships seem to be in the Links table and that the items added to the tickets are in the Transactions table. I also note that there is a difference between "Base"/"Target" and "LocalBase"/"LocalTarget" in that the former also contains the sitename. It is *this* that I think is causing the problems.
> 
> We moved domain name some time ago and I suspect that the problems arise from this. The sitename in the Links that are "missing" is the old site name.
> 
> 
> So, am I on the right track here? If I do a global find/replace on the old sitename, converting it to the new one, will all my links spring into life again or will I just trash the whole system? If this *is* the way to go, apart from Links (Base|Target) and Transactions (NewValue) what else will I need to tweak?
> 
> 
> Thanks in advance.
> 
> 
> 
> 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.
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110107/d328bb20/attachment.sig>