I'm currently trying to upgrade from 5.0.23 to 6.0.6.
OS: CentOS 7
When running
Code: Select all
yum -y install otrs-6.0.6-01.noarch.rpm
Code: Select all
Warning: /opt/otrs/Kernel/Config.pm erstellt als /opt/otrs/Kernel/Config.pm.rpmnew
[Wed Mar 21 18:16:06 2018] otrs.Console.pl: Malformed UTF-8 character (unexpected end of string) in substitution (s///) at /opt/otrs/Kernel/Config/Defaults.pm line 2026.
[Wed Mar 21 18:16:09 2018] otrs.Console.pl: DBD::mysql::st execute failed: Table 'otrs.sysconfig_deployment_lock' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 694.
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-10 Perl: 5.16.3 OS: linux Time: Wed Mar 21 18:16:09 2018
Message: Table 'otrs.sysconfig_deployment_lock' doesn't exist, SQL: '
SELECT id, exclusive_lock_guid, exclusive_lock_user_id, exclusive_lock_expiry_time
FROM sysconfig_deployment_lock
ORDER BY exclusive_lock_expiry_time DESC LIMIT 1'
Traceback (4218):
Module: Kernel::System::SysConfig::DB::_DeploymentLockGet Line: 5183
Module: Kernel::System::SysConfig::DB::DeploymentIsLocked Line: 4905
Module: Kernel::System::SysConfig::DB::DefaultSettingLock Line: 1591
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2581
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38
[Wed Mar 21 18:16:09 2018] otrs.Console.pl: DBD::mysql::db do failed: Table 'otrs.sysconfig_default' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-10 Perl: 5.16.3 OS: linux Time: Wed Mar 21 18:16:09 2018
Message: Table 'otrs.sysconfig_default' doesn't exist, SQL: '
UPDATE sysconfig_default
SET
exclusive_lock_guid = ?,
exclusive_lock_user_id = ?,
exclusive_lock_expiry_time = ?
'
Traceback (4218):
Module: Kernel::System::SysConfig::DB::DefaultSettingLock Line: 1676
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2581
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38
ERROR: OTRS-otrs.Console.pl-Maint::Config::Rebuild-10 Perl: 5.16.3 OS: linux Time: Wed Mar 21 18:16:09 2018
Message: System was unable to lock Default Settings
Traceback (4218):
Module: Kernel::System::SysConfig::ConfigurationXML2DB Line: 2586
Module: Kernel::System::Console::Command::Maint::Config::Rebuild::Run Line: 51
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 80
Module: /opt/otrs/bin/otrs.Console.pl Line: 38
Error: There was a problem writing XML to DB.
Rebuilding the system configuration...
[Wed Mar 21 18:16:10 2018] otrs.Console.pl: Malformed UTF-8 character (unexpected end of string) in substitution (s///) at /opt/otrs/Kernel/Config/Defaults.pm line 2026.
Deleting cache...
Done.
Next steps:
...
Code: Select all
/opt/otrs/scripts/DBUpdate-to-6.pl
Code: Select all
Executing tasks ...
Step 1 of 39: Check framework version ...
Step 2 of 39: Check required Perl version ...
Step 3 of 39: Check required database version ...
Step 4 of 39: Check database charset ...
Step 5 of 39: Check required Perl modules ...
Step 6 of 39: Check if database has been backed up ...
Step 7 of 39: Upgrade database structure ...
[Wed Mar 21 17:31:56 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 1 at /opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Wed Mar 21 17:31:56 2018
Message: Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 1, SQL: 'ALTER TABLE customer_user CHANGE pw pw VARCHAR (128) NULL'
Traceback (4264):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 363
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::PasswordColumnChanges::Run Line: 39
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 89
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-10 Perl: 5.16.3 OS: linux Time: Wed Mar 21 17:31:56 2018
Message: Error during execution of 'ALTER TABLE customer_user CHANGE pw pw VARCHAR (128) NULL'!
Traceback (4264):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 366
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 311
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::PasswordColumnChanges::Run Line: 39
Module: scripts::DBUpdateTo6::UpgradeDatabaseStructure::Run Line: 134
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: /opt/otrs/scripts/DBUpdate-to-6.pl Line: 89
Not possible to complete migration, check previous messages for more information.
Code: Select all
Warning: /opt/otrs/Kernel/Config.pm erstellt als /opt/otrs/Kernel/Config.pm.rpmnew
[Wed Mar 21 17:20:54 2018] otrs.Console.pl: Malformed UTF-8 character (unexpected end of string) in substitution (s///) at /opt/otrs/Kernel/Config/Defaults.pm line 2012.
Rebuilding the system configuration...
Done.
[Wed Mar 21 17:21:04 2018] otrs.Console.pl: Malformed UTF-8 character (unexpected end of string) in substitution (s///) at /opt/otrs/Kernel/Config/Defaults.pm line 2012.
Deleting cache...
Done.
Next steps:
...
Looking forward to your comments