[Rt-devel] Re: Bug in RT::Tickets::LimitMemberOf (3.0.12 & 3.2.3)

[Ruediger Riediger]

Jesse Vincent wrote:
> On Mon, May 09, 2005 at 10:27:16AM +0200, Ruediger Riediger wrote:
> 
>>-> this apparently affects also 3.2.3, I did not see any code changes
>>from 3.0.12 in the relevant parts.
> 
> 
> Does 3.4 behave better?

I do not have it installed, but will pull the source, configure it, and
compare the relevant parts. Now I know what to check for ;-)


Some update:
The following MySQL commands show the issue:

mysql> SELECT Id,Target,LocalTarget,Type FROM Links WHERE Target LIKE
"fsck.com-rt://sun.com/%" AND Target !=
concat("fsck.com-rt://sun.com/ticket/", LocalTarget) ;

mysql> SELECT Id,Base,LocalBase,Type FROM Links WHERE Base LIKE
"fsck.com-rt://sun.com/%" AND Base !=
concat("fsck.com-rt://sun.com/ticket/", LocalBase);

-> Obviously, change "sun.com" to your domain prefix from RT::URI.


The following MySQL commands *FIX* the issue:

mysql> UPDATE Links SET LocalTarget =
replace(Target,'fsck.com-rt://sun.com/ticket/','') WHERE Target LIKE
"fsck.com-rt://sun.com/%" AND Target !=
concat("fsck.com-rt://sun.com/ticket/", LocalTarget);

mysql> UPDATE Links SET LocalBase =
replace(Base,'fsck.com-rt://sun.com/ticket/','') WHERE Base LIKE
"fsck.com-rt://sun.com/%" AND Base !=
concat("fsck.com-rt://sun.com/ticket/", LocalBase);


Code change for Ticket::MergeInto still outstanding - I will check 3.4
before making any changes.

Best regards,

	Ruediger Riediger

-- 
Dr. Ruediger Riediger                              Sun Microsystems GmbH
NSG - SunCERT                                             Komturstr. 18a
mailto:Ruediger.Riediger at Sun.com                          D-12099 Berlin
------------------------------------------------------------------------
NOTICE:  This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.
------------------------------------------------------------------------
PGP 2048RSA/0x2C5020E9          964C E189 0FF0 8882  2BAB 65E2 6912 1FF2
------------------------------------------------------------------------