merge #573951 #511080
thanks
Hi,
I think you have got currently two options:
1) convert your database to utf8
2) set in your config.pm, that otrs should not use utf8 as charset.
The problem is known, fixing it for new installations is easy, but it
may break existing ones :/
Am 15.03.2010 10:51, schrieb Javier Barroso:
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
--
/*
Mit freundlichem Gruß / With kind regards,
Patrick Matthäi
GNU/Linux Debian Developer
E-Mail: pmatth...@debian.org
patr...@linux-dev.org
Comment:
Always if we think we are right,
we were maybe wrong.
*/
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
