[rt-users] Issues on RT 3.8.1

[Shannon Adams]

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.
>