Hi Diego,
Not really a dev environment but my OTRS istance never went live and I
have backups :)
I managed to pass that bit just now, apparently I had to convert
everything in the DB from utf8 to utf8mk4 and now I am facing a new
stopping error:
Step 25 of 33: Post changes on article related tables ...
[Thu Oct 12 16:45:01 2017] DBUpdate-to-6.pl: DBD::mysql::db do failed:
Cannot delete or update a parent row: a foreign key constraint fails at
/home/otrs/domains/support.crazynetwork.it/private_html/Kernel/System/DB.pm
line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-00 Perl: 5.16.3 OS:
linux Time: Thu Oct 12 16:45:01 2017
Message: Cannot delete or update a parent row: a foreign key
constraint fails, SQL: 'DROP TABLE IF EXISTS article_type'
Traceback (9504):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 349
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 297
Module:
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_DropArticleTypeTable
Line: 445
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run
Line: 71
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./DBUpdate-to-6.pl Line: 82
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-00 Perl: 5.16.3 OS:
linux Time: Thu Oct 12 16:45:01 2017
Message: Error during execution of 'DROP TABLE IF EXISTS article_type'!
Traceback (9504):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 352
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 297
Module:
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_DropArticleTypeTable
Line: 445
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run
Line: 71
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: ./DBUpdate-to-6.pl Line: 82
I know is not table, but I wanted to look what's new and still an
"external tester" can always be useful to devs and others, so for the
first bit the issue was the charset, maybe the update script should
manage to change it.
Regarding the latest error I am receiving, I have tryed to disable the
foreign key check but it didn't actually help.
Any idea? :)
On 12/10/2017 15:49, Diego Chacón wrote:
OTRS 6 is not yet a stable version
I assume (hopefully) that you are testing it in a development environment
--
/Diego Chacón Rojas/
/* E-mail: [email protected] <mailto:[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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
