If you want to change $Organization (or have changed it in the passed
and think you may have links before the change), you may follow the
instructions below.
PLEASE BE CAREFUL AND ONLY DO THIS IF YOU UNDERSTAND THE CONSEQUENCES
Change $Organization in RT_SiteConfig.pm. In the text below, replace
OLDORGANIZATION and NEWORGANIZATION with what you changed here.
Restart you web server
FOR MYSQL
start mysql prompt
#mysql -p
mysql> show databases;
mysql> connect rt3; # If you changed $DatabaseName in RT_SiteConfig.pm,
use that name instead.
Replace the values in table Links
mysql> update Links set
Base=replace(Base,‘fsck.com-rt://OLDORGANIZATION/ticket/’,‘fsck.com-rt:/
/NEWORGANIZATION/ticket/’);
mysql> update Links set
Target=replace(Target,‘fsck.com-rt://OLDORGANIZATION/ticket/’,‘fsck.com-
rt://NEWORGANIZATION/ticket/’);
If you want to see whether you still have links that are not yet
repaired:
mysql> select Base from Links where Base not like
‘%fsck.com-rt://NEWORGANIZATION/ticket/%’;
mysql> select Target from Links where Target not like
‘%fsck.com-rt://NEWORGANIZATION/ticket/%’;
Now you can see the older values of $Organization. So repeate the
proper update command above with the proper OLDORGANIZATION.
Replace the values in table Transactions
mysql> update Transactions set
OldValue=replace(OldValue,‘fsck.com-rt://OLDORGANIZATION/ticket/’,‘fsck.
com-rt://NEWORGANIZATION/ticket/’);
mysql> update Transactions set
NewValue=replace(NewValue,‘fsck.com-rt://OLDORGANIZATION/ticket/’,‘fsck.
com-rt://NEWORGANIZATION/ticket/’);
If you want to see whether you still have transactions that are not
yet repaired:
mysql> select OldValue from Transactions where OldValue not like
‘%fsck.com-rt://NEWORGANIZATION/ticket/%’;
mysql> select NewValue from Transactions where NewValue not like
‘%fsck.com-rt://NEWORGANIZATION/ticket/%’;
Now you can see the older values of $Organization. So repeate the
proper update command above with the proper OLDORGANIZATION.
mysql> \q
Regards,
Ron van den BurgFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Jason A.
Smith
Sent: Friday, October 09, 2009 10:03 PM
To: rt-users
Subject: Re: [rt-users] Ticket links missing after upgrade of RT server.
I am in the process of preparing a new upgraded RT server and after
dumping our current DB, loading it into the new test RT server and
following the DB upgrade procedures, everything seems to look okay,
except for missing ticket links. When I try to display an old
ticket
that should have a link to another ticket, no link is shown in the
Link
box and I get this error message in my server logs:
At a quick guess, you changed your $Organization. You should not do
that.
Yup, that was it, typo there. I thought it was probably something in
the config and I double checked my rtname and some other things, just
forgot about that one.
Thanks,
~Jason
/------------------------------------------------------------------
| Jason A. Smith Email: smithj4@bnl.gov |
| Atlas Computing Facility, Bldg. 510M Phone: +1-631-344-4226 |
| Brookhaven National Lab, P.O. Box 5000 Fax: +1-631-344-7616 |
| Upton, NY 11973-5000, U.S.A. |
------------------------------------------------------------------/
-----------------------------------------<<
The information transferred by this e-mail is solely for
the intended recipient(s).
Any disclosure, copying, distribution of this e-mail by
and to others is not allowed. If you are not an intended recipient,
please delete this e-mail and notify the sender.
SHV Holdings N.V.
Commercial Register 30065974
-----------------------------------------<<