OTRS Scheduler Daemon Cron: MailAccountFetch

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" <[email protected]>, Located under
var/spool/problem-email*)
on http://bugs.otrs.org/!

Traceback (17337):
   Module: Kernel::System::PostMaster::NewTicket::Run Line: 483
   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: IMAPS: Can't process mail, see log sub system
(/opt/otrs/var/spool/problem-email-4eae41ac6feef7212164fe0a9afe02be,
report it on
http://bugs.otrs.org/)!

Traceback (17337):
   Module: Kernel::System::MailAccount::IMAP::_Fetch Line: 224
   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

# END OF MESSAGE ######################

-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs