Hi,
I often receive the following warning (see bellow). Most of the time,
the message is spam so I don't care. But sometime it's a rightful
message and even for the sake of it, I'd like to fix the issue.
Apparently, I need to edit the database structure (collation) but I've
been instructed to never do so. What can I do to receive those
messages?
# BEGINNING OF WARNING #############
[Wed Mar 7 17:48:04 2018] otrs.Daemon.pl: DBD::mysql::st execute
failed: Illegal mix of
collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
at /rw/opt/otrs-5.0.20/Kernel/System/DB.pm line 679.
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar 7 17:48:04 2018
Message: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=', SQL: 'SELECT id FROM
article WHERE
ticket_id = ? AND a_message_id = ? AND a_from = ? AND a_subject = ?
AND incoming_time = ?
ORDER BY id DESC LIMIT 1'
Traceback (17337):
Module: Kernel::System::Ticket::Article::_ArticleGetId Line: 2025
Module: Kernel::System::Ticket::Article::ArticleCreate Line: 310
Module: Kernel::System::PostMaster::NewTicket::Run Line: 455
Module: Kernel::System::PostMaster::Run Line: 413
Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 220
Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
Module: Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: (eval) Line: 150
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run
Line: 129
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 250
Module: (eval) Line: 316
Module: main::Start Line: 316
Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar 7 17:48:04 2018
Message: Can't get ArticleID from insert (TicketID=18304,
MessageID=<20180307164731.A4F33249B5@tc3-app-mailmaster18>)!
Traceback (17337):
Module: Kernel::System::Ticket::Article::ArticleCreate Line: 320
Module: Kernel::System::PostMaster::NewTicket::Run Line: 455
Module: Kernel::System::PostMaster::Run Line: 413
Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 220
Module: Kernel::System::MailAccount::IMAP::Fetch Line: 86
Module: Kernel::System::MailAccount::MailAccountFetch Line: 440
Module: Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch::Run
Line: 94
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: (eval) Line: 150
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Cron::Run
Line: 129
Module: Kernel::System::Daemon::DaemonModules::SchedulerTaskWorker::Run
Line: 250
Module: (eval) Line: 316
Module: main::Start Line: 316
Module: /opt/otrs/bin/otrs.Daemon.pl Line: 138
ERROR: OTRS-otrs.Console.pl-Maint::PostMaster::MailAccountFetch-59
Perl: 5.20.2 OS: linux
Time: Wed Mar 7 17:48:04 2018
Message: Can't process email with MessageID
<<20180307164731.A4F33249B5@tc3-app-mailmaster18>>! Please create a
bug report with this
email (From: "Bax Music"