rburg at shv
Nov 5, 2009, 7:42 AM
Post #4 of 4
(764 views)
Permalink
|
|
Re: Ticket links missing after upgrade of RT server.
[In reply to]
|
|
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
use that name instead.
#
# Replace the values in table Links
Base=replace(Base,'fsck.com-rt://OLDORGANIZATION/ticket/','fsck.com-rt:/
/NEWORGANIZATION/ticket/');
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:
'%fsck.com-rt://NEWORGANIZATION/ticket/%';
'%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
OldValue=replace(OldValue,'fsck.com-rt://OLDORGANIZATION/ticket/','fsck.
com-rt://NEWORGANIZATION/ticket/');
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:
'%fsck.com-rt://NEWORGANIZATION/ticket/%';
'%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.
#
Regards,
Ron van den Burg
-----Original Message-----
From: rt-users-bounces [at] lists
[mailto:rt-users-bounces [at] lists] 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.
On Fri, 2009-10-09 at 11:46 -0400, Jesse Vincent wrote:
>
> On Fri, Oct 09, 2009 at 11:44:44AM -0400, Jason A. Smith wrote:
> > 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 [at] bnl |
| 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
>>-----------------------------------------<<
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: sales [at] bestpractical
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
|
smime.p7s
