Modify

Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#7448 closed defect (invalid)

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

Reported by: anonymous Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 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"

Attachments (0)

Change History (2)

comment:1 Changed 4 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 4 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.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.