Project

General

Profile

Actions

Defect #27803

closed

Can't post a smiley face in issues description

Added by Jēkabs Jānis Kalniņš about 7 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

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

Related to Redmine - Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQLClosedGo MAEDA

Actions
Actions #2

Updated by Jēkabs Jānis Kalniņš about 7 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

Actions #3

Updated by Toshi MARUYAMA about 7 years ago

  • Category deleted (Issues)
  • Status changed from New to Closed
  • Resolution set to Invalid

Duplicate with #27406 and many others.

Actions #5

Updated by Marius BĂLTEANU over 5 years ago

  • Related to Feature #31921: Changes to properly support 4 byte characters (emoji) when database is MySQL added
Actions

Also available in: Atom PDF