[rt-users] 3.8.1 corrupting attachments

[Steve Hopps]

Has anyone had any luck with these attachment problems? It's not a top
priority for me but it would certainly be nice if we can get it working.
-Steve

On Wed, Sep 10, 2008 at 10:35 AM, Steve Hopps <steve.hopps at gmail.com> wrote:

> 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
>
> Quoted Text Below:
>
> ------------------
>
> Shouldn't at this point, but there is a chance that later we'll have
> an upgrade for some 3.8.x version that wouldn't work correct if your
> DB is not changed using the script.
>
> Could you please send us output of "SHOW CREATE TABLE Attachments;" SQL command?
>
> On Fri, Aug 22, 2008 at 3:38 AM, Aaron Hathaway
> <aaron.hathaway at prager.com <http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>> wrote:
> >* Helmuth,*>**>**>**>* I ran the script after updating from 3.8.0 to 3.8.1.  Would that make a*>* difference?*>**>**>**>* Thanks,*>**>* Aaron*>**>**>**>* From: Helmuth Ramirez [mailto:HelmuthRamirez at compupay.com <http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>]*>* Sent: Thursday, August 21, 2008 3:32 PM*>* To: Aaron Hathaway; jmoseley at corp.xanadoo.com <http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>*>* Cc: rt-users at lists.bestpractical.com <http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users>*>* Subject: Re: [rt-users] 3.8.1 corrupting attachments*>**>**>**>* Did you upgrade the db to 3.8.0, run the script, then update to 3.8.1?*>**>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080926/e2cca043/attachment.htm>