search

znuny / Znuny

Znuny/Znuny LTS is a fork of the ((OTRS)) Community Edition, one of the most flexible web-based ticketing systems used for Customer Service, Help Desk, IT Service Management.
https://www.znuny.org
GNU General Public License v3.0
333 stars 82 forks source link

Bug - Snippets and Pictures/Smileys #504

Closed BurtGummer closed 6 months ago

BurtGummer commented 8 months ago

Hello,

I try the Snippet-Function on Znuny 6.5.4 and have 2 problems:

image

  1. If I enter smileys/emoji with WIN + . the smileys will not be saved. After saving there are the black ? symbols.
  2. Same problem with a picture, If i save I get the error from the screenshot
KaldungJr commented 8 months ago

Hello,

How large is the image file you tried to add to the snippet? What kind of database are you using for your system?

BurtGummer commented 8 months ago

Hello @KaldungJr,

the image has only some KB. We use Debian 11 with the Mariadb version 10.5.21. The thing is, we can use bigger pictures and smileys in the other text fields from znuny.

KaldungJr commented 8 months ago

Hello @BurtGummer,

The reason emojis can't be saved is because the default database character set of Znuny does not support utf8mb4. As to the image not being saved, you said it was only a couple of KB which might be too large of an image file anyways since the default size for templates is 64 KB.

Workaround: You can increase the column size with this SQL command ALTER TABLE standard_template MODIFY COLUMN text MEDIUMTEXT;

rkaldung commented 8 months ago

@BurtGummer Both issues are on our list, but the character set change won't come quickly. The column size is already addressed to development.

rkaldung commented 8 months ago

Internal Issue 773

rkaldung commented 6 months ago

Solved in Znuny LTS 6.5.5 with commit 901f10f3f1bfa1d96a43d122f6b4945d2e3c2ba7 and in Znuny 7.0.14 with 4f381e1689b174b64d2172373365ca62f04e70bb