Opened 8 years ago

Closed 8 years ago

Last modified 8 years ago

#7448 closed defect (invalid)

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

Reported by: anonymous Owned by: Russ Tyndall
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12


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"

Attachments (0)

Change History (2)

comment:1 Changed 8 years ago by anonymous

Resolution: invalid
Status: newclosed

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 8 years ago by Russ Tyndall

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

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Russ Tyndall.
The resolution will be deleted.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.