Internal Error when copy and past text with smilies
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
Redmine version 4.1.1.stable
Ruby version 2.5.5-p157 (2019-03-15) [x86_64-linux-gnu]
Rails version 22.214.171.124
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
smiley.txt - Text with smiey causing truncation or internal error (136 Bytes)
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.
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 ...
thanks my issue has been fixed.