Opened 11 years ago

Closed 11 years ago

billing reports dont work ?

Reported by: Owned by: Matthijs Kooijman Russ Tyndall normal TimingAndEstimationPlugin normal reports Matthijs Kooijman 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 ?

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

--Russ

comment:3 Changed 11 years ago by Russ Tyndall

Resolution: → fixed new → closed

Modify Ticket

Action
as closed The owner will remain Russ Tyndall.
The resolution will be deleted. Next status will be 'reopened'.