THANKS ALL!!!!! Changing that column to LONGBLOB fixed it for me. Thanks a lot!
-----Original Message----- From: Donovan Young [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 13, 2006 3:44 PM To: Peake, Jeremy Cc: rt-users@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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roy El-Hames Sent: Wednesday, September 13, 2006 12:52 PM To: Peake, Jeremy Cc: Schultz, Eric; rt-users@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: > [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com