You missed a step. Per Ruslan yesterday: `a_session` column is longtext what is WRONG and means that you HAVN'T upgraded correctly.
Read UPGRADING.mysql, this column must be LONGBLOB. Shannon Adams wrote: > RT 3.8.1 > mysql version - 4.1.20-log > Fedora Core 4 > > SHOW CREATE TABLE sessions; shows: > +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | Table | Create Table > > > | > +----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | sessions | CREATE TABLE `sessions` ( > `id` varchar(32) NOT NULL default '', > `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) > > SHOW CREATE TABLE Attachments; shows: > > +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | Table | Create Table > > > > > > > > | > +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > | Attachments | CREATE TABLE `Attachments` ( > `id` int(11) NOT NULL auto_increment, > `TransactionId` int(11) NOT NULL default '0', > `Parent` int(11) NOT NULL default '0', > `MessageId` varchar(160) default NULL, > `Subject` varchar(255) default NULL, > `Filename` varchar(255) default NULL, > `ContentType` varchar(80) default NULL, > `ContentEncoding` varchar(80) default NULL, > `Content` longtext, > `Headers` longtext, > `Creator` int(11) NOT NULL default '0', > `Created` datetime default NULL, > PRIMARY KEY (`id`), > KEY `Attachments2` (`TransactionId`), > KEY `Attachments3` (`Parent`,`TransactionId`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | > +-------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ > 1 row in set (0.19 sec) > > Thanks, > Shannon > > > >> once again, send us results of "SHOW CREATE TABLE sessions;" >> and "SHOW CREATE TABLE Attachments;" >> On Wed, Aug 27, 2008 at 6:23 AM, Ruslan Zakirov <ruz at bestpractical.com> >> wrote: >> send us results of "SHOW CREATE TABLE sessions;" >> >> On Wed, Aug 27, 2008 at 4:05 AM, Carlos A. Alvarez <calvarez at commx.net> >> wrote: >> >>> I am also having the same "Logout/Login" issues as described above. The >>> are no errors reported on the debug.log or the access/error logs. This >>> only happened after I upgraded from 3.8.0 to 3.8.1. It seems as one >>> changes links from Home to Simple Search or Tools, the application will >>> log you out at random. I have tried all the fixes suggested here with >>> no avail. This is happening with Firefox, IE and Safari. Any ideas? >>> _______________________________________________ >>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users >>> >>> Community help: http://wiki.bestpractical.com >>> Commercial support: sales at bestpractical.com >>> >>> >>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >>> Buy a copy at http://rtbook.bestpractical.com >>> >>> >> >> -- >> Best regards, Ruslan. >> >> > > > > _______________________________________________ > 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 > -- Drew Barnes Applications Analyst Network Resources Department Raymond Walters College University of Cincinnati _______________________________________________ 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
