<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<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>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>
</FONT>
</P>

</BODY>
</HTML>