[rt-users] 3.8.1 corrupting attachments

[Ruslan Zakirov]

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.