On Thu, Dec 18, 2008 at 4:05 PM, Fred Blaise <[email protected]> wrote: > Hi, > > I got a problematic attachment problem. Files attached are corrupted, > and picture files simple show a link to the picture, but no picture. > Sounds like deja-vu right? > > I run RT 3.6.7 on a gentoo system, mysql-5.0.54. > > The only things I can see in the logs that could indicate a problem > whatsoever is: > [Thu Dec 18 10:25:26 2008] [warning]: Encode::Guess failed: decoder is > undefined; fallback to iso-8859-1 > (//var/www/localhost/rt-3.6.7/lib/RT/I18N.pm:436) This warning string is issued when an incoming message has a text part and this part has no information about encoding of the text. RT tries to guess as it has to convert it into UTF8. It has nothing to do with images or other binary attachments.
> > The tables in the RT database were latin1 charset. I tried to alter all > tables to UTF8, but then, attachments do not even get into the database > anymore (only their reference so to speak, but no binary data). It was bad idea. Proper upgrade to 3.8 can fix this. You can use half-measure and convert Attachments.Content, ObjectCustomFieldValues.LargeContent and sessions.a_session to corresponding BLOBs (LONGTEXT to LONGBLOB, TEXT to BLOB and so on). > > My RT_config.pm shows: > @EmailInputEncodings = qw(utf-8 iso-8859-1 us-ascii) unless > (@EmailInputEncodings); Again, it's related to text parts only. When RT sees no information about encoding it uses these encodings to guess encoding of the email. > > I also tried to move around the utf-8 and iso-8859-1 values, but nothing > better. > > What else can I try to make them work? I saw quite some stuff about > updates on the DB when going to 3.8, but nothing that would concern me > apparently. > > Thanks for any pointers. > fred -- Best regards, Ruslan. _______________________________________________ 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
