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

Reply via email to