Opened 6 years ago

Closed 6 years ago

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

Reported by: Owned by: anonymous bobbysmith007 normal TimingAndEstimationPlugin normal 0.12

Description

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"


comment:1 Changed 6 years ago by anonymous

• Resolution set to invalid
• Status changed from new to closed

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.

comment:2 Changed 6 years ago by bobbysmith007

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