[rt-users] 3.8.1 corrupting attachments

Steve Hopps steve.hopps at gmail.com
Wed Sep 10 11:35:09 EDT 2008


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/20080910/7fbc2fa3/attachment.htm>


More information about the rt-users mailing list