Rob B. Jacobs - 2005-01-08

Logged In: YES
user_id=3636

The hours field in the database is too small to store 10, so
MySql converts it (against all database convention:-0) to
the maximum it can store.

Running this query on the database should make you happy:

ALTER TABLE `IPM_tasks` CHANGE `hours` `hours` DECIMAL(5,2)
DEFAULT '1.00' NOT NULL;

This is enough to store a maximum of 99.99 hours. For more,
change the 5 to a 6 for a max of 999.99 etc.

This seems to work as expected, but maybe the script has
some limit built in somewhere (it didn't when I last looked
at the code)

Have fun!

Rob