3.8.1 corrupting attachments

RT Users
1

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

original.pdf (1.81 KB)

post-rt.pdf (1.78 KB)

2

Aaron,

This happened to me when I didn’t do the 4.0 to 4.1 MySQL update.From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
Hathaway
Sent: Thursday, August 21, 2008 5:35 PM
To: rt-users@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

3

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@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@compupay.com]
Sent: Thursday, August 21, 2008 2:51 PM
To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
Hathaway
Sent: Thursday, August 21, 2008 5:35 PM
To: rt-users@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

4

I’m running MySQL 5.0.18, with the default latin1 character set-as I was
with 3.6.x.

–AaronFrom: Helmuth Ramirez [mailto:HelmuthRamirez@compupay.com]
Sent: Thursday, August 21, 2008 2:51 PM
To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
Hathaway
Sent: Thursday, August 21, 2008 5:35 PM
To: rt-users@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

5

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@c                                             
         ompupay.com>                                               To 
         Sent by:                  "Aaron Hathaway"                    
         rt-users-bounces@         <aaron.hathaway@prager.com>         
         lists.bestpractic                                          cc 
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@bestpractical.com


  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com
6

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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com; rt-users-bounces@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@c                                             
         ompupay.com>                                               To 
         Sent by:                  "Aaron Hathaway"                    
         rt-users-bounces@         <aaron.hathaway@prager.com>         
         lists.bestpractic                                          cc 
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@bestpractical.com


  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com
7

Did you upgrade the db to 3.8.0, run the script, then update to 3.8.1?----- Original Message -----
From: rt-users-bounces@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: jmoseley@corp.xanadoo.com jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com rt-users@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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com; rt-users-bounces@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@c                                             
         ompupay.com>                                               To 
         Sent by:                  "Aaron Hathaway"                    
         rt-users-bounces@         <aaron.hathaway@prager.com>         
         lists.bestpractic                                          cc 
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

8

Helmuth,

I ran the script after updating from 3.8.0 to 3.8.1. Would that make a difference?

Thanks,

AaronFrom: Helmuth Ramirez [mailto:HelmuthRamirez@compupay.com]
Sent: Thursday, August 21, 2008 3:32 PM
To: Aaron Hathaway; jmoseley@corp.xanadoo.com
Cc: rt-users@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?

9

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.-----Original Message-----
From: Aaron Hathaway [mailto:aaron.hathaway@prager.com]
Sent: Thu 8/21/2008 7:38 PM
To: Helmuth Ramirez; jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com
Subject: RE: [rt-users] 3.8.1 corrupting attachments

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@compupay.com]
Sent: Thursday, August 21, 2008 3:32 PM
To: Aaron Hathaway; jmoseley@corp.xanadoo.com
Cc: rt-users@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@lists.bestpractical.com rt-users-bounces@lists.bestpractical.com
To: jmoseley@corp.xanadoo.com jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com rt-users@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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com; rt-users-bounces@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@c                                            
         ompupay.com>                                               To
         Sent by:                  "Aaron Hathaway"                   
         rt-users-bounces@         <aaron.hathaway@prager.com>        
         lists.bestpractic                                          cc
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@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@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

10

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@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@compupay.com]
Sent: Thursday, August 21, 2008 3:32 PM
To: Aaron Hathaway; jmoseley@corp.xanadoo.com
Cc: rt-users@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@lists.bestpractical.com
rt-users-bounces@lists.bestpractical.com
To: jmoseley@corp.xanadoo.com jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com rt-users@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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com;
rt-users-bounces@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@c
         ompupay.com>                                               To
         Sent by:                  "Aaron Hathaway"
         rt-users-bounces@         <aaron.hathaway@prager.com>
         lists.bestpractic                                          cc
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@bestpractical.com


  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

11

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:

12

You have not applied correctly SQL queries generated by
etc/upgrade/schema.mysql-4.0-4.1.pl and described in UPGRADING.mysqlOn Fri, Aug 22, 2008 at 7:11 PM, Aaron Hathaway aaron.hathaway@prager.com wrote:

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@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@compupay.com]
Sent: Thursday, August 21, 2008 3:32 PM
To: Aaron Hathaway; jmoseley@corp.xanadoo.com
Cc: rt-users@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@lists.bestpractical.com
rt-users-bounces@lists.bestpractical.com
To: jmoseley@corp.xanadoo.com jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com rt-users@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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com;
rt-users-bounces@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@c
         ompupay.com>                                               To
         Sent by:                  "Aaron Hathaway"
         rt-users-bounces@         <aaron.hathaway@prager.com>
         lists.bestpractic                                          cc
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@bestpractical.com


  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

