[rt-users] Attachments getting mangled - FIXED

[Peake, Jeremy]

THANKS ALL!!!!!

Changing that column to LONGBLOB fixed it for me.  Thanks a lot!

-----Original Message-----
From: Donovan Young [mailto:dyoung at techsafari.com] On Behalf Of
dyoung-rtusers at techsafari.com
Sent: Wednesday, September 13, 2006 3:44 PM
To: Peake, Jeremy
Cc: rt-users at lists.bestpractical.com
Subject: RE: [rt-users] Attachments getting mangled

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