<!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>