Migrating from Windows (3.0.12) to Linux (3.4.2) a nd having issue s with Links/References in tickets

Ok, after some serious digging into the database itself, I’ve come up with
two lines of SQL that need to be run if you should change your $rtname and
$Organization variables. Not sure it this is perfect but it fixed my
problem at least.

update Links
set Base = replace(Base, ‘Old text’, ‘newdomain.com’)
where Base like ‘%Old text%’ ;

update Links
set Target = replace(Target, ‘Old text’, ‘newdomain.com’) where Target like
’%Old text%’ ;

Paul C.