[rt-devel] 3.0.10 Group Members "crash"

Jesse Vincent jesse at bestpractical.com
Sun Apr 4 12:05:07 EDT 2004


Can you send us the output of

EXPLAIN SELECT DISTINCT main.* FROM Users main, Principals       
Principals_1, CachedGroupMembers CachedGroupMembers_2  WHERE                    
((CachedGroupMembers_2.GroupId = '4')) AND ((Principals_1.Disabled = '0'))      
AND ((Principals_1.PrincipalType = 'User')) AND ((Principals_1.id =             CachedGroupMembers_2.MemberId)) AND ((main.id = Principals_1.id)or(main.id      
!= '1')or(main.id != '10')) ORDER BY main.Name ASC                              
                                                                                



More information about the Rt-devel mailing list