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 <[EMAIL PROTECTED]> 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?*>**> > >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
