[rt-users] RT Attachment issue from 3.6.3 to 3.8.1

[Chamara Peris]

Hi All,

I've upgraded my RT system from 3.6.3 to 3.8.1 successfully (Both versions
are running with MYSQL 5). However I can't get the 3.8.1 to work with
attachments. All Word,Excel,Jpg and other documents display as garbage.

Then as a test I've installed a fresh RT 3.8.1 onto a another system. But
the result is the same with fresh install with fresh database. What am I
doing wrong?

Any help much appriciated.

Cheers,
CP

Here is my SHOW CREATE TABLE Attachments; output.

| 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 `Attachments1` (`Parent`),
  KEY `Attachments2` (`TransactionId`),
  KEY `Attachments3` (`Parent`,`TransactionId`)
) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 |
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081015/fa0d4d96/attachment.htm>