Centos 7 with Mariadb
I try to update OTRS from version 5.0.29 to 6.0.x and everytime I get one database migration error.
Code: Select all
Migration started ...
Checking requirements ...
Requirement check for: Check framework version ...
Requirement check for: Check required Perl version ...
Requirement check for: Check required database version ...
Requirement check for: Check database charset ...
Requirement check for: Check required Perl modules ...
Requirement check for: Check if database has been backed up ...
Did you backup the database? [Y]es/[N]o: y
Requirement check for: Upgrade database structure ...
Requirement check for: Migrating time zone configuration ...
Requirement check for: Update calendar appointment future tasks ...
Requirement check for: Migrate GenericAgent jobs configuration ...
Requirement check for: Migrate TicketAppointment rules configuration ...
Requirement check for: Create entries in new article table ...
Requirement check for: Migrate ArticleType in ProcessManagement Data ...
Requirement check for: Migrate ArticleType in PostMaster filters ...
Executing tasks ...
Step 1 of 37: Check framework version ...
Step 2 of 37: Check required Perl version ...
Step 3 of 37: Check required database version ...
Step 4 of 37: Check database charset ...
Step 5 of 37: Check required Perl modules ...
Step 6 of 37: Check if database has been backed up ...
Step 7 of 37: Upgrade database structure ...
Step 8 of 37: Migrate configuration ...df -h
Step 9 of 37: Refresh configuration cache after migration of OTRS 5 settings ...
Step 10 of 37: Migrating ticket storage configuration ...
Step 11 of 37: Migrating article search index configuration ...
Step 12 of 37: Migrating ticket zoom customer information widget configuration ...
Step 13 of 37: Drop deprecated table gi_object_lock_state ...
Step 14 of 37: Migrate PossibleNextActions setting ...
Step 15 of 37: Migrating time zone configuration ...
Step 16 of 37: Create appointment calendar tables ...
Step 17 of 37: Create ticket number counter tables ...
Step 18 of 37: Update calendar appointment future tasks ...
Step 19 of 37: Add basic appointment notification for reminders ...
Step 20 of 37: Create Form Draft tables ...
Step 21 of 37: Clean and drop group_user permission_value column ...
Step 22 of 37: Migrate GenericAgent jobs configuration ...
Step 23 of 37: Migrate TicketAppointment rules configuration ...
Step 24 of 37: Migrate Merged Ticket history name values ...
Step 25 of 37: Migrate ticket statistics ...
Step 26 of 37: Migrate ticket notifications ...
Step 27 of 37: Create entries in new article table ...
Step 28 of 37: Post changes on article related tables ...
Step 29 of 37: Migrate ArticleType in ProcessManagement Data ...
Step 30 of 37: Migrate ArticleType in PostMaster filters ...
Step 31 of 37: Migrate chat articles ...
[Thu Aug 16 16:36:50 2018] 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 16:36:50 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 = ?
'
Traceback (6266):
Module: scripts::DBUpdateTo6::MigrateChatData::_CheckChatArticles Line: 434
Module: scripts::DBUpdateTo6::MigrateChatData::Run Line: 56
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89
Step 32 of 37: Initialize default cron jobs ...
Step 33 of 37: Migrate web service configuration ...
Step 34 of 37: Uninstall Merged Feature Add-Ons ...
Step 35 of 37: Clean up the cache ...
Step 36 of 37: Refresh configuration cache another time ...
Step 37 of 37: Check SysConfig consistency ...
Code: Select all
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: '
Thanks