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
signature.asc
Description: Message signed with OpenPGP using GPGMail
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
