Hi,
After upgrading Redmine from 2.5.2 to 3.4 I discovered, a critical problem for me. After entering polish letter in any field in redmine I have Internal error.
In log there is error with mysql
Completed 500 Internal Server Error in 94ms (ActiveRecord: 38.6ms)
ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xC4\x99\xC4\x85' for column 'description' at row 1: INSERT INTO `issues` (`project_id`, `author_id`, `tracker_id`, `status_id`, `subject`, `description`, `priority_id`, `updated_on`, `created_on`, `lock_version`) VALUES (75, 1, 2, 1, 'asdas', 'ęą', 2, '2017-10-19 07:32:45', '2017-10-19 07:32:45', 0)):
app/models/issue.rb:212:in `create_or_update'
app/controllers/issues_controller.rb:129:in `create'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
My enviroment:
- Redmine version 3.4 (upgraded from 2.5.2)
- Ruby 2.4.0 from RVM
- Ruby Passanger 5.1.10
- HTTPD 2.4.6-67.el7.centos.5
- CentOS 7
- mysql-community-server 5.5.57-2.el7
I have checked if the same problem is on old mysql database 5.1 and upgraded redmine to 3.4 and the problem is the same.
I have done upgrade with steps described in RedmineUpgrade and prepared database with RedmineInstall
After importing database from old redmine (mysql 5.1) to new server (mysql 5.5) I have done command 'mysql_update' to upgrade all tables.
Did anyone have a similar problem?
If you need any other informations just ask and I will provide them.
Internal Error After entering polish characters