[rt-users] 3.8.1 corrupting attachments
Aaron Hathaway
aaron.hathaway at prager.com
Fri Aug 22 13:08:47 EDT 2008
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 Hathaway
-----Original Message-----
From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov
Sent: Friday, August 22, 2008 8:18 AM
To: Aaron Hathaway
Cc: rt-users at 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
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.
More information about the rt-users
mailing list