<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [rt-users] 3.8.1 corrupting attachments</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>The document says to not upgrade the db to 3.8.1 (stop at 3.8.0) before running the script. I think that may be a factor. If its in the document I'm sure there's a good reason. You can give that a shot.<BR>
<BR>
-----Original Message-----<BR>
From: Aaron Hathaway [<A HREF="mailto:aaron.hathaway@prager.com">mailto:aaron.hathaway@prager.com</A>]<BR>
Sent: Thu 8/21/2008 7:38 PM<BR>
To: Helmuth Ramirez; jmoseley@corp.xanadoo.com<BR>
Cc: rt-users@lists.bestpractical.com<BR>
Subject: RE: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
Helmuth,<BR>
<BR>
<BR>
<BR>
I ran the script after updating from 3.8.0 to 3.8.1. Would that make a difference? <BR>
<BR>
<BR>
<BR>
Thanks,<BR>
<BR>
Aaron<BR>
<BR>
<BR>
<BR>
From: Helmuth Ramirez [<A HREF="mailto:HelmuthRamirez@compupay.com">mailto:HelmuthRamirez@compupay.com</A>]<BR>
Sent: Thursday, August 21, 2008 3:32 PM<BR>
To: Aaron Hathaway; jmoseley@corp.xanadoo.com<BR>
Cc: rt-users@lists.bestpractical.com<BR>
Subject: Re: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
<BR>
<BR>
Did you upgrade the db to 3.8.0, run the script, then update to 3.8.1?<BR>
<BR>
<BR>
----- Original Message -----<BR>
From: rt-users-bounces@lists.bestpractical.com <rt-users-bounces@lists.bestpractical.com><BR>
To: jmoseley@corp.xanadoo.com <jmoseley@corp.xanadoo.com><BR>
Cc: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Sent: Thu Aug 21 17:27:16 2008<BR>
Subject: Re: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
James,<BR>
<BR>
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.<BR>
<BR>
Regards,<BR>
Aaron Hathaway<BR>
<BR>
-----Original Message-----<BR>
From: jmoseley@corp.xanadoo.com [<A HREF="mailto:jmoseley@corp.xanadoo.com">mailto:jmoseley@corp.xanadoo.com</A>]<BR>
Sent: Thursday, August 21, 2008 3:19 PM<BR>
To: Helmuth Ramirez<BR>
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com; rt-users-bounces@lists.bestpractical.com<BR>
Subject: Re: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
Perhaps the script itself is poorly named, but the instructions state that<BR>
the 4.0 mysql upgrade script must be run if you are upgrading as it changes<BR>
the DB schema.<BR>
<BR>
It's not a script only for those running 4.x.x versions of mysql, it's for<BR>
everyone that's upgrading.<BR>
<BR>
<BR>
James Moseley<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
"Helmuth Ramirez" <BR>
<HelmuthRamirez@c <BR>
ompupay.com> To<BR>
Sent by: "Aaron Hathaway" <BR>
rt-users-bounces@ <aaron.hathaway@prager.com> <BR>
lists.bestpractic cc<BR>
al.com rt-users@lists.bestpractical.com <BR>
Subject<BR>
Re: [rt-users] 3.8.1 corrupting <BR>
08/21/2008 05:09 attachments <BR>
PM <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
Oh, then I don't have a good answer for you. Sorry L Maybe the list can<BR>
provide some insight.<BR>
<BR>
From: Aaron Hathaway [<A HREF="mailto:aaron.hathaway@prager.com">mailto:aaron.hathaway@prager.com</A>]<BR>
Sent: Thursday, August 21, 2008 6:01 PM<BR>
To: Helmuth Ramirez<BR>
Subject: RE: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
I'm running MySQL 5.0.18, with the default latin1 character set-as I was<BR>
with 3.6.x.<BR>
<BR>
--Aaron<BR>
<BR>
From: Helmuth Ramirez [<A HREF="mailto:HelmuthRamirez@compupay.com">mailto:HelmuthRamirez@compupay.com</A>]<BR>
Sent: Thursday, August 21, 2008 2:51 PM<BR>
To: Aaron Hathaway; rt-users@lists.bestpractical.com<BR>
Subject: RE: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
Aaron,<BR>
This happened to me when I didn't do the 4.0 to 4.1 MySQL update.<BR>
<BR>
From: rt-users-bounces@lists.bestpractical.com<BR>
[<A HREF="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</A>] On Behalf Of Aaron<BR>
Hathaway<BR>
Sent: Thursday, August 21, 2008 5:35 PM<BR>
To: rt-users@lists.bestpractical.com<BR>
Subject: [rt-users] 3.8.1 corrupting attachments<BR>
<BR>
Is anyone else seeing problems with corrupted attachments in 3.8.x?<BR>
From what I can tell, 8-bit characters are getting stripped or<BR>
altered in mime attachments, corrupting the data.<BR>
<BR>
Attached are two PDFs, the original PDF (original.pdf) and the<BR>
post-RT PDF (post-rt.pdf). The latter appears to be blank after RT<BR>
receives it. I'm also seeing corruption of MS Office documents, so<BR>
this may extend to all binary attachments.<BR>
<BR>
I'm happy to submit a bug report if others are experiencing this as<BR>
well.<BR>
<BR>
Cheers,<BR>
<BR>
Aaron Hathaway_______________________________________________<BR>
<A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
<BR>
Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
_______________________________________________<BR>
<A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
<BR>
Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
Commercial support: sales@bestpractical.com<BR>
<BR>
<BR>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>