<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Ruslan,<br>
<br>
Here's the output:<br>
<br>
| Table       | Create Table<br>
<br>
| Attachments | CREATE TABLE `Attachments` (<br>
  `id` int(11) NOT NULL auto_increment,<br>
  `TransactionId` int(11) NOT NULL,<br>
  `Parent` int(11) NOT NULL default '0',<br>
  `MessageId` varchar(160) default NULL,<br>
  `Subject` varchar(255) default NULL,<br>
  `Filename` varchar(255) default NULL,<br>
  `ContentType` varchar(80) default NULL,<br>
  `ContentEncoding` varchar(80) default NULL,<br>
  `Content` longtext,<br>
  `Headers` longtext,<br>
  `Creator` int(11) NOT NULL default '0',<br>
  `Created` datetime default NULL,<br>
  PRIMARY KEY  (`id`),<br>
  KEY `Attachments2` (`TransactionId`),<br>
  KEY `Attachments3` (`Parent`,`TransactionId`)<br>
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |<br>
<br>
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?<br>
<br>
Regards,<br>
Aaron<br>
<br>
<br>
Ruslan Zakirov wrote:
<blockquote
 cite="mid:589c94400808212344n262fed9q40583f0e087af145@mail.gmail.com"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator"
 content="MS Exchange Server version 6.5.7653.38">
  <title>Re: [rt-users] 3.8.1 corrupting attachments</title>
<!-- Converted from text/plain format -->
  <p><font size="2">Shouldn't at this point, but there is a chance that
later we'll have<br>
an upgrade for some 3.8.x version that wouldn't work correct if your<br>
DB is not changed using the script.<br>
  <br>
Could you please send us output of "SHOW CREATE TABLE Attachments;" SQL
command?<br>
  <br>
On Fri, Aug 22, 2008 at 3:38 AM, Aaron Hathaway<br>
<a class="moz-txt-link-rfc2396E" href="mailto:aaron.hathaway@prager.com"><aaron.hathaway@prager.com></a> wrote:<br>
> Helmuth,<br>
><br>
><br>
><br>
> I ran the script after updating from 3.8.0 to 3.8.1.  Would that
make a<br>
> difference?<br>
><br>
><br>
><br>
> Thanks,<br>
><br>
> Aaron<br>
><br>
><br>
><br>
> From: Helmuth Ramirez [<a moz-do-not-send="true"
 href="mailto:HelmuthRamirez@compupay.com">mailto:HelmuthRamirez@compupay.com</a>]<br>
> Sent: Thursday, August 21, 2008 3:32 PM<br>
> To: Aaron Hathaway; <a class="moz-txt-link-abbreviated" href="mailto:jmoseley@corp.xanadoo.com">jmoseley@corp.xanadoo.com</a><br>
> Cc: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
> Subject: Re: [rt-users] 3.8.1 corrupting attachments<br>
><br>
><br>
><br>
> Did you upgrade the db to 3.8.0, run the script, then update to
3.8.1?<br>
><br>
><br>
> ----- Original Message -----<br>
> From: <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a><br>
> <a class="moz-txt-link-rfc2396E" href="mailto:rt-users-bounces@lists.bestpractical.com"><rt-users-bounces@lists.bestpractical.com></a><br>
> To: <a class="moz-txt-link-abbreviated" href="mailto:jmoseley@corp.xanadoo.com">jmoseley@corp.xanadoo.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:jmoseley@corp.xanadoo.com"><jmoseley@corp.xanadoo.com></a><br>
> Cc: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>
<a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com"><rt-users@lists.bestpractical.com></a><br>
> Sent: Thu Aug 21 17:27:16 2008<br>
> Subject: Re: [rt-users] 3.8.1 corrupting attachments<br>
><br>
> James,<br>
><br>
> Thanks for that tip--I missed that initially.  However, even after
running<br>
> that script against my DB, I'm still seeing the same attachment
corruption.<br>
><br>
> Regards,<br>
> Aaron Hathaway<br>
><br>
> -----Original Message-----<br>
> From: <a class="moz-txt-link-abbreviated" href="mailto:jmoseley@corp.xanadoo.com">jmoseley@corp.xanadoo.com</a> [<a moz-do-not-send="true"
 href="mailto:jmoseley@corp.xanadoo.com">mailto:jmoseley@corp.xanadoo.com</a>]<br>
> Sent: Thursday, August 21, 2008 3:19 PM<br>
> To: Helmuth Ramirez<br>
> Cc: Aaron Hathaway; <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>;<br>
> <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a><br>
> Subject: Re: [rt-users] 3.8.1 corrupting attachments<br>
><br>
> Perhaps the script itself is poorly named, but the instructions
state that<br>
> the 4.0 mysql upgrade script must be run if you are upgrading as
it changes<br>
> the DB schema.<br>
><br>
> It's not a script only for those running 4.x.x versions of mysql,
it's for<br>
> everyone that's upgrading.<br>
><br>
><br>
> James Moseley<br>
><br>
><br>
><br>
><br>
><br>
>              "Helmuth Ramirez"<br>
>              <HelmuthRamirez@c<br>
>             
ompupay.com>                                               To<br>
>              Sent by:                  "Aaron Hathaway"<br>
>              rt-users-bounces@        
<a class="moz-txt-link-rfc2396E" href="mailto:aaron.hathaway@prager.com"><aaron.hathaway@prager.com></a><br>
>             
lists.bestpractic                                          cc<br>
>              al.com                   
<a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
>                                                                   
Subject<br>
>                                        Re: [rt-users] 3.8.1
corrupting<br>
>              08/21/2008 05:09          attachments<br>
>              PM<br>
><br>
><br>
><br>
><br>
><br>
><br>
><br>
><br>
><br>
> Oh, then I don't have a good answer for you.  Sorry L  Maybe the
list can<br>
> provide some insight.<br>
><br>
> From: Aaron Hathaway [<a moz-do-not-send="true"
 href="mailto:aaron.hathaway@prager.com">mailto:aaron.hathaway@prager.com</a>]<br>
> Sent: Thursday, August 21, 2008 6:01 PM<br>
> To: Helmuth Ramirez<br>
> Subject: RE: [rt-users] 3.8.1 corrupting attachments<br>
><br>
> I'm running MySQL 5.0.18, with the default latin1 character set—as
I was<br>
> with 3.6.x.<br>
><br>
> --Aaron<br>
><br>
>       From: Helmuth Ramirez [<a moz-do-not-send="true"
 href="mailto:HelmuthRamirez@compupay.com">mailto:HelmuthRamirez@compupay.com</a>]<br>
>       Sent: Thursday, August 21, 2008 2:51 PM<br>
>       To: Aaron Hathaway; <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
>       Subject: RE: [rt-users] 3.8.1 corrupting attachments<br>
><br>
>       Aaron,<br>
>       This happened to me when I didn't do the 4.0 to 4.1 MySQL
update.<br>
><br>
>       From: <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a><br>
>       [<a moz-do-not-send="true"
 href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>]
On Behalf Of Aaron<br>
>       Hathaway<br>
>       Sent: Thursday, August 21, 2008 5:35 PM<br>
>       To: <a class="moz-txt-link-abbreviated" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
>       Subject: [rt-users] 3.8.1 corrupting attachments<br>
><br>
>       Is anyone else seeing problems with corrupted attachments in
3.8.x?<br>
>       From what I can tell, 8-bit characters are getting stripped
or<br>
>       altered in mime attachments, corrupting the data.<br>
><br>
>       Attached are two PDFs, the original PDF (original.pdf) and
the<br>
>       post-RT PDF (post-rt.pdf).  The latter appears to be blank
after RT<br>
>       receives it.  I'm also seeing corruption of MS Office
documents, so<br>
>       this may extend to all binary attachments.<br>
><br>
>       I'm happy to submit a bug report if others are experiencing
this as<br>
>       well.<br>
><br>
>       Cheers,<br>
><br>
>       Aaron Hathaway_______________________________________________<br>
>       <a moz-do-not-send="true"
 href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>
>       Community help: <a moz-do-not-send="true"
 href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>
>       Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
><br>
><br>
>       Discover RT's hidden secrets with RT Essentials from
O'Reilly Media.<br>
>       Buy a copy at <a moz-do-not-send="true"
 href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>
> _______________________________________________<br>
> <a moz-do-not-send="true"
 href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>
> Community help: <a moz-do-not-send="true"
 href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>
> Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
><br>
><br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.<br>
> Buy a copy at <a moz-do-not-send="true"
 href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>
><br>
> _______________________________________________<br>
> <a moz-do-not-send="true"
 href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>
> Community help: <a moz-do-not-send="true"
 href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>
> Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br>
><br>
><br>
> Discover RT's hidden secrets with RT Essentials from O'Reilly
Media.<br>
> Buy a copy at <a moz-do-not-send="true"
 href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>
><br>
  <br>
  <br>
  <br>
--<br>
Best regards, Ruslan.<br>
  </font>
  </p>
</blockquote>
<br>
</body>
</html>