Search This Blog

Tuesday, February 22, 2011

Task only showing 99.99% complete - dotProject Problem in 2.1 version

When we select progress as 100% in view mode, it then reports the task as 99.99%. Have we missed a step to get it to show as 100% This is a problem in dotproject due to the column datatype to fix this run the sql below which will change the datatype of percentage column from 4 to 5 and also update the previous data of 99.99 to 100

"ALTER TABLE `tasks` MODIFY `task_percent_complete` decimal(5,2) DEFAULT '0';
update tasks set task_percent_complete = 100 where task_percent_complete = 99.99;"

No comments:

Post a Comment