Ok I followed
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&ItemID=330
to solve this issue.
Thank you very much
On 15/03/10 18:36, Patrick Matthäi wrote:
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
--
Javier Barroso
Administrador de Sistemas
Dirección Servicios Corporativos: TI
jbarr...@isotrol.com
__
ISOTROL
Edificio BLUENET. Avda. Isaac Newton, s/n, Isla de la Cartuja
41092 Sevilla.
Tel.: 955 036 800 - Fax: 955 036 849
www.isotrol.com
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
