Error, updating OTRS 5 to 6

Moderator: crythias

Post Reply
chlesmes
Znuny newbie
Posts: 2
Joined: 12 Jul 2018, 18:42
Znuny Version: 4,5,6
Real Name: Christian Lesmes
Company: Ciberc

Error, updating OTRS 5 to 6

Post by chlesmes »

Hi,
I need your help
I'm updating from version 5.0.1-03 to 6.0.8-01 in centos.
When running the command

Code: Select all

scripts/DBUpdate-to-6.pl
as otrs user gives me an error; in the step 29 of 41 "Post changes on article related tables ..."

I have done the step by step by step of the page http://doc.otrs.com/doc/manual/admin/st ... ating.html

I'm sorry if there are errors in writing, English is not my natural language.

...
Executing tasks ...

Step 1 of 41: Check framework version ...
Step 2 of 41: Check required Perl version ...
Step 3 of 41: Check required database version ...
Step 4 of 41: Check database charset ...
Step 5 of 41: Check required Perl modules ...
Step 6 of 41: Check if database has been backed up ...
Step 7 of 41: Upgrade database structure ...
Step 8 of 41: Migrate configuration ...
Step 9 of 41: Refresh configuration cache after migration of OTRS 5 settings ...
Step 10 of 41: Migrating ticket storage configuration ...
Step 11 of 41: Migrating article search index configuration ...
Step 12 of 41: Migrating ticket zoom customer information widget configuration ...
Step 13 of 41: Drop deprecated table gi_object_lock_state ...
Step 14 of 41: Migrate PossibleNextActions setting ...
Step 15 of 41: Migrate ZoomExpand setting ...
Step 16 of 41: Migrating time zone configuration ...
Step 17 of 41: Create appointment calendar tables ...
Step 18 of 41: Create ticket number counter tables ...
Step 19 of 41: Update calendar appointment future tasks ...
Step 20 of 41: Add basic appointment notification for reminders ...
Step 21 of 41: Create Form Draft tables ...
Step 22 of 41: Clean and drop group_user permission_value column ...
Step 23 of 41: Migrate GenericAgent jobs configuration ...
Step 24 of 41: Migrate TicketAppointment rules configuration ...
Step 25 of 41: Migrate Merged Ticket history name values ...
Step 26 of 41: Migrate ticket statistics ...
Step 27 of 41: Migrate ticket notifications ...
Step 28 of 41: Create entries in new article table ...
Step 29 of 41: Post changes on article related tables ...
[Mon Jul 16 14:06:02 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Key column 'a_message_id_md5' doesn't exist in table at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-87 Perl: 5.16.3 OS: linux Time: Mon Jul 16 14:06:02 2018

Message: Key column 'a_message_id_md5' doesn't exist in table, SQL: 'EXECUTE IndexStatement'

Traceback (28878):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 363
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 271
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52
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-87 Perl: 5.16.3 OS: linux Time: Mon Jul 16 14:06:02 2018

Message: Error during execution of 'EXECUTE IndexStatement'!

Traceback (28878):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 366
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 271
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run Line: 52
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 89




Not possible to complete migration, check previous messages for more information.
Post Reply