https://doc.otrs.com/doc/manual/admin/6 ... ating.html
Running scripts/DBUpdate-to-6.pl i get the following error:
Code: Select all
$ scripts/DBUpdate-to-6.pl
Code: Select all
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 ...
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 ...
[Sat Apr 10 11:31:39 2021] DBUpdate-to-6.pl: Use of uninitialized value within %ArticleTypes in hash element at /opt/otrs/scripts/DBUpdateTo6/MigrateArticleData.pm line 114.
[Sat Apr 10 11:31:39 2021] DBUpdate-to-6.pl: Use of uninitialized value within %ArticleTypes in hash element at /opt/otrs/scripts/DBUpdateTo6/MigrateArticleData.pm line 117.
[Sat Apr 10 11:31:39 2021] DBUpdate-to-6.pl: Use of uninitialized value $CommunicationChannel in hash element at /opt/otrs/scripts/DBUpdateTo6/MigrateArticleData.pm line 118.
[Sat Apr 10 11:31:39 2021] DBUpdate-to-6.pl: DBD::mysql::db do failed: Column 'communication_channel_id' cannot be null at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.28.1 OS: linux Time: Sat Apr 10 11:31:39 2021
Message: Column 'communication_channel_id' cannot be null, SQL: '
INSERT INTO article (
id,ticket_id,article_sender_type_id,communication_channel_id,
is_visible_for_customer,create_by,create_time,change_by,change_time
)VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ), ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) , ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) '
Traceback (20523):
Module: scripts::DBUpdateTo6::MigrateArticleData::_MigrateData Line: 302
Module: scripts::DBUpdateTo6::MigrateArticleData::Run Line: 139
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.28.1 OS: linux Time: Sat Apr 10 11:31:39 2021
Message: An error occurs during article data migration!
Traceback (20523):
Module: scripts::DBUpdateTo6::MigrateArticleData::Run Line: 142
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89
An error occurs during article data migration!
Not possible to complete migration, check previous messages for more information.
Code: Select all
MariaDB [otrs]> select * from article where article_sender_type_id = '';
Empty set (0.000 sec)
Articles with article_sender_type_id not NULL:
Code: Select all
MariaDB [otrs]> select count(id) from article where article_sender_type_id != '';
+-----------+
| count(id) |
+-----------+
| 14925 |
+-----------+