Defect #7426
closed
Cannot add issue with numeric value
Added by Jonas Haraldsson almost 15 years ago.
Updated almost 13 years ago.
Description
I have just upgraded Redmine to 1.0.4 (installing a new Bitnami Redmine stack and importing the database from Bitnami Redmine stack v0.9.6).
When I try to add a new issue, I get an error page (500).
The problem only appears if I enter a value in the "Estimated hours"-field.
See the attached production.log.tail.
As far as I can see, if I enter the value 2.2 in "Estimated hours", the value is sent as "2,2" which Mysql sees as two different values.
Database version: Mysql (mysql Ver 14.14 Distrib 5.1.50, for pc-linux-gnu (i686) using readline 5.1)
Rails version: 2.3.9
Ruby version: ruby 1.8.7 (2010-01-10 patchlevel 249) [i686-linux]
Files
The problem disappears if I change the decimal point from "," to "." on the client PC (Windows XP).
(this is not a usable work-around!)
I have verified the same behaviour in Redmine v1.1.0.
It seems that this problem starts when I add an issue in a project where time tracking is disabled.
After that the same problem occurs for all new issues I try to create if the "Estimated hours" field is not empty.
The problem remains until I restart the redmine server.
In other words, A work-around is to enable time tracking on all projects.
- Due date set to 2013-01-22
- Status changed from New to Needs feedback
I'm currently not able to reproduce this with Redmine 2.2.1 and a new MySQL Release.
Please confirm if this issue is solved in the recent versions. Otherwise I will close this issue next week.
- Status changed from Needs feedback to Closed
Closing this, as there is no feedback ont his issue and the affected version is realy old.
- Resolution set to No feedback
Closing this, as there is no feedback ont his issue and the affected version is realy old.
Also available in: Atom
PDF