13

May be there were some errors or the script generated incorrect
queries, then we sure want to see queries the script generates.On Fri, Aug 22, 2008 at 7:18 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

You have not applied correctly SQL queries generated by
etc/upgrade/schema.mysql-4.0-4.1.pl and described in UPGRADING.mysql

On Fri, Aug 22, 2008 at 7:11 PM, Aaron Hathaway aaron.hathaway@prager.com wrote:

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@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@compupay.com]
Sent: Thursday, August 21, 2008 3:32 PM
To: Aaron Hathaway; jmoseley@corp.xanadoo.com
Cc: rt-users@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@lists.bestpractical.com
rt-users-bounces@lists.bestpractical.com
To: jmoseley@corp.xanadoo.com jmoseley@corp.xanadoo.com
Cc: rt-users@lists.bestpractical.com rt-users@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@corp.xanadoo.com [mailto:jmoseley@corp.xanadoo.com]
Sent: Thursday, August 21, 2008 3:19 PM
To: Helmuth Ramirez
Cc: Aaron Hathaway; rt-users@lists.bestpractical.com;
rt-users-bounces@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@c
         ompupay.com>                                               To
         Sent by:                  "Aaron Hathaway"
         rt-users-bounces@         <aaron.hathaway@prager.com>
         lists.bestpractic                                          cc
         al.com                    rt-users@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@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@compupay.com]
  Sent: Thursday, August 21, 2008 2:51 PM
  To: Aaron Hathaway; rt-users@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@lists.bestpractical.com
  [mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Aaron
  Hathaway
  Sent: Thursday, August 21, 2008 5:35 PM
  To: rt-users@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@bestpractical.com


  Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
  Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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.

Best regards, Ruslan.

14

Ruslan,

Both you and Helmuth had the right answer for me–I apparently had documentation-blindness. I was mistaking the script’s standard out for MySQL activity. Sorry about the goose chase.

Now that the script output is properly applied to my DB binary attachments are again working as expected. Thanks so much for everyone’s help.

Regards,
Aaron HathawayFrom: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] On Behalf Of Ruslan Zakirov
Sent: Friday, August 22, 2008 8:18 AM
To: Aaron Hathaway
Cc: rt-users@lists.bestpractical.com; Helmuth Ramirez
Subject: Re: [rt-users] 3.8.1 corrupting attachments

You have not applied correctly SQL queries generated by
etc/upgrade/schema.mysql-4.0-4.1.pl and described in UPGRADING.mysql

15

I’m having a problem with corruption as well. I had missed this
upgrade because I am running mysql 5.x so presumed it didn’t apply.
I’ve since run the script and everything seemed to work, but of course
this is after doing the 3.8.1 upgrades. My attachments still seem to
be corrupting, any suggestions? This is the output of show create
table attachments:

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) character set ascii default NULL,
Subject varchar(255) default NULL,
Filename varchar(255) default NULL,
ContentType varchar(80) character set ascii default NULL,
ContentEncoding varchar(80) character set ascii default NULL,
Content longblob,
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 AUTO_INCREMENT=4221 DEFAULT CHARSET=utf8

Quoted Text Below:

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 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users> wrote:

16

Has anyone had any luck with these attachment problems? It’s not a top
priority for me but it would certainly be nice if we can get it working.
-SteveOn Wed, Sep 10, 2008 at 10:35 AM, Steve Hopps steve.hopps@gmail.com wrote:

I’m having a problem with corruption as well. I had missed this upgrade because I am running mysql 5.x so presumed it didn’t apply. I’ve since run the script and everything seemed to work, but of course this is after doing the 3.8.1 upgrades. My attachments still seem to be corrupting, any suggestions? This is the output of show create table attachments:

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) character set ascii default NULL,
Subject varchar(255) default NULL,
Filename varchar(255) default NULL,
ContentType varchar(80) character set ascii default NULL,
ContentEncoding varchar(80) character set ascii default NULL,
Content longblob,
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 AUTO_INCREMENT=4221 DEFAULT CHARSET=utf8

Quoted Text Below:

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 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users> wrote: