Actions
Defect #27406
closed
Internal Server Error while posting smile in issue's description
Status:
Closed
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:
0%
Estimated time:
Resolution:
Invalid
Affected version:
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
Related issues
Updated by Toshi MARUYAMA about 7 years ago
- Category deleted (
Issues) - Status changed from New to Closed
- Resolution set to Invalid
This is FAQ.
Search "MySQL UTF-8 4bytes" on this site or google.
Updated by Pavel Potcheptsov about 7 years ago
Unfortunately search on redmine didn't return any answer.
Am I right that you are suggesting to change character set in database, etc but you aren't going to commit such changes in the code?
Updated by Toshi MARUYAMA about 7 years ago
Pavel Potcheptsov wrote:
but you aren't going to commit such changes in the code?
It is not related with Redmine source code.
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