[rt-users] My Ticket URL's are wrong When I Link Tickets -- RT 3.8.4

[Behzad Mahini]

Please. What do I need to do for database cleanup.? I looked at my  
database schema (MySQL), and the only table that had any relevance was  
"Links", and every single row in that table still has a reference to  
"example.com" (this includes even the Tickets that as a result of  
correcting my WebDomain in RT_SIteConfig.pm FROM "example.com" TO  
"MY_DOMAIN.com", yesterday per your comments ), as shown below:

	fsck.com-rt://example.com/ticket/123490

The strange thing is that after correcting my WebDomain variable, I  
can now (in the Links section of my UI) click on the URL of the  
Tickets that have Parent/Child association, and successfully be  
directed  to the proper URL of the associated Ticket. I take it, that  
this is a feature, and not a bug.

Considering the above state, I am puzzled as to what specifically  
needs to be done for DB cleanup?

Thanks,
Behzad
On Feb 11, 2010, at 10:04 AM, Behzad Mahini wrote:

> Sorry for my previous repeat question, as there was a delay in our  
> mailserver to receive this response.
>
> I have a followup question, see inlines below.
>
> Thanks,
> Behzad
>>>
>>
>>> 	2) Since currently I don't have my $Organization defined per my
>>> RT_SiteConfig.pm, and I presume since RT_Config.pm has it defined as
>>> "example.com", I am receiving some
>>> 	     emails as follows:
>>>
>>> 			ticket#xxx at example.com
>>>
>>> 		Again, If I were to remedy this separate issue, by adding the
>>> following in my RT_SIteConfig.pm:
>>> 			Set($Organization , "MY_DOMAIN.com");
>>>
>>> 		Will that address this other issue, without causing negative side
>>> effects.
>>
>> This will break your existing ticket links unless you clean up the DB
>
> 	What do I need to do specifically for DB cleanup?
>>
>> -kevin
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100212/35fc113f/attachment.htm>