<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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:<div><br><div><span class="Apple-tab-span" style="white-space:pre"> </span>f<span class="Apple-tab-span" style="white-space:pre">sck.com-rt://example.com/ticket/123490</span></div><div><br></div><div>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.</div><div><br></div><div>Considering the above state, I am puzzled as to what specifically needs to be done for DB cleanup?</div><div><br></div><div>Thanks,</div><div>Behzad<br><div><div>On Feb 11, 2010, at 10:04 AM, Behzad Mahini wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Sorry for my previous repeat question, as there was a delay in our mailserver to receive this response.<div><br><div>I have a followup question, see inlines below.</div><div><br></div><div>Thanks,</div><div>Behzad<br><div><blockquote type="cite"><div><blockquote type="cite"><font class="Apple-style-span" color="#144FAE"><font class="Apple-style-span" color="#006312"><br></font></font></blockquote><br><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span>2) Since currently I don't have my $Organization defined per my <br></blockquote><blockquote type="cite">RT_SiteConfig.pm, and I presume since RT_Config.pm has it defined as <br></blockquote><blockquote type="cite">"example.com", I am receiving some<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span> emails as follows:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:ticket#xxx@example.com">ticket#xxx@example.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Again, If I were to remedy this separate issue, by adding the <br></blockquote><blockquote type="cite">following in my RT_SIteConfig.pm:<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Set($Organization , "MY_DOMAIN.com");<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"> </span>Will that address this other issue, without causing negative side <br></blockquote><blockquote type="cite">effects.<br></blockquote><br>This will break your existing ticket links unless you clean up the DB<br></div></blockquote><div><br></div><span class="Apple-tab-span" style="white-space:pre"> </span>What do I need to do specifically for DB cleanup?<br><blockquote type="cite"><div><br>-kevin<br></div></blockquote></div><br></div></div></div></blockquote></div><br></div></div></body></html>