Modify

Opened 8 years ago

Closed 8 years ago

#624 closed defect (fixed)

billing reports dont work ?

Reported by: Matthijs@… Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords: reports
Cc: matthijs@… Trac Release: 0.10

Description

Hi, following yout suggestion to upgrade, I am now at trac version 0.10dev.

I manneged to install the plugin, and see (after a upgrade of the trac project db) that the extra field show up in the ticket pages. Also I get a list of new reports ....

So far so good, but all of the reposrt report a error message like this:

Report execution failed: no such column: newvalue

the error seems to relate to the second clause in de union of the subselect.

FYI I am unig SQLITE as the trac backend database. Maybe there is some SQL related issue ?

Attachments (0)

Change History (3)

comment:1 Changed 8 years ago by bobbysmith007

I am also using the sqlite backend so that shouldn't be the issue.

I just updated my trac instace to svn head to insure that a problem wasn't introduced there.

Could you please post the sql of one of the failing reports as a comment on this ticket? Alternativly, if you are hosting this at a public location and can give me a user with access to the trac instance with all report permissions, I might be able to debug this faster. This column (newvalue) is on the ticket_change table in the trac database, and I dont alter this table in the plugin. Are all other reports and normal(not the plugin) trac features working?

Thanks, Russ

comment:2 Changed 8 years ago by bobbysmith007

This has been fixed and a new version has been uploaded to source control.

I am not sure why, but on my machine (and even on other reports on your instance), it was using the column named from the first half of the UNION as the column name of the UNION's result. However, sometimes it appears to use the second table of the UNION's column names. Either way, I fixed all instances of this being broken that I know of, and have updated the reports file.

You should be able to upgrade the svn copy, you then have to upgrade the trac running it (with trac-admin) and everything should hopefully be good.

--Russ

comment:3 Changed 8 years ago by bobbysmith007

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

Add Comment

Modify Ticket

Action
as closed The owner will remain bobbysmith007.
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.