[rt-users] 3.8.1 corrupting attachments

Fri Aug 22 11:18:21 EDT 2008

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 at 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 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.
>
>
> _______________________________________________
> 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.