Admins

Soumettre ou ?

Ha oui, sur agir. :)

A priori c'est ce bug : http://www.redmine.org/issues/5793

Il faut tester la migration de la base vers utf8.

Résolu. cf #2627.

Le script de migration :

root@agir:~# cat ./latin1_to_utf8.sh
# dump
mysqldump redmine > redmine.sql

# convert each table
for table in `grep '^CREATE TABLE' redmine.sql | awk '{print $3}'`
do
    mysql redmine -e "ALTER TABLE $table CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;" 
done

Refait avec le script:

# dump
mysqldump redmine > redmine.sql

# convert each table
for table in `grep '^CREATE TABLE' redmine.sql | awk '{print $3}'`
do
    mysql redmine -e "ALTER TABLE $table CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;" 
done

arf ça suffit pas

Started POST "/projects/admins/issues" for 62.212.96.45 at 2018-01-29 14:08:36 +0100
Processing by IssuesController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"y/qLeOmBtvP73T8/ASPrs7BiXHw+6cQ9g1cXNdzBpT8xh5iScaIedQEeiDq+Ncx4nqtDMfGT8BhEoiN5gUxlTQ==", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "tracker_id"=>"2", "subject"=>" THE EMOTICON ", "description"=>"", "status_id"=>"1", "priority_id"=>"4", "assigned_to_id"=>"", "category_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-01-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"6"=>"2 Facile"}}, "was_default_status"=>"1", "commit"=>"Créer", "project_id"=>"admins"}
  Current user: fpoulain (id=5)
Completed 500 Internal Server Error in 51ms (ActiveRecord: 31.1ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xF0\x9F\x98\xB8' for column 'subject' at row 1: INSERT INTO `issues` (`project_id`, `author_id`, `start_date`, `tracker_id`, `status_id`, `subject`, `description`, `priority_id`, `updated_on`, `created_on`, `lock_version`) VALUES (26, 5, '2018-01-29', 2, 1, 'THE EMOTICON', '', 4, '2018-01-29 14:08:36', '2018-01-29 14:08:36', 0)):
  app/models/issue.rb:210:in `create_or_update'
  app/controllers/issues_controller.rb:140:in `create'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

😸

J'ai ajouté :

# mysql redmine
MariaDB [redmine]> ALTER DATABASE redmine CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Query OK, 1 row affected (0.00 sec)

root@agir:/etc# git diff
diff --git a/redmine/default/database.yml b/redmine/default/database.yml
index 671cff3..06c5531 100644
--- a/redmine/default/database.yml
+++ b/redmine/default/database.yml
@@ -5,4 +5,4 @@ production:
   port: 3306
   username: redmine
   password: peey2Oov
-  encoding: utf8
+  encoding: utf8mb4