Project

General

Profile

Actions
Copy link

Defect #27406

closed

Internal Server Error while posting smile in issue's description

Added by Pavel Potcheptsov about 7 years ago. Updated over 6 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:
3.4.3

Description

It took a time to realize why issue's creation throw Internal Error.
It turned out that text was actually copy-pasted to description from somewhere and it contains smile.
I can't provide full text because of privacy but here is relevant error from log:

Processing by IssuesController#create as HTML
..skipped..
Completed 500 Internal Server Error in 130ms (ActiveRecord: 67.5ms)
ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\x8A\x0D\x0A...' for column 'description' at row 1:

Relevant article to fix issue.

Files

Screenshot-2017-11-8 Search - Redmine.png (60.4 KB) Screenshot-2017-11-8 Search - Redmine.png Pavel Potcheptsov, 2017-11-08 14:28

Related issues

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

Actions
Actions
Copy link

Also available in: Atom PDF