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
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
