Upgrade 5.0.30 to 06.11.01

Moderator: crythias

Post Reply
christian1706
OTRS newbie
Posts: 2
Joined: 27 Sep 2018, 13:01
OTRS Version?: 5.0.30

Upgrade 5.0.30 to 06.11.01

Post by christian1706 » 27 Sep 2018, 13:57

Hello community.

I run a OTRS platform on version 5.0.30 and would like to upgrade to 06.11.01 on a VMWare @ Open Suse Leap 42.3.

I follow the instructions in this manual
https://doc.otrs.com/doc/manual/admin/6 ... ating.html

but unfortunately the migrating script fails with those error messages:
please see screenshot fehler.jpg.

I got no Idea, where I can configure the mentioned "subject" value.

If you got any hints to solve this issue, I would be very grateful....

Regs Christian
You do not have the required permissions to view the files attached to this post.

jojo
Moderator
Posts: 14390
Joined: 26 Jan 2007, 14:50
OTRS Version?: Git Master
Contact:

Re: Upgrade 5.0.30 to 06.11.01

Post by jojo » 27 Sep 2018, 14:10

Please paste the error text in TEXT not in Pictures
"Production": OTRS™ 6, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com :: Share your ideas

christian1706
OTRS newbie
Posts: 2
Joined: 27 Sep 2018, 13:01
OTRS Version?: 5.0.30

Re: Upgrade 5.0.30 to 06.11.01

Post by christian1706 » 27 Sep 2018, 14:36

Hello,

here the error in Text Form:
In advance I choose TimeZone Europe/Berlin as timezone and then receive those errors:


Executing tasks ...

Step 1 of 42: Check framework version ...
Step 2 of 42: Check required Perl version ...
Step 3 of 42: Check required database version ...
Step 4 of 42: Check database charset ...
Step 5 of 42: Check required Perl modules ...
Step 6 of 42: Check if database has been backed up ...
Step 7 of 42: Upgrade database structure ...
[Thu Sep 27 14:34:41 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Field 'subject' doesn't have a default value at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-56 Perl: 5.18.2 OS: linux Time: Thu Sep 27 14:34:41 2018

Message: Field 'subject' doesn't have a default value, SQL: 'INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time)
VALUES
('Ticket email delivery failure notification', 1, '', 1, '2018-09-27 12:34:41', 1, '2018-09-27 12:34:41')'

Traceback (32212):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 363
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::UpdateNotificationTables::Run Line: 67
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 138
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./DBUpdate-to-6.pl Line: 87


ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-56 Perl: 5.18.2 OS: linux Time: Thu Sep 27 14:34:41 2018

Message: Error during execution of 'INSERT INTO notification_event (name, valid_id, comments, create_by, create_time, change_by, change_time)
VALUES
('Ticket email delivery failure notification', 1, '', 1, '2018-09-27 12:34:41', 1, '2018-09-27 12:34:41')'!

Traceback (32212):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 366
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::UpdateNotificationTables::Run Line: 67
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 138
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./DBUpdate-to-6.pl Line: 87




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

User avatar
christianclavet
OTRS expert
Posts: 75
Joined: 27 Aug 2018, 13:50
OTRS Version?: Community
Real Name: Christian Clavet
Company: Tact Group

Re: Upgrade 5.0.30 to 06.11.01

Post by christianclavet » 02 Oct 2018, 18:16

Hi!
Not sure I can help... :(

But I've seen that record from your output:
'Ticket email delivery failure notification', 1, '', 1, '2018-09-27 12:34:41', 1, '2018-09-27 12:34:41')'
There is notification event is causing problem in your DB as the subject have something that the migration script does'nt like.
I don't know why the script block on those events...

Perhaps using the console in maint:: and try to clear the email notifications.
You could try this command if it clear the event log for the communications and help to fix the problem..
otrs.Console.pl Maint::Log::CommunicationLog --purge
There is also this one you could use if the first doesn't help (will even clear active communication being logged)
otrs.Console.pl Maint::Log::CommunicationLog --force--delete
----------------------------------------------
OTRS Community 6.0.11
Debian 9.0

MariaDB

Post Reply