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