[rt-users] 3.8.1 corrupting attachments

[Aaron Hathaway]

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