Project

General

Profile

Actions

Defect #34810

open

SQL Error with UTF8 character greater or equals

Added by Florent H. about 3 years ago. Updated almost 3 years ago.

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

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

I am currently getting a fatal error using this character (greater or equals) editing a wiki page

https://fr.wiktionary.org/wiki/%E2%89%A5

Error

app/models/wiki_page.rb:249:in `block in save_with_content'
app/models/wiki_page.rb:245:in `save_with_content'
app/controllers/wiki_controller.rb:180:in `update'
lib/redmine/sudo_mode.rb:65:in `sudo_mode'
Started PUT "/projects/site-web/wiki/Breakpoints" for 92.167.55.166 at 2021-02-26 17:46:08 +0000
Processing by WikiController#update as HTML
  Parameters: {"utf8"=>"<E2><9C><93>", "authenticity_token"=>"XXX", "content"=>{"version"=>"1", "text"=>"h1. Breakpoints\r\n\r\nNous utilisons bootstrap 5 avec ses breakpoints officiels\r\n\r\nhttps://getbootstrap.com/docs/5.0/layout/breakpoints/\r\n\r\n|_.Breakpoint|_.Class infix|_.Dimensions|_.Appareil|\r\n|X-Small|None|<576px|Mobile|\r\n|Small|sm|<E2><89><A5>576px|Mobile|\r\n|Medium|md|<E2><89><A5>768px|Mobile|\r\n|Large|lg|<E2><89><A5>992px|Ordinateur|\r\n|Extra large|xl|<E2><89><A5>1200px|Ordinateur|\r\n|Extra extra large|xxl|<E2><89><A5>1400px|Ordinateur|\r\n", "comments"=>""}, "wiki_page"=>{"parent_id"=>"25"}, "commit"=>"Sauvegarder", "project_id"=>"site-web", "id"=>"Breakpoints"}
  Current user: Me (id=1)
Completed 500 Internal Server Error in 257ms (ActiveRecord: 249.6ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE2\x89\xA5576...' for column `redmine`.`wiki_contents`.`text` at row 1: INSERT INTO `wiki_contents` (`page_id`, `author_id`, `text`, `updated_on`, `version`) VALUES (27, 1, 'h1. Breakpoints\r\n\r\nNous utilisons bootstrap 5 avec ses breakpoints officiels\r\n\r\nhttps://getbootstrap.com/docs/5.0/layout/breakpoints/\r\n\r\n|_.Breakpoint|_.Class infix|_.Dimensions|_.Appareil|\r\n|X-Small|None|<576px|Mobile|\r\n|Small|sm|<E2><89><A5>576px|Mobile|\r\n|Medium|md|<E2><89><A5>768px|Mobile|\r\n|Large|lg|<E2><89><A5>992px|Ordinateur|\r\n|Extra large|xl|<E2><89><A5>1200px|Ordinateur|\r\n|Extra extra large|xxl|<E2><89><A5>1400px|Ordinateur|\r\n', '2021-02-26 17:46:08', 1)):

Here is my redmine's environment

Environment:
  Redmine version                4.1.1.stable
  Ruby version                   2.6.3-p62 (2019-04-16) [x86_64-linux]
  Rails version                  5.2.4.2
  Environment                    production
  Database adapter               Mysql2
  Mailer queue                   ActiveJob::QueueAdapters::AsyncAdapter
  Mailer delivery                smtp
SCM:
  Git                            2.25.1
  Filesystem                     
Redmine plugins:
  no plugin installed

Actions

Also available in: Atom PDF