Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE `sessions` (
`id` char(32) NOT NULL,
`a_session` longtext,
`LastUpdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
thanks
Oliver
On Sun, 8 Jan 2012, Ruslan Zakirov wrote:
Hi,
RT version? Show us how your new sessions table looks.
SHOW CREATE TABLE sessions;
On Fri, Jan 6, 2012 at 15:56, <o.n...@cs.ucc.ie> wrote:
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
--
Best regards, Ruslan.
--
Oliver Nash
CSSG Computer Science UCC
-------------------------
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
* Boston March 5 & 6, 2012
