[rt-users] Corrupted Attachments

[Steve Hopps]

I've followed the upgrade instructions but have the same problem with
attachments being corrupted in 3.8.1. Perhaps there is another issue that
has yet to be addressed? Nobody offered any suggestions to my previous post
on this subject so I assumed this was an unsolved issue still.
My earlier post follows:

I'm having a problem with corruption as well. I had missed this
upgrade because I am running mysql 5.x so presumed it didn't apply.
I've since run the script and everything seemed to work, but of course
this is after doing the 3.8.1 upgrades. My attachments still seem to
be corrupting, any suggestions? This is the output of 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=4221 DEFAULT CHARSET=utf8

On Sat, Oct 4, 2008 at 10:57 AM, Jesse Vincent <jesse at bestpractical.com>wrote:

>
> > > Yes. I've seen this dicussion numerous times in the past and know it
> > > to be an issue with following the upgrade path. Perhaps I didn't
> > > follow the previous conversation paths correctly.
> >
> > That would be plausible except:
> >
> > a. my RT 3.8.1 install is a brand spanking new install.
> >
> > b. my RT 3.4.2 install is untouched.
> >
> > c. the only thing 'upgraded' about my RT environment is the database
> > tables.
>
>
> Yes. This says pretty clearly that you didn't run the tool described in
> the 'UPGRADING' file in the RT 3.8.1 distribution.
>
>
> > Attachments are corrupted if mail is routed to the 3.8.1 install. They
> > are not when routed to the 3.4.2 install.
> >
> > Matt
> >
> > I followed the upgrade documents to the letter in my test environment
> > with a snapshot of the database. The ALTER tables process might work
> > well for folks with a smaller data set but with 18GB of data, it takes
> > four hours to run on a E5310 Xeon with dedicated disks. That is far
> > too long to have our systems out of production.
> >
> > Changing the character set of the database tables from latin to UTF
> > can be done far more quickly and with less risk by dumping the
> > database to disk, using sed to alter the dump file, and then
> > importing. That process is hours faster.
> > _______________________________________________
> > 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
> >
>
> --
> _______________________________________________
> 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/20081008/9474f3c3/attachment.htm>