[rt-users] Tickets links are lost after upgrade to 4.0.9

[Jeffrey Fearn]

I'm sure there should be a less intrusive way, but here is how I do it in MySQL.

update Links set Base = replace(Base, 'foo.example.com', 'bar.example.com');
update Links set Target = replace(Target, 'foo.example.com', 'bar.example.com');

update Transactions set NewValue = replace(NewValue, 'foo.example.com', 'bar.example.com');
update Transactions set OldValue = replace(OldValue, 'foo.example.com', 'bar.example.com');

Cheers, Jeff.

----- Original Message -----
> Hi
> 
> We recently upgraded from ver 3.6 to ver. 4.0.9,and one of the things
> a we
> noticed was that old ticket links are lost and we can no longer see
> the
> references in history of each ticket.
> 
> The links are probably lost due to change in Organisation name
> change. Is there
> a easier way to fix this? Links created subsequently work just fine.
> 
> Thanks in advance.
> 
> -Olavo