Opened 12 years ago

Closed 12 years ago

Last modified 3 months ago

#624 closed defect (fixed)

billing reports dont work ?

Reported by: Matthijs Kooijman Owned by: Russ Tyndall
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords: reports
Cc: Matthijs Kooijman Trac Release: 0.10


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

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

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.


comment:3 Changed 12 years ago by Russ Tyndall

Resolution: fixed
Status: newclosed

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.