Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and sessions table dropped and re-created from Schema in rt3.sql dump we
are seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.
When browsing tickets from the HOME base list this does not happen.
Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] "GET
/Search/Results.html?Format='%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23'%2C%0A'%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject'%2C%0A'__Status__'%2C%0A'__QueueName__'%2C%0A'__OwnerName__'%2C%0A'__Priority__'%2C%0A'__NEWLINE__'%2C%0A''%2C%0A'%3Csmall%3E__Requestors__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E'%2C%0A'%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E'&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20'new'%20OR%20Status%20%3D%20'open'&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1" 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] "GET
/Ticket/Display.html?id=16718 HTTP/1.1" 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] "POST /Ticket/Display.html
HTTP/1.1" 200 32802
----------------------
I have cleared old cookies and caches etc ....
Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.
--
Oliver Nash
CSSG Computer Science UCC
-------------------------
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
