###前提・実現したいこと
チケットの説明欄に入力できる文字量を増やしたい。
または、これ以上入力NGの理由を知りたい。
###発生している問題・エラーメッセージ
vmwareのCentOS7.3r1611上でredmineを設定
Webブラウザ上から新規チケット追加し、説明欄にテキストを入力するが
以下エラーによって、登録できない。
入力文字量は
説明欄に「あ」の文字を全角ひらがなとして、1行あたり50文字
合計431行と8文字でエラーとなる。7文字目までは入力可能だった。
エラー時文字数計:21558文字(全角1文字カウント、改行カウントせず)
Started GET "/projects/c/issues" for xxx.xxx.xxx.xxx at 2017-04-07 17:42:47 +0900 Processing by IssuesController#index as HTML Parameters: {"project_id"=>"c"} Current user: yyyyyyy (id=5) Rendered queries/_filters.html.erb (6.8ms) Rendered queries/_columns.html.erb (2.6ms) Rendered issues/_list.html.erb (365.5ms) Rendered issues/_sidebar.html.erb (2.3ms) Rendered issues/index.html.erb within layouts/base (391.1ms) Completed 200 OK in 466ms (Views: 376.1ms | ActiveRecord: 47.7ms) Started GET "/issues/63" for xxx.xxx.xxx.xxx at 2017-04-07 17:42:50 +0900 Processing by IssuesController#show as HTML Parameters: {"id"=>"63"} Current user: yyyyyyy (id=5) Rendered issues/_action_menu.html.erb (2.5ms) Rendered issue_relations/_form.html.erb (1.2ms) Rendered issues/_relations.html.erb (1.8ms) Rendered issues/_history.html.erb (23.8ms) Rendered issues/_action_menu.html.erb (2.2ms) Rendered issues/_form_custom_fields.html.erb (0.1ms) Rendered issues/_attributes.html.erb (10.9ms) Rendered issues/_form.html.erb (18.0ms) Rendered attachments/_form.html.erb (1.3ms) Rendered issues/_edit.html.erb (26.0ms) Rendered issues/_sidebar.html.erb (2.4ms) Rendered watchers/_watchers.html.erb (2.1ms) Rendered issues/show.html.erb within layouts/base (95.9ms) Completed 200 OK in 196ms (Views: 105.0ms | ActiveRecord: 21.9ms) Started PATCH "/issues/63" for xxx.xxx.xxx.xxx at 2017-04-07 17:43:01 +0900 Processing by IssuesController#update as HTML Parameters: {"utf8"=>"✓", "authenticity_token"=>"zzzzzzzzzz", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "project_id"=>"15", "tracker_id"=>"1", "subject"=>"文字数テスト", "description"=>" ■(ここに入力文字の「あ」が大量なので省略) ", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "parent_issue_id"=>"", "start_date"=>"2017-04-07", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "notes"=>"", "private_notes"=>"0", "lock_version"=>"10"}, "was_default_status"=>"1", "time_entry"=>{"hours"=>"", "activity_id"=>"", "comments"=>""}, "last_journal_id"=>"67", "commit"=>"送信", "prev_issue_id"=>"59", "issue_position"=>"36", "issue_count"=>"36", "id"=>"63"} Current user: yyyyyyy (id=5) Completed 500 Internal Server Error in 33ms (ActiveRecord: 6.8ms) ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE3\x81\x84' for column 'description' at row 1: UPDATE `issues` SET `issues`.`description` = ' ■(ここに入力文字の「あ」が大量なので省略) ', `issues`.`updated_on` = '2017-04-07 17:43:01', `issues`.`lock_version` = 11 WHERE `issues`.`id` = 63 AND `issues`.`lock_version` = 10): app/models/issue.rb:210:in `create_or_update' app/controllers/issues_controller.rb:527:in `block in save_issue_with_child_records' app/controllers/issues_controller.rb:515:in `save_issue_with_child_records' app/controllers/issues_controller.rb:184:in `update' lib/redmine/sudo_mode.rb:63:in `sudo_mode'
###試したこと
mariaDB使用、文字列はutf8
redmine設定時の文字コードも全てutf8で設定
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /xxx/charsets/ |
+--------------------------+----------------------------+
解決方法または、理由など分かりましたら、ご回答よろしくお願いします。
回答2件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2017/04/07 21:19
2017/04/08 01:21 編集
2017/04/09 04:37
2017/04/09 04:39