Only approximately 16,000 characters are currently permitted in fields f_field1 - f_field6, as the column is formatted as "text".

[StefanRother-OTOBO]

Only approximately 16,000 characters are currently permitted in fields f_field1 - f_field6, as the column is formatted as "text".

Please change the columns to "mediumtext" (mariadb) for new systems, and if possible also for existing one.

As workaround you can execute:

alter table faq_item modify f_field1 MEDIUMTEXT;
alter table faq_item modify f_field2 MEDIUMTEXT;
alter table faq_item modify f_field3 MEDIUMTEXT;
alter table faq_item modify f_field4 MEDIUMTEXT;
alter table faq_item modify f_field5 MEDIUMTEXT;
alter table faq_item modify f_field6 MEDIUMTEXT;

Thats possible without any problems...

Thanks!

[stefanhaerter]

Putting this in the OTOBO Issues project for planning.

[stefanhaerter]

Leaving this as explanation: To achieve this, the size needs to be 65536 or bigger.

https://github.com/RotherOSS/otobo/blob/1199ba77a5b99b5b6436a0503288a3f228ef8ce4/Kernel/System/DB/mysql.pm#L863-L865

[stefanhaerter]

Pushed, closing the issue.

[stefanhaerter]

Commit 0422012 is erroneously labeled 'Issue #56', but belongs to this issue.