[rt-devel] cachedgroupmembers oddness?

[Jesse Vincent]

What database are you using? And what DBIx::SearchBuilder are you using? 
Early 0.81_x searchbuilders contained a bug that manifested as multiple
repeated entries in lists.


On Fri, May 02, 2003 at 06:23:18PM +1000, Philip Warner wrote:
> 
> I think that since upgrading to 3.02preX (now pre4) from 3.0, I have 
> started seeing duplicated usernames in lists.
> 
> The users table has only single entries, but most times a list of users is 
> presented or used, the usernames are duplicated. This means that the "10 
> Highest Priority Tickets I requested" has double entries, 
> "Counfiguration->Users" has double entries etc etc.
> 
> I have taken the query used to generate these lists, and it seems that the 
> problem is created by the final cross to CACHEDGROUPMEMBERS.
> 
> I'd be really interested to know what this table as and how/if it can be 
> reconstructed (on the assumption I broke it somehow).
> 
> 
> 
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.B.N. 75 008 659 498)          |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 03 5330 3172          |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.