Cachedgroupmembers oddness?

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 |/

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

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

At 07:54 AM 2/05/2003 -0400, Jesse Vincent wrote:

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.

Was on 0.81_3, but 0.81_4 fixes the problem. Thanks for the excellent work.

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 |/