Maybe this time I'll get an answer ..
RT-3.8.7 NO customisation apart from css
DBIx - 1.56 apache2,mod_perl2
I am seeing a lot of queries (1146 of them)
SELECT ACL.id FROM ACL, Groups, Principals, CachedGroupMembers WHERE
(ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowACL') AND
Raed,
The only thing I can think of to help de-bug this is to list the
privileges you've set and then compare that list to what you see in the
ACL table. Unless, of course, you have Rights Matrix installed. That
would also help. I don't know if Rights Matrix works on 3.8.x, but it
certainly
Thanks for your response Ken ,
I traced it down to missing entry in CachedGroupMembers;
When I upgraded my dev box from 3.6.3 to 3.8.7 I ran
shrink_cgm_table.pl, which for some reason (maybe something in my
system) deleted the following row:
mysql select * from CachedGroupMembers where id = 2;
Raed,
From my evaluations when scrutinizing the DB, I've noticed that it
seems ANY query saved by group (OH, this is on 3.6.4. I haven't had a
chance yet to REALLY look at the DB from a 3.8.x view) will always want
to check permissions for a single user that wants to look at that query
to
