Re: [otrs] Update to OTRS 6

Andrea Iannucci Fri, 13 Oct 2017 02:24:52 -0700

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 modulesinstalled which can somehow be the cause, basically all the modulesavailable on otrs website.

My understanding is that those modules are now part of OTRS6, so it maybe 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 
<[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


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

Re: [otrs] Update to OTRS 6

Reply via email to