Re: Update to OTRS 6

Hello Andrea,

thanks for the early testing feedback. Can I encourage you to raise issues at https://bugs.otrs.org/ for your findings please?

Unfortunately, utf8mb4 is not supported atm, because this reduces the possible length of indexes even more than with utf8. Please see https://bugs.otrs.org/show_bug.cgi?id=12361.

I’m not sure if this is related to the foreign key issue or not. Are there any further tables depending on article_type?

Best regards,

Martin Gruner
Team Lead R&D

OTRS AG
Bahnhofplatz 1a
94315 Straubing

T: +49 (0)6172 681988 0
F: +49 (0)9421 56818 18
I:  www.otrs.com/

Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065
Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel

____________________________________________________

OTRS Business Solution™ 5s – Organisation.  Sicherheit.  Kommunikation.  Struktur. – Flexible Lösungen für Erfolg im Unternehmen
Link: https://www.otrs.com/?lang=de&utm_id=1032


Mehr Infos:
+ Lösungen: https://www.otrs.com/produkte/?lang=de&utm_id=1033
+ Success Stories: https://www.otrs.com/kunden/success-stories/?lang=de&utm_id=1034
+ Trainings: https://www.otrs.com/public-otrs-trainings/?lang=de&utm_id=1035

> Am 12.10.2017 um 16:54 schrieb Andrea Iannucci <[email protected]>:
> 
> 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

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

-----BEGIN PGP SIGNATURE-----

iF0EARECAB0WIQQe3DLz00yyMhZlXYmMN+UHu0WpxwUCWeBa8AAKCRCMN+UHu0Wp
x5CiAJwOBYfuwY8k350Vjyj1ELZ3KDywvgCfVlG47uuEWvqyi/mlPTgpUiYzMzA=
=zj0P
-----END PGP SIGNATURE-----