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
Any help much appriciated.
Here is my SHOW CREATE TABLE Attachments; output.
| Attachments | CREATE TABLE
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,
Creator int(11) NOT NULL DEFAULT ‘0’,
Created datetime DEFAULT NULL,
PRIMARY KEY (
) ENGINE=InnoDB AUTO_INCREMENT=31223 DEFAULT CHARSET=latin1 |