<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<title>Re: [rt-users] 3.8.1 corrupting attachments</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Helmuth,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I ran the script after updating from 3.8.0 to 3.8.1. Would that
make a difference? <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Aaron<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Helmuth Ramirez
[mailto:HelmuthRamirez@compupay.com] <br>
<b>Sent:</b> Thursday, August 21, 2008 3:32 PM<br>
<b>To:</b> Aaron Hathaway; jmoseley@corp.xanadoo.com<br>
<b>Cc:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> Re: [rt-users] 3.8.1 corrupting attachments<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p><span style='font-size:10.0pt'>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: rt-users-bounces@lists.bestpractical.com
<rt-users-bounces@lists.bestpractical.com><br>
To: jmoseley@corp.xanadoo.com <jmoseley@corp.xanadoo.com><br>
Cc: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><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
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: jmoseley@corp.xanadoo.com [<a 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; rt-users@lists.bestpractical.com;
rt-users-bounces@lists.bestpractical.com<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@
<aaron.hathaway@prager.com> <br>
lists.bestpractic
cc<br>
al.com
rt-users@lists.bestpractical.com <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 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
href="mailto:HelmuthRamirez@compupay.com">mailto:HelmuthRamirez@compupay.com</a>]<br>
Sent: Thursday, August 21, 2008 2:51 PM<br>
To: Aaron Hathaway;
rt-users@lists.bestpractical.com<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: rt-users-bounces@lists.bestpractical.com<br>
[<a
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: rt-users@lists.bestpractical.com<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
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
href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>
Commercial support: sales@bestpractical.com<br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials
from O'Reilly Media.<br>
Buy a copy at <a
href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br>
_______________________________________________<br>
<a 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 href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>
Commercial support: sales@bestpractical.com<br>
<br>
<br>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>
Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a></span><o:p></o:p></p>
</div>
</body>
</html>