We run a quite old OTRS 2.2.4 in a production environment, still looking out for an upgrade.
Everything used to work fine. Lately we get the following error, it sometimes occurs when a customer
submits a ticket via email. (I replaced names by "xx" to anonymize).
Does anyone know a QUICK fix?
Code: Select all
From: Mail Delivery System [mailto:Mailer-Daemon@xx.eu]
Date: 7 7 2011
To: xx, xx
subject: Mail delivery failed: returning message to sender
This message was created automatically by mail delivery software.
A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:
pipe to | /usr/share/otrs2/bin/PostMaster.pl
generated by imsticket@xx.eu
(ultimately generated from ticket@xx.eu)
local delivery failed
The following text was generated during the delivery attempt:
------ pipe to | /usr/share/otrs2/bin/PostMaster.pl
generated by imsticket@xx.eu
(ultimately generated from ticket@xx.eu) ------
Wide character in print at /usr/share/otrs2/Kernel/System/Log/File.pm line 66.
DBD::mysql::st execute failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' at /usr/share/otrs2/Kernel/System/DB.pm line 484.
Wide character in print at /usr/share/otrs2/Kernel/System/Log/File.pm line 70.
ERROR: OTRS-PM-10 Perl: 5.8.8 OS: linux Time: Mon Jun 6 09:12:27 2011
Message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM article WHERE ticket_id = 7090 AND a_message_id = '<63C6F093383A7940A5F159A3ED42D7E50A651D@xx>' AND a_from = '"xx" <xx@xx>' AND a_subject = 'I: ??: ?????1001545' AND incoming_time = 1307344347'
Traceback (1041):
Module: Kernel::System::Ticket::Article::_ArticleGetId (v1.147) Line: 560
Module: Kernel::System::Ticket::Article::ArticleCreate (v1.147) Line: 143
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 215
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: (eval) (v1.26) Line: 108
Module: /usr/share/otrs2/bin/PostMaster.pl (v1.26) Line: 82
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/otrs2/Kernel/System/DB.pm line 543.
ERROR: OTRS-PM-10 Perl: 5.8.8 OS: linux Time: Mon Jun 6 09:12:27 2011
Message: Can't get ArticleID from INSERT!
Traceback (1041):
Module: Kernel::System::Ticket::Article::ArticleCreate (v1.147) Line: 152
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 215
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: (eval) (v1.26) Line: 108
Module: /usr/share/otrs2/bin/PostMaster.pl (v1.26) Line: 82
ERROR: OTRS-PM-10 Perl: 5.8.8 OS: linux Time: Mon Jun 6 09:12:27 2011
Message: Can't process email with MessageID <<63C6F093383A7940A5F159A3ED42D7E50A651D@xx>>! Please create a bug report with this email (var/spool/) on http://bugs.otrs.org/!
Traceback (1041):
Module: Kernel::System::PostMaster::NewTicket::Run (v1.63) Line: 241
Module: Kernel::System::PostMaster::Run (v1.65) Line: 324
Module: (eval) (v1.26) Line: 108
Module: /usr/share/otrs2/bin/PostMaster.pl (v1.26) Line: 82
ERROR: OTRS-PM-10 Perl: 5.8.8 OS: linux Time: Mon Jun 6 09:12:27 2011
Message: Can't process mail, see log sub system! at /usr/share/otrs2/bin/PostMaster.pl line 110.
Traceback (1041):
Module: /usr/share/otrs2/bin/PostMaster.pl (v1.26) Line: 129
)
