Forums » Help »
time tracking minutes
Added by Jan Mrazek over 9 years ago
Hi,
I use redmine with MySQL and migrate to PostgreSQL. Now i realized that the time tracking doesn't accept decimal values and all time I have to put is in hours only.
If I put 0.5, it becomes 0.
If I put 1.5, it becomes 1.
...etc
I am not sure whether it happened while migrating from one SQl to the other one, however, it is the only change I made. If I am not mistaken, it worked propely after first installation.
Does anybody have any advice?
Environment:
Redmine version 2.5.3.stable.14043
Ruby version 2.0.0-p598 (2014-11-13) [x86_64-linux]
Rails version 3.2.19
Environment production
Database adapter PostgreSQL
SCM:
Subversion 1.8.10
Git 2.1.0
Filesystem
Redmine plugins:
redmine_dmsf 1.4.9 stable
Thanks in advance,
Jan
SOLVED:
Most probably this happened while migrating from mysql to postgres. So here is the solution in case anybody bops into the same issue.
It was a problem with "numeric" type definition in postgres. I set precision and scale to correct values (11,2) using PgAdmin III and now it works properly again.
Jan