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 :

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: diego@gridshield.net mailto:diego@gridshield.net/

--------------------------------------------------------------------- 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

Hello Andrea, thanks and let’s continue this at https://bugs.otrs.org/show_bug.cgi?id=13221. 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 13.10.2017 um 11:24 schrieb Andrea Iannucci :

Hi Martin,

Ticket raised on OTRS Bug site.

It's actually strange that utf8mb4 is not supported but it's the "workaround" that fixed the first issue

Regarding your question, how can I check that? I have some modules installed which can somehow be the cause, basically all the modules available on otrs website.

My understanding is that those modules are now part of OTRS6, so it may be something on that "upgrade" process?

Thanks Best regards

On 13/10/2017 07:19, Martin Gruner wrote:

...

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 :

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: diego@gridshield.net mailto:diego@gridshield.net/

--------------------------------------------------------------------- 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

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