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