Defect #27406

Internal Server Error while posting smile in issue's description

Added by Pavel Potcheptsov 9 days ago. Updated 9 days ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
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.

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

History

#1 Updated by Toshi MARUYAMA 9 days 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.

#2 Updated by Pavel Potcheptsov 9 days 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?

#3 Updated by Toshi MARUYAMA 9 days ago

Pavel Potcheptsov wrote:

but you aren't going to commit such changes in the code?

It is not related with Redmine source code.

Also available in: Atom PDF