[rt-users] RT Attachment problem

[Aaron Guise]

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.

*Regards,*

*Aaron Guise
[image: Phone]  07 854 7824
[image: Mobile]027 212 6638
[image: Email]aaron at guise.net.nz*



 On Fri, Apr 24, 2009 at 10:27 AM, Hossein Rafighi <
Hossein.Rafighi at triumf.ca> 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: 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...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090519/26dd6634/attachment.htm>