To add detail to my issue it seems to only happen when clicking from a Search/Results.html link, but it doesn't appear to be referrer based because if you turn them off it still happens, which makes me think it's possibly a session variable that's triggering it? Refreshes or direct url doesn't do it either.. for example here is the query output when clicking from the search results with surrounding queries.. They may be from tickets but the behavior is the same.
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicketComments') AND Principals.id = ACL.PrincipalId AND Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedGroupMembers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 AND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = 3)) LIMIT 1 233 Query SELECT main.* FROM Tickets main WHERE (main.Status != 'deleted') AND ( ( main.Subject LIKE '%e%' ) ) AND (main.Effecti veId = main.id) AND (main.Type = 'ticket') ORDER BY main.id ASC 33 Query SELECT * FROM Users WHERE id = '12' And this is what happens from anywhere else, the query is missing and working as intended. 245 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser' OR ACL.RightName = 'ShowTicketComments') AND Principals.id = ACL.PrincipalId AND Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedGroupMembers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 AND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Ticket' AND ACL.ObjectId = 2)) LIMIT 1 245 Query SELECT * FROM Users WHERE id = '12' Does anyone have any idea how to fix this? Is this suppose to happen? Any kind of confirmation would be great. Curtis Curtis Bruneau wrote: > Just an update, I have reinstalled the machine in attempt to solve > this problem, I am using etch packaged apache2+mod_perl2 and mysql5 > and the problem still occurs, here is a trimmed sql output from a > Ticket/Display.html?id=x, attached is the full log for that one page > view. > > 233 Query SELECT * FROM Tickets WHERE id = '3' <- The query > which gets the ticket details. > 233 Query SELECT main.* FROM Tickets main WHERE (main.Status != > 'deleted') AND ( ( main.Subject LIKE '%e%' ) ) AND (main.Effecti > veId = main.id) AND (main.Type = 'ticket') ORDER BY main.id ASC <- > the problem query derived from search criteria with no limit. > > Anyone know what it's used for? It's a dangerous query with > potentially large results. *Can anyone confirm if this happens to them?* > > I tried to use as many packages as possible that reasonably met the > version requirements, the others were done from source. make testdeps > comes back fine, I attempted to upgrade to the latest versions for > modules that could be related to the db/query. The module versions are > also attached. > > Thanks _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
