billing reports dont work ?

[Matthijs Kooijman]

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 ?

[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

[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