CentOS Linux release 7.4.1708
MariaDB
При обновлении OTRS с версии 5.0.29 до 6.0.1 во время миграции возникает ошибка.
Код: Выделить всё
DBUpdate-to-6.pl: DBD::mysql::st execute failed: Unknown column 'at.communication_channel_id' in 'where clause' at /opt/otrs/Kernel/System/DB.pm line 694.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-00 Perl: 5.16.3 OS: linux Time: Thu Aug 16 17:13:07 2018
Message: Unknown column 'at.communication_channel_id' in 'where clause', SQL: '
SELECT COUNT(at.id)
FROM article_data_mime adm
JOIN article at ON adm.article_id = at.id
WHERE at.communication_channel_id = ?
'
Код: Выделить всё
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'a.is_visible_for_customer' in 'where clause', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'a.is_visible_for_customer' in 'where clause', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'a.is_visible_for_customer' in 'where clause', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:22 2018 error OTRS-CGI-00 Unknown column 'communication_channel_id' in 'field list', SQL: '
Thu Aug 16 17:32:03 2018 error OTRS-otrs.Console.pl-Maint::Ticket::FulltextIndexRebuildWorker-00 There was an error executing Execute() in Kernel::System::Console::Command::Maint::Ticket::FulltextIndexRebuildWorker: [Thu Aug 16 17:32:03 2018] otrs.Daemon.pl: DBD::mysql::st execute failed: Unknown column 'search_index_needs_rebuild' in 'where clause' at /opt/otrs/Kernel/System/DB.pm line 694.
Thu Aug 16 17:32:03 2018 error OTRS-otrs.Console.pl-Maint::Ticket::FulltextIndexRebuildWorker-00 Unknown column 'search_index_needs_rebuild' in 'where clause', SQL: '