Re: Update to OTRS 6

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