Redmine

What's the contents of the production.log file relating to this error ?

Hi Massip,

Production Log details are as follows:

Processing IssuesController#update (for 172.29.240.69 at 2011-06-15 14:47:51) [PUT]
Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Submit", "action"=>"update", "_method"=>"put", "authenticity_token"=>"fkwsNkqQfHVHl1vEp78wfwF4nO08XGZBqtviR/33/Cg=", "id"=>"9", "notes"=>"", "controller"=>"issues", "issue"=>{"start_date"=>"2010-12-22", "parent_issue_id"=>"", "estimated_hours"=>"", "lock_version"=>"3", "priority_id"=>"4", "subject"=>"Re-work Schedule Feature", "fixed_version_id"=>"2", "description"=>"", "tracker_id"=>"2", "done_ratio"=>"80", "due_date"=>"", "assigned_to_id"=>"5", "status_id"=>"5", "custom_field_values"=>{"3"=>"BPC=4Bitã®å ´åˆã€DLScreen情報用メモリ確ä¿ãŒå¿…è¦ã‹ç¢ºèªã™ã‚‹å‡¦ç†ãŒæŠœã‘ã¦ã„る箇所ãŒã‚ã‚Šã€ãã®ãŸã‚無駄ãªãƒ¡ãƒ¢ãƒªç¢ºä¿ã‚’大é‡ã«è¡Œã£ã¦ã„ã¾ã—ãŸã€‚ \r\nã“ã‚Œã«ã‚ˆã‚Šã€æŒ‡æ‘˜ãƒ‡ãƒ¼ã‚¿å‡ºåŠ›æ™‚ã¯ãƒ¡ãƒ¢ãƒªç¢ºä¿é‡ãŒé™ç•Œã«é”ã—ã€PCL6解æžä¸­ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ã‚ˆã‚‹å†…部エラーãŒç™ºç”Ÿã—ã¦ã„ã¾ã—ãŸã€‚\r\n"}}, "attachments"=>{"1"=>{"description"=>""}}}

ActiveRecord::StatementInvalid (Mysql::Error: Incorrect string value: '\xE9\x87' for column 'value' at row 1: INSERT INTO `journal_details` (`property`, `old_value`, `value`, `journal_id`, `prop_key`) VALUES):
app/models/journal.rb:43:in `save'
app/models/issue.rb:806:in `create_journal'
app/models/issue.rb:512:in `save_issue_with_child_records'
app/models/issue.rb:494:in `save_issue_with_child_records'
app/controllers/issues_controller.rb:170:in `update'

Rendering D:/SSDIRedmines/esignageredmine-1.0.4/public/500.html (500 Internal Server Error)

Is your MySQL journal_details.value column / table / db charset set to UTF-8 as it should ?

Yes, the tables character set to UTF - 8.

I tried inserting the values manually and able to succeed.

Can you tell us which version of mysql or mysql2 gem you use, and which version of ruby ? Anything required in SubmittingBugs would be helpful too.