having an very odd issue and caused some years ago with the encoding.
on one of the last major updates maybe from 4 to 5 I have upgraded the database too. And with this I have switched from latin to utb8mb4 encoding.
Code: Select all
sudo -u otrs scripts/DBUpdate-to-6.pl Migration started ... Checking requirements ... Requirement check for: Check framework version ... Requirement check for: Check required Perl version ... Requirement check for: Check required database version ... Requirement check for: Check database charset ... Error: The setting character_set_database is set to 'utf8mb4'. Error: This character set is not yet supported, please see https://bugs.otrs.org/show_bug.cgi?id=12361. Error: Please convert your database to the character set 'utf8'.
Was a bunch of work the time. I decided to use utf8mb4, since it was the more suggested encoding.
Now I am facing the error on upgrade, that the mariaDB recommended encoding utf8mb4 shall not be used.
And thus confused.
Is it also a requirement for znuny 6.1/6.2 and ongoing to use the outdated encoding? So maybe I could skip the encoding change with upgrade to 6.0?
Also really curious
is my information wrong, that it is recommended since 2010 to use utfbmb4 since mysql developers have forgotten that 3 bytes are not enough for full UTF-8 support?
if my info is right, why it is the upgrade limited to outdated utf8?
What is recommended here in my case?
Can I somehow circumvent the "downgrade" of utf8mb4 to utf8?
And if so, is it for later znuny version also okay?