Hello, I am running a migration process of an OTRS 5.0.30 to OTRS 6.0.12 on CentOS 7 with MariaDB and during DB-Migrate-to-6 execution I get the following error. The first time I ran, it told me there were some orphaned articles and some orphaned tags and asked to delete them.
I tried reloading the original Database and those orphaned messages disappeared but It keeps giving the error. Step 29 of 42: Post changes on article related tables ... [Fri Nov 2 21:07:29 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at /opt/otrs/Kernel/System/DB.pm line 470. ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov 2 21:07:29 2018 Message: Cannot add or update a child row: a foreign key constraint fails (`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id` FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: 'EXECUTE FKStatement' Traceback (123074): Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394 Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286 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: 87 ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux Time: Fri Nov 2 21:07:29 2018 Message: Error during execution of 'EXECUTE FKStatement'! Traceback (123074): Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397 Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342 Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable Line: 286 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: 87 Not possible to complete migration, check previous messages for more information. -- *Alvaro Cordero RetanaConsultor de Tecnologias* *Tel: 22585757 ext 123* *Email:* [email protected]
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
