[rt-users] RT Attachment problem
aaron at guise.net.nz
Mon May 18 16:42:09 EDT 2009
Sorry, I meant LONGBLOB rather than VARBINARY.
[image: Phone] 07 854 7824
[image: Mobile]027 212 6638
[image: Email]aaron at guise.net.nz*
On Tue, May 19, 2009 at 8:38 AM, Aaron Guise <aaron at guise.net.nz> wrote:
> 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 <
> Hossein.Rafighi at triumf.ca> wrote:
>> 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.
>> _____ _____ _____ _ _ _ _ ____ Hossein Rafighi
>> |_ _|| _ \ |_ _|| | | || \_/ || __|TRIUMF, 4004 Wesbrook Mall
>> | | | |_| ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
>> | | | _ / | | | \_/ || \_/ || __|Voice: (604) 222-1047
>> | | | | \ \ _| |_ | || | | || | Fax: (604) 222-1074
>> |_| |_| \_\|_____| \___/ |_| |_||_| Website: http://www.triumf.ca
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>> Buy a copy at http://rtbook.bestpractical.com
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the RT-Users