[rt-users] 3.8.1 corrupting attachments

Fri Aug 22 11:20:22 EDT 2008

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

-- 
Best regards, Ruslan.