Project

General

Profile

Actions

Defect #24242

closed

Adding comments to ticket returns internal server error

Added by Piyush Jain about 8 years ago. Updated 3 months ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

While adding comments to the ticket am getting internal server error:

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x91\x8D\x0D\x0A...' for column 'notes' at row 1: INSERT INTO `journals`

I tired changing the charset from utf8 to utf8mb4 for journals table but it doesn't seems to help.

Can anyone suggest a walk through for this issue.

My Environment

Environment:
  Redmine version                3.3.0.stable
  Ruby version                   2.3.1-p112 (2016-04-26) [x86_64-linux]
  Rails version                  4.2.6
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.7.14
  Git                            1.8.3.1
  Filesystem                     
Redmine plugins:
  issue_charts                   1.3.0
  periodictask                   3.1.1
  redmine_checklists             3.1.3
  redmine_email_fetcher          0.3.1
  redmine_helpdesk               0.0.15
  redmine_issue_history          1.0.0
  redmine_omniauth_google        0.0.1
  simple_author_change           0.1.2


Related issues

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

Actions
Actions #1

Updated by Marius BĂLTEANU about 8 years ago

Please try without plugins.

Actions #2

Updated by Toshi MARUYAMA about 8 years ago

  • Status changed from New to Needs feedback

Why not post full log?

Actions #3

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 #4

Updated by Go MAEDA 3 months ago

The issue is caused by attempting to insert a 4-byte UTF-8 character, specifically "\xF0\x9F\x91\x8D" (THUMBS UP SIGN), into a MySQL column that uses the utf8 encoding, which only supports 3-byte characters.

To resolve this, the database, table, and column character set should be updated to utf8mb4, which supports 4-byte UTF-8 characters. Additionally, ensure that both MySQL's configuration (my.cnf) and Redmine's config/database.yml are configured to use utf8mb4 encoding.

Actions #5

Updated by Go MAEDA 3 months ago

  • Status changed from Needs feedback to Closed
  • Resolution set to Invalid
Actions

Also available in: Atom PDF