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
