[rt-users] 3.8.1 corrupting attachments
Aaron Hathaway
aaron.hathaway at prager.com
Fri Aug 22 11:11:15 EDT 2008
Ruslan,
Here's the output:
| Table | Create Table
| 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) default NULL,
`Subject` varchar(255) default NULL,
`Filename` varchar(255) default NULL,
`ContentType` varchar(80) default NULL,
`ContentEncoding` varchar(80) default NULL,
`Content` longtext,
`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 DEFAULT CHARSET=latin1 |
I do see differences between the above and output from a fresh install
of 3.8.1. What's the best way to rectify this?
Regards,
Aaron
Ruslan Zakirov wrote:
>
> 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> 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]
> > Sent: Thursday, August 21, 2008 3:32 PM
> > To: Aaron Hathaway; jmoseley at corp.xanadoo.com
> > Cc: rt-users at lists.bestpractical.com
> > 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?
> >
> >
> > ----- Original Message -----
> > From: rt-users-bounces at lists.bestpractical.com
> > <rt-users-bounces at lists.bestpractical.com>
> > To: jmoseley at corp.xanadoo.com <jmoseley at corp.xanadoo.com>
> > Cc: rt-users at lists.bestpractical.com <rt-users at lists.bestpractical.com>
> > Sent: Thu Aug 21 17:27:16 2008
> > Subject: Re: [rt-users] 3.8.1 corrupting attachments
> >
> > James,
> >
> > Thanks for that tip--I missed that initially. However, even after
> running
> > that script against my DB, I'm still seeing the same attachment
> corruption.
> >
> > Regards,
> > Aaron Hathaway
> >
> > -----Original Message-----
> > From: jmoseley at corp.xanadoo.com [mailto:jmoseley at corp.xanadoo.com]
> > Sent: Thursday, August 21, 2008 3:19 PM
> > To: Helmuth Ramirez
> > Cc: Aaron Hathaway; rt-users at lists.bestpractical.com;
> > rt-users-bounces at lists.bestpractical.com
> > Subject: Re: [rt-users] 3.8.1 corrupting attachments
> >
> > Perhaps the script itself is poorly named, but the instructions
> state that
> > the 4.0 mysql upgrade script must be run if you are upgrading as it
> changes
> > the DB schema.
> >
> > It's not a script only for those running 4.x.x versions of mysql,
> it's for
> > everyone that's upgrading.
> >
> >
> > James Moseley
> >
> >
> >
> >
> >
> > "Helmuth Ramirez"
> > <HelmuthRamirez at c
> >
> ompupay.com> To
> > Sent by: "Aaron Hathaway"
> > rt-users-bounces@ <aaron.hathaway at prager.com>
> >
> lists.bestpractic cc
> > al.com rt-users at lists.bestpractical.com
> >
> Subject
> > Re: [rt-users] 3.8.1 corrupting
> > 08/21/2008 05:09 attachments
> > PM
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Oh, then I don't have a good answer for you. Sorry L Maybe the
> list can
> > provide some insight.
> >
> > From: Aaron Hathaway [mailto:aaron.hathaway at prager.com]
> > Sent: Thursday, August 21, 2008 6:01 PM
> > To: Helmuth Ramirez
> > Subject: RE: [rt-users] 3.8.1 corrupting attachments
> >
> > I'm running MySQL 5.0.18, with the default latin1 character set---as
> I was
> > with 3.6.x.
> >
> > --Aaron
> >
> > From: Helmuth Ramirez [mailto:HelmuthRamirez at compupay.com]
> > Sent: Thursday, August 21, 2008 2:51 PM
> > To: Aaron Hathaway; rt-users at lists.bestpractical.com
> > Subject: RE: [rt-users] 3.8.1 corrupting attachments
> >
> > Aaron,
> > This happened to me when I didn't do the 4.0 to 4.1 MySQL update.
> >
> > From: rt-users-bounces at lists.bestpractical.com
> > [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of
> Aaron
> > Hathaway
> > Sent: Thursday, August 21, 2008 5:35 PM
> > To: rt-users at lists.bestpractical.com
> > Subject: [rt-users] 3.8.1 corrupting attachments
> >
> > Is anyone else seeing problems with corrupted attachments in
> 3.8.x?
> > From what I can tell, 8-bit characters are getting stripped or
> > altered in mime attachments, corrupting the data.
> >
> > Attached are two PDFs, the original PDF (original.pdf) and the
> > post-RT PDF (post-rt.pdf). The latter appears to be blank
> after RT
> > receives it. I'm also seeing corruption of MS Office
> documents, so
> > this may extend to all binary attachments.
> >
> > I'm happy to submit a bug report if others are experiencing
> this as
> > well.
> >
> > Cheers,
> >
> > Aaron Hathaway_______________________________________________
> > 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
> >
> > _______________________________________________
> > 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
> >
>
>
>
> --
> Best regards, Ruslan.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080822/ef601fbd/attachment.htm>
More information about the rt-users
mailing list