Your message dated Wed, 27 Apr 2011 19:18:28 +0200
with message-id <[email protected]>
and subject line closing
has caused the Debian Bug report #511080,
regarding Illegal mix of collations
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
511080: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=511080
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: otrs2
Version: 2.2.7-2lenny3
Severity: normal
DBD::mysql::st execute failed: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
at /usr/share/otrs/Kernel/System/DB.pm line 490.
Wide character in syswrite at /usr/lib/perl/5.10/Sys/Syslog.pm line 451.
This message is caused by PostMasterPOP3.pl cron task when it find a mail that
contains something that it doesn't like (subject from mail has non-english
characters and then they are q-encoding).
Our last message causing this issue had:
Subject: =?utf-8?Q?Re:_[Ticket#2010022510000153]_PEDID?=
=?utf-8?Q?O_DE_UNA_IMPRESORA_MULTIFUNCI=EF=BF=BD=EF=BF=BDN_HP?=
There is a faq at otrs.org which explain this issue [1]
mysqlshow --status otrs2 tell us about latin1_swedish_ci encoding:
| Name | ... | Collation | ...
| ... | ... | latin1_swedish_ci | ...
| xml_storage | ... | latin1_swedish_ci | ...
Is there any tip to solve this issue, and maintaining otrs compatible with
debian package ?
Thank you very much !
[1] http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=185
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-3-686 (SMP w/2 CPU cores)
Locale: LANG=es_ES.UTF-8, LC_CTYPE=es_ES.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--- End Message ---
--- Begin Message ---
--
/*
Mit freundlichem Gruß / With kind regards,
Patrick Matthäi
GNU/Linux Debian Developer
E-Mail: [email protected]
[email protected]
Comment:
Always if we think we are right,
we were maybe wrong.
*/
signature.asc
Description: OpenPGP digital signature
--- End Message ---
