Report execution failed: invalid input syntax for type numeric: "0h 40m"

[anonymous]

I have trac 0.12 with postgres 8.4.4 database and the latest svn checkout of the plugin . After some trouble (see #7446) I installed the plugin, and it lets me add times to tickets, which is what I needed.

But trying to display any of the billing reports results in error:

Report execution failed: invalid input syntax for type numeric: "0h 40m"

[anonymous]

This command fixed it:

=> delete from foo.ticket_change where newvalue like '%0h 40m%';

It really looks like there was some other time tracking plugin installed in there and there is some leftover trash in the database. It's not a fault of this plugin, so I will mark the bug as invalid.

[Russ Tyndall]

Yeah, Timing and Estimation saves all time as fractional hours (actually unitless, but labeled hours everywhere), so your assumption seems correct.