Sorry, I meant LONGBLOB rather than VARBINARY. *Regards,*
*Aaron Guise [image: Phone] 07 854 7824 [image: Mobile]027 212 6638 [image: email][email protected]* On Tue, May 19, 2009 at 8:38 AM, Aaron Guise <[email protected]> wrote: > Hi, > > I too had a similar problem with them attachments. > I am just working on some perl scripts to correct this. It is just due to > the conversion of the longtext field to varbinary with from the schema > upgrade script. > > I have tested my theory and was able to get them working. I could supply > you these scripts and instructions if you are still having trouble and wish > to upgrade. > > > On Fri, Apr 24, 2009 at 10:27 AM, Hossein Rafighi < > [email protected]> wrote: > >> 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: [email protected] >> >> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. >> Buy a copy at http://rtbook.bestpractical.com >> > >
_______________________________________________ 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
