Tickets links are lost after upgrade to 4.0.9

RT Users
1

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

2

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

3

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.

We added a --fix-links option to the 4.2 version of rt-validator,
however we’ve run it on 4.0 installs without trouble.

You can grab

using the raw link and copy it into your unpacked 4.0.9 tarball
over the top of the existing sbin/rt-validator.in
Rerun configure (the incant is saved in /opt/rt4/etc/RT_Config.pm if
you’ve forgotten it) and then read ./sbin/rt-validator --help for the
links only code.

As always, make sure you have a current working backup before running
the validator.

-kevin