Redmine

some SQL queries start to become corrupt

Can you attach a log that show one of these corrupted queries?

Certainly. Terminal output from the server is as follows (notice how the value "16" has become "16,0", which is being interpreted by MySQL as two distinct arguments instead of one):

Processing IssuesController#edit (for 192.168.16.162 at 2010-02-08 20:29:48) [POST]
  Parameters: {"time_entry"=>{"comments"=>"", "activity_id"=>"", "hours"=>""}, "commit"=>"Spara", "action"=>"edit", "authenticity_token"=>"ZSdpLVFUK6Z0pW5woGHauU6sdZFjnTyu/9CO0OIYduY=", "id"=>"17", "notes"=>"", "controller"=>"issues", "issue"=>{"start_date"=>"2010-02-08", "estimated_hours"=>"16", "lock_version"=>"0", "priority_id"=>"4", "subject"=>"XXXXX", "description"=>"XXXXX", "tracker_id"=>"5", "done_ratio"=>"0", "due_date"=>"", "assigned_to_id"=>"4", "status_id"=>"1", "custom_field_values"=>{"2"=>"XXXXX", "3"=>"1"}}, "attachments"=>{"1"=>{"description"=>""}}}

ActiveRecord::StatementInvalid (Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0, `lock_version` = 1, `updated_on` = '2010-02-08 20:29:48'

              WHERE ' at line 2:               UPDATE `issues`
              SET `estimated_hours` = 16,0, `lock_version` = 1, `updated_on` = '2010-02-08 20:29:48'
              WHERE id = 17
              AND `lock_version` = 0
):
  app/controllers/issues_controller.rb:196:in `edit'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /opt/redmine/redmine-0.9/public/500.html (500 Internal Server Error)

The equivalent when exporting to PDF can be seen here:

%PDF-1.3
3 0 obj
<</Type /Page
/Parent 1 0 R
/MediaBox [0 0 841,89 595,28]
/Resources 2 0 R
/Contents 4 0 R>>
endobj

...

Notice how it says "/MediaBox [0 0 841,89 595,28]" instead of "/MediaBox [0 0 841.89 595.28]".

Thanks. It looks strange and I'm not able to reproduce this problem.
Did you install any plugin or make any change to the core?

No, I don't recall installing any plugins or making any other changes.

I tried installing the same version of Redmine on a development system, with the same locale. Interestingly, the problem does not seem to appear on that system. Evidently, there is something particular with the system setup involved here, necessary for the problem to occur.

I'd be willing to help track this issue down, as best I can. I have a fair amount of programming experience, but I'm new to Ruby, so I'm unsure how to best proceed. Presumably, I could add checks using sprintf() at various places in the code, to try to pin down the exact place where the formatting behavior changes.