[rt-users] RT Attachment problem

[Hossein Rafighi]

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