a_session column should be blob not text. On Mon, Jan 9, 2012 at 01:59, <[email protected]> wrote: > 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, <[email protected]> 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
-- Best regards, Ruslan. -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Boston March 5 & 6, 2012
