Project

General

Profile

Actions

Defect #19305

closed

settings: incompatible character encodings: UTF-8 and ASCII-8BIT: yaml generated on ruby 1.8

Added by Gena Makhomed over 9 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
High
Category:
Database
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

regression detected:

redmine 2.5.2 works fine, after upgrade to version 2.6.2 - can't enter to /settings,
get 500 error in browser and such record in DEBUG production.log:

ActionView::Template::Error (incompatible character encodings: UTF-8 and ASCII-8BIT):
100: ) >
101: </td>
102: <td>
103: <
= text_field_tag("settings[commit_update_keywords][keywords][]",
104: rule['keywords'], :size => 30) %>
105: </td>
106: <td>

bug cause:

this database record:

INSERT INTO `settings` VALUES (68,'commit_update_keywords','--- \n- keywords: !binary |\n    Zml4ZXMsY2xvc2VzLNC40YHQv9GA0LDQstC70LXQvdC+LNCz0L7RgtC+0LLQ\n
  vizRgdC00LXQu9Cw0L3QvixmaXhlZA==\n\n  done_ratio: \"100\"\n  status_id: \"5\"\n','2014-04-02 22:32:32');

- this database record works fine in redmine 2.5.2 and cause 500 internal server error in redmine 2.6.2.

how to make workaround:

1.

delete from settings where name='commit_update_keywords';

2.
restart redmine ("systemctl restart passenger@redmine" or something like this)

3.
enter into /settings url and recreate this record manually from redmine interface,
and now - all works fine, no more 500 errors.

after manual fix / workaround database record for commit_update_keywords now looks like this:

INSERT INTO `settings` VALUES (75,'commit_update_keywords','---\n- status_id: \'5\'\n  done_ratio: \'100\'\n  keywords: fixes,closes,исправлено,готово,сделано,fixed\n','2015-03-08 15:16:28');

P.S.

$ ruby script/about

Environment:
  Redmine version                2.6.2.stable
  Ruby version                   2.0.0-p353 (2013-11-22) [x86_64-linux]
  Rails version                  3.2.21
  Environment                    production
  Database adapter               Mysql2
SCM:
  Subversion                     1.7.14
  Git                            1.8.3.1
  Filesystem
Redmine plugins:
  redmine_agile                  1.3.8
  redmine_contacts               3.4.4
  redmine_issue_favicon          0.0.1
  redmine_people                 0.1.8

Related issues

Related to Redmine - Defect #13617: Internal error on custum queries after Upgrade 2.2 -> 2.3Closed

Actions
Actions

Also available in: Atom PDF