Redmine

Some errors should be logged in log/production.log file. Please show the errors.

Following are log

Started POST "/projects/predict-win/issues" for 103.82.125.218 at 2018-04-29 13:53:33 +0530
Processing by IssuesController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "tracker_id"=>"4", "subject"=>"कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"8"=>""}}, "was_default_status"=>"1", "commit"=>"Create", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
Completed 500 Internal Server Error in 50ms (ActiveRecord: 10.4ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE0\xA4\x95\xE0\xA5\x89...' 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 (27, 5, '2018-04-29', 4, 1, 'कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना', '', 2, '2018-04-29 13:53:33', '2018-04-29 13:53:33', 0)):
  app/models/issue.rb:182:in `create_or_update'
  app/controllers/issues_controller.rb:146:in `create'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Started POST "/projects/predict-win/issues" for 103.82.125.218 at 2018-04-29 13:53:38 +0530
Processing by IssuesController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "tracker_id"=>"4", "subject"=>"कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"8"=>""}}, "was_default_status"=>"1", "commit"=>"Create", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
Completed 500 Internal Server Error in 48ms (ActiveRecord: 10.3ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE0\xA4\x95\xE0\xA5\x89...' 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 (27, 5, '2018-04-29', 4, 1, 'कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना', '', 2, '2018-04-29 13:53:38', '2018-04-29 13:53:38', 0)):
  app/models/issue.rb:182:in `create_or_update'
  app/controllers/issues_controller.rb:146:in `create'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Started POST "/projects/predict-win/issues/new.js" for 103.82.125.218 at 2018-04-29 13:53:46 +0530
Processing by IssuesController#new as JS
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"issue_tracker_id", "issue"=>{"is_private"=>"0", "tracker_id"=>"1", "subject"=>"कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"8"=>""}}, "was_default_status"=>"1", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
  Rendered issues/_form_custom_fields.html.erb (0.1ms)
  Rendered issues/_attributes.html.erb (24.9ms)
  Rendered issues/_form.html.erb (31.5ms)
  Rendered issues/new.js.erb (32.5ms)
Completed 200 OK in 68ms (Views: 27.7ms | ActiveRecord: 15.4ms)
Started POST "/projects/predict-win/issues" for 103.82.125.218 at 2018-04-29 13:53:48 +0530
Processing by IssuesController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "tracker_id"=>"1", "subject"=>"कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0"}, "was_default_status"=>"1", "commit"=>"Create", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
Completed 500 Internal Server Error in 38ms (ActiveRecord: 8.7ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE0\xA4\x95\xE0\xA5\x89...' 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 (27, 5, '2018-04-29', 1, 1, 'कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना', '', 2, '2018-04-29 13:53:48', '2018-04-29 13:53:48', 0)):
  app/models/issue.rb:182:in `create_or_update'
  app/controllers/issues_controller.rb:146:in `create'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Started POST "/projects/predict-win/issues/new.js" for 103.82.125.218 at 2018-04-29 13:53:56 +0530
Processing by IssuesController#new as JS
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"issue_tracker_id", "issue"=>{"is_private"=>"0", "tracker_id"=>"3", "subject"=>"", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0", "custom_field_values"=>{"8"=>""}}, "was_default_status"=>"1", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
  Rendered issues/_form_custom_fields.html.erb (0.1ms)
  Rendered issues/_attributes.html.erb (19.5ms)
  Rendered issues/_form.html.erb (24.9ms)
  Rendered issues/new.js.erb (26.0ms)
Completed 200 OK in 58ms (Views: 22.7ms | ActiveRecord: 12.2ms)
Started POST "/projects/predict-win/issues" for 103.82.125.218 at 2018-04-29 13:54:01 +0530
Processing by IssuesController#create as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uAvWJs71hJmPj+OMqOlDyyGDYaab+t7YwMUwyDVE8/33HFZJ/kwCHpXx31YaRgbuL3u4rNqGVwN9nGIAIMTXtw==", "form_update_triggered_by"=>"", "issue"=>{"is_private"=>"0", "tracker_id"=>"3", "subject"=>"Test - कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना", "description"=>"", "status_id"=>"1", "priority_id"=>"2", "assigned_to_id"=>"", "fixed_version_id"=>"", "parent_issue_id"=>"", "start_date"=>"2018-04-29", "due_date"=>"", "estimated_hours"=>"", "done_ratio"=>"0"}, "was_default_status"=>"1", "commit"=>"Create", "project_id"=>"predict-win"}
  Current user: ankit.singh (id=5)
Completed 500 Internal Server Error in 43ms (ActiveRecord: 10.4ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xE0\xA4\x95\xE0\xA5\x89...' 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 (27, 5, '2018-04-29', 3, 1, 'Test - कॉमनवेलॠथ गेमॠस : बॉकॠसिंग में गोलॠड जीतने वाली पहली भारतीय महिला बनीं मैरीकॉम, 45-48 किगॠरा में जीता सोना', '', 2, '2018-04-29 13:54:01', '2018-04-29 13:54:01', 0)):
  app/models/issue.rb:182:in `create_or_update'
  app/controllers/issues_controller.rb:146:in `create'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Ankit Singh wrote:

Following are log

[...]

Thank you, could you attach the Hindi text that you tried to write in the issue? Please attach a text file instead of pasting the text.

Ankit Singh wrote:

It's not any specific text. If I enter any Hindi word then its showing same error. For your kind information I'm attaching some example

I could enter the Hindi text on a demo site of Redmine. The site uses MySQL as a backend database. Please see the following URL.

https://my.redmine.jp/demo/issues/19417

I think that the cause of the problem is that the encoding setting of your MySQL database is not UTF-8.

Go MAEDA wrote:

Ankit Singh wrote:

It's not any specific text. If I enter any Hindi word then its showing same error. For your kind information I'm attaching some example

I could enter the Hindi text on a demo site of Redmine. The site uses MySQL as a backend database. Please see the following URL.

https://my.redmine.jp/demo/issues/19417

I think that the cause of the problem is that the encoding setting of your MySQL database is not UTF-8.

How can I fix it?
Reinstall Redmine to separate server to create a new database with encoding setting UTF-8
or
change encoding setting of your MySQL database to UTF- in current database?
Please help.