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
Curtis Bruneau wrote:
Greetings everyone,
We're having an issue with several versions of RT that are all fully
functional aside from one aspect of operation. The brief description
of the problem is that when you go to /Ticket/Display.html?id=<id>
from a search page (/Search/Build.html or /Search/Simple.html ) what
appears to be happening is the search is saved in the session (normal)
but it's getting queried on Display along with the other queries.
This appears to be an extra query of no use with a limitless result
set. This is problematic because however many records your search
returns the display will try to load all the records into the web
server potentially causing the process to run out of memory.
Packaged OS Details:
-Debian Etch - kernel 2.6.18-6-amd64 x86_64 GNU/Linux
-apache2 2.2.3-4+etch4
-libapache2-mod-perl2 2.0.2-2.4
-mysql-server-5.0 5.0.51a-3~bpo40+1)
-perl v5.8.8
From source:
-libdbix-searchbuilder-perl_1.53-1
-libmodule-versions-report-perl_1.03-2
-libtext-quoted-perl-2.05-2
RT Versions Tested and Affected: 3.6.6, 3.7.85, 3.7.86, 3.8.0rc1
'make testdeps' in each RT version: PASSED
Steps to reproduce this problem:
1) Start with a clean installation and clean database.
2) Create a few tickets in the default "General" queue as root.
3) Enable mysql query logging
log = /var/log/mysql/mysql.log
Note: Without query logging on the database server you may not notice
it unless your search returned thousands of records causing major
slowness.
4) Next, load the search page in your browser by adding the search
criteria and then selecting "Update format and Search" (
Search/Build.html with a listing of the result set of your search).
For this example I created 2 test tickets with similar subjects and
made my search the subject for the text 'e' which will match both of
my tickets. There idea here is to get a common result with multiple
records to observe the general query on the db side.
5) Select one of the result tickets (/Ticket/Display.html?id=...)
6) **BUG LOADED HERE** -- the search clause, which appears to be
stored in the session are used on the following query. The actual
query used to display the data is separate and is limited by the
Ticket ID.
Watch the query log for:
Query SELECT main.* FROM Tickets main WHERE (main.Status !=
'deleted') AND (main.Subject LIKE '%e%') AND (main.EffectiveId =
main.id) AND (main.Type = 'ticket') ORDER BY main.id ASC
As you can see the query will return as many records as it matches,
potentially thousands or more. The same issue occurs regardless of the
search criteria and will always have no limit - it's basically the
same query as select count(*) when building the search results paging
list, the displayed results also have the same but with a
limit/offset. I can not seem to figure out why this is happening, the
only reason I can think of as to why this query is needed is possibly
some sort of count but the count is missing.
This problem does not occur when you go to the link directly with no
referring URL or a non search page, it only seems to happen when a
search is saved in the session. Could someone please test this to see
if this has been overlooked as most installations wouldn't show any
symptom of the problem until there were a large enough result set to
cause system memory exhaustion. If you aren't observing this problem I
wouldn't mind knowing as well.
Thank you in advance,
080718 11:32:17 233 Query SELECT * FROM Users WHERE Name =
'RT_System'
233 Query SELECT * FROM Users WHERE Name = 'Nobody'
233 Query SELECT
GET_LOCK('Apache-Session-c1a988c47cd483e43670f2854bc0ceae', 3600)
233 Query SELECT a_session FROM sessions WHERE id =
'c1a988c47cd483e43670f2854bc0ceae'
233 Query SELECT * FROM Groups WHERE Type =
'Privileged' AND Domain = 'SystemInternal'
233 Query SELECT * FROM Principals WHERE id = '12'
233 Query SELECT * FROM GroupMembers WHERE GroupId =
'4' AND MemberId = '12'
233 Query SELECT * FROM Tickets WHERE id = '3'
233 Query SELECT * FROM Queues WHERE id = '1'
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ShowTicket') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMem
bers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id
AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 A
ND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Ticket' AND ACL.O
bjectId = 3)) LIMIT 1
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 Cached
GroupMembers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId =
Principals.id AND CachedGroupMembers.MemberId = 12 AND
CachedGroupMembers.Disable
d = 0 AND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR
(ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::Ticket' A
ND 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
233 Query SELECT * FROM Users WHERE id = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ModifySelf') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMem
bers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id
AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 A
ND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::System' AND ACL.ObjectId = 1)) LIMIT 1
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ModifyTicket') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedGroupM
embers.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 ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'OwnTicket') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMemb
ers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id
AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 AN
D ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::Queue' AND ACL.ObjectId = 1) OR (ACL.ObjectType = 'RT::Ticket' AND ACL.Ob
jectId = 3)) LIMIT 1
233 Query SELECT main.* FROM Attributes main WHERE
(main.ObjectType = 'RT::User') AND (main.ObjectId = 12)
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ShowConfigTab') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedGroup
Members.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::System' AND ACL.ObjectId = 1)) LIMIT 1
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT main.* FROM Attributes main WHERE
(main.ObjectType = 'RT::Ticket') AND (main.ObjectId = 3)
233 Query SELECT DISTINCT main.* FROM Transactions
main JOIN Tickets Tickets_1 ON ( Tickets_1.id = main.ObjectId ) WHERE (main.
Creator != '12') AND (main.ObjectType = 'RT::Ticket') AND
(Tickets_1.EffectiveId = '3') AND (main.Type = 'Comment' OR main.Type =
'Correspond') ORDER BY m
ain.Created ASC, main.id ASC LIMIT 1
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'SeeQueue') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMembe
rs.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)) LIMIT 1
233 Query SELECT main.* FROM CustomFields main JOIN
ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomFiel
d = main.id ) WHERE (main.Disabled = '0') AND (ObjectCustomFields_1.ObjectId =
'1' OR ObjectCustomFields_1.ObjectId = '0') AND (main.LookupType = 'RT::Que
ue-RT::Ticket') GROUP BY main.id ORDER BY MAX(ObjectCustomFields_1.ObjectId)
DESC, MIN(ObjectCustomFields_1.SortOrder) ASC
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Groups WHERE Instance = '3'
AND Type = 'Requestor' AND Domain = 'RT::Ticket-Role'
233 Query SELECT DISTINCT main.* FROM Users main JOIN
Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMembers
GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') AND
(Group
Members_2.GroupId = '30') ORDER BY main.Name ASC
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT DISTINCT main.* FROM Groups main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMember
s GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (main.Domain = 'UserDefined') AND
(Principals_1
.PrincipalType = 'Group') AND (GroupMembers_2.GroupId = '30') ORDER BY
main.Name ASC
233 Query SELECT * FROM Groups WHERE Instance = '3'
AND Type = 'Cc' AND Domain = 'RT::Ticket-Role'
233 Query SELECT DISTINCT main.* FROM Users main JOIN
Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMembers
GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') AND
(Group
Members_2.GroupId = '32') ORDER BY main.Name ASC
233 Query SELECT DISTINCT main.* FROM Groups main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMember
s GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (main.Domain = 'UserDefined') AND
(Principals_1
.PrincipalType = 'Group') AND (GroupMembers_2.GroupId = '32') ORDER BY
main.Name ASC
233 Query SELECT * FROM Groups WHERE Instance = '3'
AND Type = 'AdminCc' AND Domain = 'RT::Ticket-Role'
233 Query SELECT DISTINCT main.* FROM Users main JOIN
Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMembers
GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (Principals_1.PrincipalType = 'User') AND
(Group
Members_2.GroupId = '33') ORDER BY main.Name ASC
233 Query SELECT DISTINCT main.* FROM Groups main
JOIN Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN GroupMember
s GroupMembers_2 ON ( GroupMembers_2.MemberId = Principals_1.id ) WHERE
(Principals_1.Disabled = '0') AND (main.Domain = 'UserDefined') AND
(Principals_1
.PrincipalType = 'Group') AND (GroupMembers_2.GroupId = '33') ORDER BY
main.Name ASC
233 Query SELECT DISTINCT main.Id AS id,
main.Filename AS filename, main.ContentType AS contenttype, main.Headers AS
headers, mai
n.Subject AS subject, main.Parent AS parent, main.ContentEncoding AS
contentencoding, main.ContentType AS contenttype, main.TransactionId AS
transactionid,
main.Created AS created FROM Attachments main JOIN Transactions Transactions_1
ON ( Transactions_1.id = main.TransactionId ) JOIN Tickets Tickets_2 ON (
Tickets_2.id = Transactions_1.ObjectId ) WHERE (Tickets_2.EffectiveId = '3')
AND (Transactions_1.ObjectType = 'RT::Ticket') ORDER BY main.id ASC
233 Query SELECT * FROM Transactions WHERE id = '38'
233 Query SELECT * FROM Transactions WHERE id = '39'
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ShowOutgoingEmail') AND Principals.id = ACL.PrincipalId
AND Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedG
roupMembers.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' AN
D ACL.ObjectId = 3)) LIMIT 1
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'AdminUsers') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMem
bers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id
AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 A
ND ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::System' AND ACL.ObjectId = 1)) LIMIT 1
233 Query SELECT DISTINCT main.* FROM Users main JOIN
Principals Principals_1 ON ( Principals_1.id = main.id ) JOIN CachedGroupM
embers CachedGroupMembers_2 ON ( CachedGroupMembers_2.MemberId =
Principals_1.id ) WHERE (Principals_1.Disabled = '0') AND
(CachedGroupMembers_2.GroupId
= '30') AND (CachedGroupMembers_2.Disabled = '0') AND
(Principals_1.PrincipalType = 'User') ORDER BY main.Name ASC
233 Query SELECT DISTINCT main.* FROM Tickets main
JOIN Links Links_1 ON ( Links_1.LocalTarget = '3' ) AND ( Links_1.Type = 'Ref
ersTo' ) AND ( Links_1.LocalBase = main.id ) WHERE (main.Status != 'deleted')
AND (main.Type = 'reminder' AND Links_1.LocalTarget IS NOT NULL) AND (main.E
ffectiveId = main.id)
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'SuperUser') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND
CachedGroupMemb
ers.GroupId = ACL.PrincipalId AND CachedGroupMembers.GroupId = Principals.id
AND CachedGroupMembers.MemberId = 12 AND CachedGroupMembers.Disabled = 0 AN
D ((ACL.ObjectType = 'RT::System' AND ACL.ObjectId = 1) OR (ACL.ObjectType =
'RT::System' AND ACL.ObjectId = 1)) LIMIT 1
233 Query SELECT DISTINCT main.* FROM Users main
CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.i
d ) JOIN CachedGroupMembers CachedGroupMembers_2 ON (
CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON (
Groups_3.id = CachedGro
upMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND
(ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND
(Principals_1.Princip
alType = 'User') AND (ACL_4.RightName = 'OwnTicket' OR ACL_4.RightName =
'SuperUser') AND (Groups_3.Domain = 'RT::Queue-Role' AND Groups_3.Instance =
'1')
AND ((ACL_4.ObjectType = 'RT::Queue' AND ACL_4.ObjectId = 1) OR
(ACL_4.ObjectType = 'RT::System')) ORDER BY main.Name ASC
233 Query SELECT DISTINCT main.* FROM Users main
CROSS JOIN ACL ACL_4 JOIN Principals Principals_1 ON ( Principals_1.id = main.i
d ) JOIN CachedGroupMembers CachedGroupMembers_2 ON (
CachedGroupMembers_2.MemberId = Principals_1.id ) JOIN Groups Groups_3 ON (
Groups_3.id = CachedGro
upMembers_2.GroupId ) WHERE (Principals_1.Disabled = '0') AND
(ACL_4.PrincipalType = Groups_3.Type) AND (Principals_1.id != '1') AND
(Principals_1.Princip
alType = 'User') AND (ACL_4.RightName = 'OwnTicket' OR ACL_4.RightName =
'SuperUser') AND (Groups_3.Domain = 'RT::System-Role') AND ((ACL_4.ObjectType =
'R
T::Queue' AND ACL_4.ObjectId = 1) OR (ACL_4.ObjectType = 'RT::System')) ORDER
BY main.Name ASC
233 Query SELECT DISTINCT main.* FROM Users main
CROSS JOIN ACL ACL_2 JOIN Principals Principals_1 ON ( Principals_1.id = main.i
d ) JOIN CachedGroupMembers CachedGroupMembers_3 ON (
CachedGroupMembers_3.MemberId = Principals_1.id ) WHERE (Principals_1.Disabled
= '0') AND (ACL_2.Pr
incipalId = CachedGroupMembers_3.GroupId) AND (Principals_1.id != '1') AND
(ACL_2.PrincipalType = 'Group') AND (Principals_1.PrincipalType = 'User') AND (A
CL_2.RightName = 'OwnTicket' OR ACL_2.RightName = 'SuperUser') AND
((ACL_2.ObjectType = 'RT::Queue' AND ACL_2.ObjectId = 1) OR (ACL_2.ObjectType
= 'RT::S
ystem')) ORDER BY main.Name ASC
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Principals WHERE id = '6'
233 Query SELECT * FROM GroupMembers WHERE GroupId =
'4' AND MemberId = '6'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT main.* FROM Links main WHERE
(main.Base = 'fsck.com-rt://test.ca/ticket/3' OR main.Base = 'fsck.com-rt://vian
et.ca/ticket/3') AND (main.Type = 'RefersTo') ORDER BY main.Target ASC
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT main.* FROM Links main WHERE
(main.Type = 'RefersTo') AND (main.Target = 'fsck.com-rt://test.ca/ticket/3' OR
main.Target = 'fsck.com-rt://test.ca/ticket/3') ORDER BY main.Base ASC
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT main.* FROM Links main WHERE
(main.Base = 'fsck.com-rt://test.ca/ticket/3' OR main.Base = 'fsck.com-rt://vian
et.ca/ticket/3') AND (main.Type = 'DependsOn') ORDER BY main.Target ASC
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT main.* FROM Links main WHERE
(main.Type = 'DependsOn') AND (main.Target = 'fsck.com-rt://test.ca/ticket/3' OR
main.Target = 'fsck.com-rt://test.ca/ticket/3') ORDER BY main.Base ASC
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT main.* FROM Links main WHERE
(main.Base = 'fsck.com-rt://test.ca/ticket/3' OR main.Base = 'fsck.com-rt://vian
et.ca/ticket/3') AND (main.Type = 'MemberOf') ORDER BY main.Target ASC
233 Query SELECT main.* FROM Tickets main WHERE
(main.Status != 'deleted') AND ( ( main.EffectiveId = '3' ) ) AND (main.Type = '
ticket')
233 Query SELECT count(main.id) FROM Links main
WHERE (main.Type = 'MemberOf') AND (main.Target = 'fsck.com-rt://test.ca/ticke
t/3' OR main.Target = 'fsck.com-rt://test.ca/ticket/3')
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT DISTINCT main.id AS id, main.Content
AS content, main.ContentType AS contenttype, main.TransactionId AS transact
ionid, main.ContentEncoding AS contentencoding FROM Attachments main JOIN
Transactions Transactions_1 ON ( Transactions_1.id = main.TransactionId ) JOIN
T
ickets Tickets_2 ON ( Tickets_2.id = Transactions_1.ObjectId ) WHERE
(Tickets_2.EffectiveId = '3') AND (Transactions_1.ObjectType = 'RT::Ticket')
AND (ma
in.ContentType = 'text/plain' OR main.ContentType LIKE 'message/%' OR
main.ContentType = 'text') ORDER BY main.id ASC
233 Query SELECT DISTINCT main.* FROM Transactions
main JOIN Tickets Tickets_1 ON ( Tickets_1.id = main.ObjectId ) WHERE (main.
ObjectType = 'RT::Ticket') AND (Tickets_1.EffectiveId = '3') ORDER BY
main.Created ASC, main.id ASC
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT ACL.id, ACL.ObjectType, ACL.ObjectId
FROM ACL, Principals, CachedGroupMembers WHERE (ACL.RightName = 'SuperUser'
OR ACL.RightName = 'ForwardMessage') AND Principals.id = ACL.PrincipalId AND
Principals.PrincipalType = 'Group' AND Principals.Disabled = 0 AND CachedGrou
pMembers.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 A
CL.ObjectId = 3)) LIMIT 1
233 Query SELECT main.* FROM CustomFields main JOIN
ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomFiel
d = main.id ) WHERE (main.Disabled = '0') AND (main.Name = NULL) AND
(ObjectCustomFields_1.ObjectId = '1' OR ObjectCustomFields_1.ObjectId = '0')
AND (mai
n.LookupType = 'RT::Queue-RT::Ticket-RT::Transaction') GROUP BY main.id ORDER
BY MAX(ObjectCustomFields_1.ObjectId) DESC, MIN(ObjectCustomFields_1.SortOr
der) ASC
233 Query SELECT count(main.id) FROM
ObjectCustomFieldValues main WHERE (main.Disabled = '0') AND (main.ObjectType
= 'RT::Transa
ction') AND (main.ObjectId = '38')
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Attributes WHERE Name =
'Pref-RT::System-1' AND ObjectType = 'RT::User' AND ObjectId = '12'
233 Query SELECT * FROM Users WHERE id = '1'
233 Query SELECT main.* FROM CustomFields main JOIN
ObjectCustomFields ObjectCustomFields_1 ON ( ObjectCustomFields_1.CustomFiel
d = main.id ) WHERE (main.Disabled = '0') AND (main.Name = NULL) AND
(ObjectCustomFields_1.ObjectId = '1' OR ObjectCustomFields_1.ObjectId = '0')
AND (mai
n.LookupType = 'RT::Queue-RT::Ticket-RT::Transaction') GROUP BY main.id ORDER
BY MAX(ObjectCustomFields_1.ObjectId) DESC, MIN(ObjectCustomFields_1.SortOr
der) ASC
233 Query SELECT count(main.id) FROM
ObjectCustomFieldValues main WHERE (main.Disabled = '0') AND (main.ObjectType
= 'RT::Transa
ction') AND (main.ObjectId = '39')
233 Query UPDATE sessions SET a_session =
'\0\0\0\n\0\0\0\0\0\0\n1\0\0\0IdGeneral\0\0\0NameThe default
queue\0\0\0Description\0\0
\0#SelectQueue---12---CreateTicket---1RT::CurrentUser\0\0\0\nRT::CurrentUser\0\0\0_Class\nid=12\0\0\0\"_SB_Record_Primary_RecordCache_key^LRT::I18N::en\0\0
\0\0\0\0\0\nLangHandle\nUsers\0\0\0table\0\0\0\"\n1\0\0\0creator\n
SuperUser\0\0\comments\0\0\0state\0\0\0webencoding\nEnoch
Root\0\0\realname\0\0\0\nauthsystem\n12\0\0\0id\0\0\0
homephone\0\0\0lang\0\0\timezone\nroot\0\0\0name\0\0\0contactinfosystem\0\0
\0\remailencoding\0\0\0zip\0\0\0 signature\n2008-07-17
15:27:04\0\0\0lastupdated\0\0\0externalauthid\0\0\address1\0\0\0 [EMAIL
PROTECTED]
\0\0^Lemailaddress\0\0\0freeformcontactinfo\0\0\0city\nroot\0\0\0gecos\0\0\0^Lorganization\0\0\0country\0\0\0mobilephone\0\0\nickname\0\0\0externalcontacti
nfoid\0\0\address2\n2008-07-16
21:01:28\0\0\0created\0\0\0pgpkey\n12\0\0\0\rlastupdatedby\0\0\0\npagerphone\0\0\0values\0\0\0\\0\0\0creato\0\0\comment\0
\0\0stat\0\0\0webencodin\0\0\passwor\0\0\realnam\0\0\0\nauthsyste\0\0\0i\0\0\0
homephon\0\0\0lan\0\0\timezon\0\0\0nam\0\0\0contactinfosyste\0
\0\0\remailencodin\0\0\0zi\0\0\0lastupdate\0\0\0
signatur\0\0\0externalauthi\0\0\address\0\0\0
workphon\0\0\0^Lemailaddres\0\0\0freeform
contactinf\0\0\0cit\0\0\0geco\0\0\0^Lorganizatio\0\0\0countr\0\0\0mobilephon\0\0\nicknam\0\0\0externalcontactinfoi\0\0\address\0\0\0create\0\0\0p
gpke\0\0\0\npagerphon\0\0\0\rlastupdatedby\0\0\0fetched\0\0\0CurrentUser\0\0\0\0\0\0\n1\0\0\0IdGeneral\0\0\0NameThe
default queue\0\0\0Description\0\0\0#
SelectQueue---12---CreateTicket---0\0\0\0\0\0\0\n1\0\0\0IdThe default
queue\0\0\0DescriptionGeneral\0\0\0Name\0\0\0!SelectQueue---12---ShowTicket---1RT::Ti
ckets\0\0\0%\0\0\0\0\0\0\0^L_open_parens\nTickets\0\0\0table\0\0\0_sql_trattachalias\n\0\0\0\0tables\0\0\0_sql_object_cfv_alia\0\0\0\nis_limited\n\0\0\0\0
order\0\0\0_sql_watcher_join_users_alias\0\0\0\0 \0\0\0user( Subject
LIKE \'e\' )\0\0\0\n_sql_query\0\0\0\0\0\0\0\0\0\n \'deleted\'\0\0\0value\nmai
n.Status\0\0\0field\n!=\0\0\0op\0\0\0main.Status\0\0\0\n(\0\0\0\'%e%\'\0\0\0value\n^Lmain.Subject\0\0\0fieldLIKE\0\0\0op\n)\0\0\0
ticketsql\0\0\0\0\0
\0\nmain.id\0\0\0value\nmain.EffectiveId\0\0\0field\n=\0\0\0op\0\0\0main.EffectiveId\0\0\0\0\0\0\\'ticket\'\0\0\0value\n
main.Type\0\0\0field\n=\0\0
\0op\0\0\0 main.Type\0\0\0^Lrestrictions\nid\0\0\0primary_key\n3\0\0\0
count_all\0\0\0\0\0\0\0items_arra\0\0\0must_redo_searc\0\0\0looking_at_ef
fective_id\0\0\0z(main.Status != \'deleted\') AND ( ( main.Subject LIKE \'%e%\'
) ) AND (main.EffectiveId = main.id) AND (main.Type = \'ticket\')\0\0\0gene
ric_restrictions\0\0\0\nsubclauses\0\0\\0\0\0subject\0\0\0_sql_looking_a\0\0\0alias_count\0\0\\0\0\0\0\0\0\0\0\02\0\0\0dbix_sb_unique_cache\n\0\0\0\0^L--Mowhere_clause\0\0\0\0\0\0id\0\0\0FIELDASC\0\0\0ORDER\0\0\order_b\0\0\0RecalcTicketLimit\0\0\0restriction_index\0\0\0_sql_transalias\0\0\0\0\0\0\02\0\0\0ne
x\0\0\0pre\0\0\0defined\0\0\011\0\0\0\0first\0\0\02\0\0\0pre\0\0\0defined\0\0\0\033\0\0\0\0last\0\0\03\0\0\0next1\0\0\0pre\0\0\0defined\0\0\02\0\0\item
_map\nRT::Handle\0\0\0\n5.0.32-Debian_7etch6-log\0\0\0database_version\n#dbi:mysql:dbname=rt3;host=localhost\0\0\0dsn\n\r5.0.32-Debian\0\0\0database_versio
n_short\0\0\0\0\0\0\0^LStatementLog\0\0\0DisconnectHandleOnDestroy\0\0\0\nDBIxHandle\n\0\0\0\0^Llimit_clause\n\0\0\0\0auxillary_table\0\0\0\nitemscoun\0\
0\0
show_rows\0\0\0\r_sql_cf_alias\0\0\0\0\0\0\0\nleft_joins\0\0\0\0\0\0\0aliase\0\0\0
first_row\0\0\0\nRT::Ticket\0\0\0\n\nRT::Ticket\0\0\0_Class
\0\0\0\roriginal_user\nid=1\0\0\0\"_SB_Record_Primary_RecordCache_key\0\0\0\0
\0\0\0user\nTickets\0\0\0table\0\0\0\n0\0\0\priority\n0\0\0\disabled\n12\0\
0\0creator\nnew\0\0\0status\n0\0\0\0issuestatement\n0\0\0\0\ntimeworked\n0\0\0\timeleft\n1\0\0\0id\n12\0\0\0owner\n1970-01-01
00:00:00\0\0\0due\n1\0\0\0eff
ectiveid\0\0\0told\nTest #1\0\0\0subject\n1970-01-01
00:00:00\0\0\resolved\n2008-07-17 15:28:43\0\0\0created\n1970-01-01
00:00:00\0\0\0starts\n2008-07-17 1
5:28:43\0\0\0lastupdated\n0\0\0\0\rfinalpriority\n0\0\0\0\nresolution\n1970-01-01
00:00:00\0\0\0started\nticket\0\0\0type\n1\0\0\0queue\n12\0\0\0\rlastupda
tedby\n0\0\0\0initialpriority\n0\0\0\0\rtimeestimated\0\0\0values\0\0\\0\0\priorit\0\0\disable\0\0\0creato\0\0\0statu\0\0\0issuestatemen\0\0\0\ntimew
orke\0\0\timelef\0\0\0i\0\0\0owne\0\0\0du\0\0\0effectivei\0\0\0tol\0\0\0subjec\0\0\resolve\0\0\0create\0\0\0start\0\0\0\rfinalpriorit\0\0\0last
update\0\0\0\nresolutio\0\0\0queu\0\0\0typ\0\0\0starte\0\0\0\rlastupdatedb\0\0\0\rtimeestimate\0\0\0initialpriority\0\0\0fetched\0\0\0\n\nRT::Ticket
\0\0\0_Class\0\0\0\roriginal_user\nid=2\0\0\0\"_SB_Record_Primary_RecordCache_key\0\0\0\0
\0\0\0user\nTickets\0\0\0table\0\0\0\n0\0\0\priority\n0\0\0
\disabled\n12\0\0\0creator\nnew\0\0\0status\n0\0\0\0issuestatement\n0\0\0\0\ntimeworked\n0\0\0\timeleft\n2\0\0\0id\n12\0\0\0owner\n1970-01-01
00:00:00\0\0\
0due\n2\0\0\0effectiveid\0\0\0told\nTest #2\0\0\0subject\n1970-01-01
00:00:00\0\0\resolved\n2008-07-17 15:28:58\0\0\0created\n1970-01-01
00:00:00\0\0\0star
ts\n2008-07-17
15:28:58\0\0\0lastupdated\n0\0\0\0\rfinalpriority\n0\0\0\0\nresolution\n1970-01-01
00:00:00\0\0\0started\nticket\0\0\0type\n1\0\0\0queue\n12
\0\0\0\rlastupdatedby\n0\0\0\0initialpriority\n0\0\0\0\rtimeestimated\0\0\0values\0\0\\0\0\priorit\0\0\disable\0\0\0creato\0\0\0statu\0\0\0issuestatem
en\0\0\0\ntimeworke\0\0\timelef\0\0\0i\0\0\0owne\0\0\0du\0\0\0effectivei\0\0\0tol\0\0\0subjec\0\0\resolve\0\0\0create\0\0\0start\0\0\0\rfinalpr
iorit\0\0\0lastupdate\0\0\0\nresolutio\0\0\0queu\0\0\0typ\0\0\0starte\0\0\0\rlastupdatedb\0\0\0\rtimeestimate\0\0\0initialpriority\0\0\0fetched\0\0
\0\n\nRT::Ticket\0\0\0_Class\0\0\0\roriginal_user\nid=3\0\0\0\"_SB_Record_Primary_RecordCache_key\0\0\0\0
\0\0\0user\nTickets\0\0\0table\0\0\0\n0\0\0
\priority\n0\0\0\disabled\n12\0\0\0creator\nnew\0\0\0status\n0\0\0\0issuestatement\n0\0\0\0\ntimeworked\n0\0\0\timeleft\n3\0\0\0id\n12\0\0\0owner\n1970-01-
01 00:00:00\0\0\0due\n3\0\0\0effectiveid\0\0\0told\nTest
#3\0\0\0subject\n1970-01-01 00:00:00\0\0\resolved\n2008-07-17
15:33:24\0\0\0created\n1970-01-01 00
:00:00\0\0\0starts\n2008-07-17
15:33:24\0\0\0lastupdated\n0\0\0\0\rfinalpriority\n0\0\0\0\nresolution\n1970-01-01
00:00:00\0\0\0started\nticket\0\0\0type\n
1\0\0\0queue\n12\0\0\0\rlastupdatedby\n0\0\0\0initialpriority\n0\0\0\0\rtimeestimated\0\0\0values\0\0\\0\0\priorit\0\0\disable\0\0\0creato\0\0\0statu\
0\0\0issuestatemen\0\0\0\ntimeworke\0\0\timelef\0\0\0i\0\0\0owne\0\0\0du\0\0\0effectivei\0\0\0tol\0\0\0subjec\0\0\resolve\0\0\0create\0\0\0start
\0\0\0\rfinalpriorit\0\0\0lastupdate\0\0\0\nresolutio\0\0\0queu\0\0\0typ\0\0\0starte\0\0\0\rlastupdatedb\0\0\0\rtimeestimate\0\0\0initialpriority\
0\0\0fetched\0\0\0item\0\0\0looking_at_type\0\0\0tickets\0\0\0\0\0\0\n1\0\0\0idThe
default queue\0\0\0DescriptionGeneral\0\0\0Name\0\0\0quick_search_queue
s\n c1a988c47cd483e43670f2854bc0ceae\0\0\0_session_id\0\0\0\0\0\0\0\0\0\n\nMy
Tickets\0\0\0name\nsystem\0\0\0type\0\0\0\nUnowned Tickets\0\0\0name\nsystem\
0\0\0type\0\0\0\nBookmarked
Tickets\0\0\0name\nsystem\0\0\0type\0\0\0\nQuickCreate\0\0\0name\n
component\0\0\0type\0\0\0body\0\0\0\0\0\0\nMyReminders\0\0\
0name\n component\0\0\0type\0\0\0\nQuicksearch\0\0\0name\n
component\0\0\0type\0\0\0\n\nDashboards\0\0\0name\n
component\0\0\0type\0\0\0\nRefreshH
omepage\0\0\0name\n
component\0\0\0type\0\0\0summary\0\0\0my_rt_portlets\0\0\0ASC|ASC|ASC|ASC\0\0\0Order(
Subject LIKE \'e\' )\0\0\0Queryid|||\0\0\0Ord
erBy\0\0�\' <b><a
href=\"__WebPath__/Ticket/Display.html?id=__id__\">__id__</a></b>/TITLE:#\',\n\'<b><a
href=\"__WebPath__/Ticket/Display.html?id=__id__\
">__Subject__</a></b>/TITLE:Subject\',\n\'__Status__\',\n\'__QueueName__\',\n\'__OwnerName__\',\n\'__Priority__\',\n\'__NEWLINE__\',\n\'\',\n\'<small>__Req
uestors__</small>\',\n\'<small>__CreatedRelative__</small>\',\n\'<small>__ToldRelative__</small>\',\n\'<small>__LastUpdatedRelative__</small>\',\n\'<small>
__TimeLeft__</small>\'\0\0\0Forma\0\0\0Page10\0\0\0RowsPerPage\0\0\0CurrentSearchHas\0\0\0i'
WHERE id = 'c1a988c47cd483e43670f2854bc0ceae'
233 Query SELECT
RELEASE_LOCK('Apache-Session-c1a988c47cd483e43670f2854bc0ceae')Perl v5.8.8 under linux
Apache2::Const v2.000002;
Apache2::Log v2.000002;
Apache2::RequestIO v2.000002;
Apache2::RequestRec v2.000002;
Apache2::RequestUtil v2.000002;
Apache2::Response v2.000002;
Apache2::ServerUtil v2.000002;
Apache2::Status v4.00;
Apache::Session v1.86;
Apache::Session::Generate::MD5 v2.1;
Apache::Session::Lock::MySQL v1.01;
Apache::Session::MySQL v1.01;
Apache::Session::Serialize::Storable v1.01;
Apache::Session::Store::DBI v1.02;
Apache::Session::Store::MySQL v1.04;
APR v0.009000;
APR::Pool v0.009000;
APR::Table v0.009000;
AutoLoader v5.60;
base v2.07;
bytes v1.02;
Cache::Simple::TimedExpiry v0.26;
capitalization v0.03;
Carp v1.04;
CGI v3.38;
CGI::Cookie v1.29;
CGI::Util v1.5_01;
Class::Container v0.12;
Class::Data::Inheritable v0.04;
Class::Inspector v1.16;
Class::ReturnValue v0.53;
Clone v0.18;
constant v1.05;
CSS::Squish v0.07;
Cwd v3.12;
Data::Dumper v2.121_08;
Date::Format v2.22;
Date::Parse v2.27;
DBD::mysql v4.007;
DBI v1.605;
DBIx::SearchBuilder v1.54;
DBIx::SearchBuilder::Union v0;
DBIx::SearchBuilder::Unique v0.01;
Devel::StackTrace v1.1902;
Devel::StackTraceFrame v1.1902;
Devel::Symdump v2.03;
Digest::base v1.00;
Digest::MD5 v2.36;
DynaLoader v1.04;
Email::Address v1.870;
Encode v2.26;
Encode::Alias v2.10;
Encode::Config v2.05;
Encode::Encoding v2.05;
Errno v1.0901;
Exception::Class v1.21;
Exception::Class::Base v1.2;
Exporter v5.58;
Exporter::Heavy v5.58;
Fcntl v1.05;
File::Basename v2.74;
File::Glob v1.05;
File::Path v1.08;
File::ShareDir v0.05;
File::Spec v3.12;
File::Spec::Functions v1.3;
File::Spec::Unix v1.5;
File::Temp v0.20;
FileHandle v2.01;
GD v2.34;
GD::Image v2.27;
GraphViz v2.02;
HTML::Element v3.16;
HTML::Entities v1.35;
HTML::Formatter v2.04;
HTML::FormatText v2.04;
HTML::Mason v1.39;
HTML::Mason::ApacheHandler v1.69;
HTML::Mason::Exception v1.1;
HTML::Mason::Exception::Abort v1.1;
HTML::Mason::Exception::Compilation v1.1;
HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
HTML::Mason::Exception::Compiler v1.1;
HTML::Mason::Exception::Decline v1.1;
HTML::Mason::Exception::Params v1.1;
HTML::Mason::Exception::Syntax v1.1;
HTML::Mason::Exception::System v1.1;
HTML::Mason::Exception::TopLevelNotFound v1.1;
HTML::Mason::Exception::VirtualMethod v1.1;
HTML::Mason::Exceptions v1.43;
HTML::Parser v3.55;
HTML::Scrubber v0.08;
HTML::Tagset v3.10;
HTML::TreeBuilder v3.13;
I18N::LangTags v0.35;
integer v1.00;
IO v1.22;
IO::File v1.13;
IO::Handle v1.25;
IO::InnerFile v2.110;
IO::Lines v2.110;
IO::ScalarArray v2.110;
IO::Seekable v1.1;
IO::WrapTie v2.110;
IPC::Open2 v1.02;
IPC::Open3 v1.02;
IPC::Run v0.80;
List::Util v1.18;
Locale::Maketext v1.09;
Locale::Maketext::Fuzzy v0.02;
Locale::Maketext::Lexicon v0.62;
Locale::Maketext::Lexicon::Gettext v0.15;
Log::Dispatch v2.11;
Log::Dispatch::Base v1.09;
Log::Dispatch::Output v1.26;
Log::Dispatch::Screen v1.17;
Log::Dispatch::Syslog v1.18;
Mail::Address v1.74;
Mail::Field v1.74;
Mail::Field::AddrList v1.74;
Mail::Field::Date v1.74;
Mail::Header v1.74;
Mail::Internet v1.74;
MIME::Base64 v3.07;
MIME::Body v5.427;
MIME::Decoder v5.427;
MIME::Entity v5.427;
MIME::Field::ContDisp v5.427;
MIME::Field::ConTraEnc v5.427;
MIME::Field::ContType v5.427;
MIME::Field::ParamVal v5.427;
MIME::Head v5.427;
MIME::Parser v5.427;
MIME::QuotedPrint v3.07;
MIME::Tools v5.427;
MIME::Words v5.427;
mod_perl v2.000002;
mod_perl2 v2.000002;
ModPerl::Const v2.000002;
Module::Versions::Report v1.05;
overload v1.04;
Params::Util v0.14;
Params::Validate v0.77;
PerlIO v1.04;
PerlIO::scalar v0.04;
POSIX v1.09;
re v0.05;
Regexp::Common v2.120;
Regexp::Common::delimited v2.104;
RT v3.8.0;
RT::Interface::Email v2;
RT::Interface::Web::Request v0.30;
Scalar::Util v1.18;
SelectSaver v1.01;
Socket v1.78;
Storable v2.15;
strict v1.03;
Symbol v1.06;
Sys::Syslog v0.13;
Text::Template v1.44;
Text::Wrapper v1.000;
Time::HiRes v1.86;
Time::JulianDay v2003.1125;
Time::Local v1.11;
Time::ParseDate v2003.1126;
Time::Timezone v2003.0211;
Time::Zone v2.22;
UNIVERSAL v1.01;
UNIVERSAL::require v0.10;
URI v1.35;
URI::Escape v3.28;
URI::file v4.19;
utf8 v1.06;
vars v1.01;
warnings v1.05;
warnings::register v1.01;
XSLoader v0.06;
_______________________________________________
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
