Project

General

Profile

Internal Error when copy and past text with smilies

Added by Knut Krüger almost 3 years ago

Pasted Text containing smilies will cause an internal error

If if this ticket will be stored with this smiley: > < here was the smiley

- see file appendix -- at this redmine the text seems to be truncated after the smily without the internal error

Environment:
Redmine version 4.1.1.stable
Ruby version 2.5.5-p157 (2019-03-15) [x86_64-linux-gnu]
Rails version 5.2.4.2
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Git 2.20.1
Filesystem
Redmine plugins:
redmine_scheduling_poll 2.3.0

smiley.txt (136 Bytes) smiley.txt Text with smiey causing truncation or internal error

Replies (4)

RE: Internal Error when copy and past text with smilies - Added by Guillermo ML almost 3 years ago

We have had the same issues, and I though that those issues were solved from 4.1.0 onwards but after migrating from 3.4.4 to 4.1.1 we had the same errors.

Then I found the same link posted above and it clearly says:

- Adds to the database.yml.example the required encoding and collation, including a note to inform users that are safe only for new installations.

In #31921#note-39 there is a link to a "How to" convert existing databases to a charset that admits emojis. We still didn't applied the change so I don't have experience about it.

RE: Internal Error when copy and past text with smilies - Added by Knut Krüger almost 3 years ago

To prevent Internal Errors or cutting the text could be fixed before sending to the database or causing internal errors.
Check the database character set and put a filter in front before sending it to functions or databases which are not able to deal with extended character codes.

Independend of the configuration of the database ...

    (1-4/4)