Hi, We upgraded our RT system from 3.6.2 to 3.8.1 without any error. We did apply steps in UPGRADING.mysql as per instructions. The problem we are having is that any attachment with old tickets are treated as URL. Upon clicking on them a web page with url to that attachment is displayed with body of the page containing the url address instead of the actual image! Any new ticket created after the upgrade now displays attachments inside the body of the ticket as: "Subject: speed.jpg"! I am aware of similar problem on the web like http://www.gossamer-threads.com/lists/rt/users/79354 but running schema.mysql-4.0-4.1.pl (for the second time) didn't help.
My SHOW CREATE TABLE Attachments: | Attachments | CREATE TABLE `Attachments` ( `id` int(11) NOT NULL auto_increment, `TransactionId` int(11) NOT NULL, `Parent` int(11) NOT NULL default '0', `MessageId` varchar(160) character set ascii default NULL, `Subject` varchar(255) default NULL, `Filename` varchar(255) default NULL, `ContentType` varchar(80) character set ascii default NULL, `ContentEncoding` varchar(80) character set ascii default NULL, `Content` longblob, `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 AUTO_INCREMENT=21034 DEFAULT CHARSET=utf8 | Any help is appreciated. Cheers, Hossein -- _____ _____ _____ _ _ _ _ ____ Hossein Rafighi |_ _|| _ \ |_ _|| | | || \_/ || __|TRIUMF, 4004 Wesbrook Mall | | | |_| ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3 | | | _ / | | | \_/ || \_/ || __|Voice: (604) 222-1047 | | | | \ \ _| |_ | || | | || | Fax: (604) 222-1074 |_| |_| \_\|_____| \___/ |_| |_||_| Website: http://www.triumf.ca _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com