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