[rt-users] RT 3.0.10 -> 3.0.12 upgrade; bug introduced

Ben Goodwin ben at atomicmatrix.net
Sun Sep 26 11:54:43 EDT 2004


A fresh install of RT 3.0.12 on FC2 with perl 5.8.3 and SB 1.11 results in
the same problem:

SELECT DISTINCT main.* FROM Tickets main , Transactions Transactions_1,
Attachments Attachments_2  WHERE ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (  (
(Attachments_2.TransactionId = Transactions_1.id)AND(main.id =
Transactions_1.Ticket)(Attachments_2.Created > '2004-09-17 15:22:50') ) AND
( (Attachments_2.TransactionId = Transactions_1.id)AND(main.id =
Transactions_1.Ticket)AND(Attachments_2.Created < '2004-09-26 23:59:59') )
) );

It's missing an AND up there - between the "main" clause and my "search"
clause it seems.  This problem doesn't show up with LimitStarts() - possibly
because it's dealing with tickets instead of transactions.

Can someone help me with this?  Thanks,

	-=| Ben






More information about the rt-users mailing list