[rt-users] Attachments getting mangled

[dyoung-rtusers at techsafari.com]

All,

> Hello, Chris.
> Could you backup your DB, and run next to SQL queries?
> ALTER TABLE Attachments CHANGE Content Content LONGBLOB NULL;
> 
> Then check if you could binary attachments without problems and report
> back.
> This query is safe but anyway I would suggest you to backup data.

Running this fixed my attachment corruption problem, thanks!

I think the Gentoo Installation Guide mentions changing some aspects of the
RT database in the comments section near the end of the document.  This may
be why both Jeremy and I had this problem (we're both running on GenToo).  I
followed the threads listed in that Guide to finally get it working, but I
honestly don't remember everything that was tweaked along the way.

Perhaps someone more knowledgeable could change the GentooInstallGuide to
reflect the above fix for future users?

Thanks again,

Donovan

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Roy El-Hames
Sent: Wednesday, September 13, 2006 12:52 PM
To: Peake, Jeremy
Cc: Schultz, Eric; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Attachments getting mangled

Jeremy;
Have a look at :
http://lists.fsck.com/pipermail/rt-users/2006-July/040843.html
it maybe related.
Roy

Peake, Jeremy wrote:
>> $MaxAttachmentSize (make sure it's big enough) $TruncateLongAttachments
>>     
> (make sure it's undef) $DropLongAttachments (make sure it's undef)
>
>
> I checked that out, $MaxAttachSize is 10 megs and truncate and drop are
> both undef.
>
> Also saw an earlier post of same issue, and tried reinstalling Perl
> (5.8.8) but the probem remains.
> _______________________________________________
> 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
>
>