We have an old version 5 machine with OTRS and the KIX addon installed. We wanted to migrate to a new server and put on version 6 (Kix is not supported on that version) but retain the ticket, sla and agent data.
I found a module called DB clone, which only seems to work on a blank db? I really want to import the data into the existing version 6 DB.
Anyway, even creating a new DB on the new version 6 server and trying to export the data there I got the error below.
Any ideas on the points above or the error please?
Thanks!
Code: Select all
ERROR: OTRS-otrs.Console.pl-Maint::Database::Clone-01 Perl: 5.10.1 OS: linux Time: Thu Oct 11 15:08:42 2018
Message: Table 'otrs-clone.change_freekey' doesn't exist, SQL: '
SELECT COUNT(*)
FROM change_freekey'
Traceback (15802):
Module: Kernel::System::CloneDB::Driver::Base::RowCount Line: 171
Module: Kernel::System::CloneDB::Driver::Base::SanityChecks Line: 125
Module: Kernel::System::CloneDB::Backend::SanityChecks Line: 269
Module: Kernel::System::Console::Command::Maint::Database::Clone::Run Line: 100
Module: (eval) Line: 460
Module: Kernel::System::Console::BaseCommand::Execute Line: 454
Module: Kernel::System::Console::InterfaceConsole::Run Line: 86
Module: bin/otrs.Console.pl Line: 38
Error: Died at /opt/otrs/Kernel/System/CloneDB/Driver/Base.pm line 171.