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#...@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


_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com

2010 RT Training Sessions!
San Francisco, CA, USA - Feb 22 & 23
Dublin, Ireland - Mar 15 & 16
Boston, MA, USA - April 5 & 6
Washington DC, USA - Oct 25 & 26

Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Reply via email to