Defect #27803: Can't post a smiley face in issues description - Redmine

Defect #27803

Can't post a smiley face in issues description

Added by Jēkabs Jānis Kalniņš almost 4 years ago. Updated almost 4 years ago.

Status:

Closed

Start date:

Priority:

Normal

Due date:

Assignee:

% Done:

Category:

Target version:

Resolution:

Invalid

Affected version:

3.3.2

Description

Completed 500 Internal Server Error in 102ms (ActiveRecord: 60.4ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x8A' for column 
'description' at row 1: INSERT INTO `issues` (`project_id`, `author_id`, `start_date`, `tracker_id`, 
`status_id`, `assigned_to_id`, `subject`, `description`, `priority_id`, `due_date`, `updated_on`, `created_on`,
 `lock_version`) VALUES (261, 210, '2017-12-15', 3, 1, 210, 'Labojumi lapā', ':blush:', 4, '2017-12-16', '2017-12-15 10:51:08', '2017-12-15 10:51:08', 0)):
 app/models/issue.rb:210:in `create_or_update'
 app/controllers/issues_controller.rb:140:in `create'
 lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Environment:
Redmine version 3.3.2.stable
Ruby version 2.3.3-p222 (2016-11-21) [x86_64-linux-gnu]
Rails version 4.2.7.1
Environment production
Database adapter Mysql2
SCM:
Git 2.11.0
Filesystem
Redmine plugins:
add_link 0.0.1
easy_gantt 2016-RC1.0
periodictask 3.1.1
redmine_custom_css 0.1.4
redmine_improved_searchbox2 0.0.3
redmine_lightbox2 0.3.1
redmine_tagging 0.1.5
redmine_theme_changer 0.2.0
redmine_xlsx_format_issue_exporter 0.1.3

Related issues

History

#2 Updated by Jēkabs Jānis Kalniņš almost 4 years ago

This one doesn't work. To test you can try and paste it as a comment here. It doesn't save it.
https://apps.timwhitlock.info/unicode/inspect?s=%F0%9F%98%8A