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 > <andrea.iannu...@firstclarity.com>: > > 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 >>> <andrea.iannu...@firstclarity.com>: >>> >>> 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: di...@gridshield.net <mailto:di...@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
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