Ticket #624 (closed defect: fixed)

Opened 7 years ago

Last modified 7 years ago

billing reports dont work ?

Reported by: Matthijs@kadijk,com Assigned to: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords: reports
Cc: matthijs@kadijk.com 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

Change History

08/22/06 13:26:04 changed 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

08/22/06 15:58:56 changed 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

08/22/06 15:59:06 changed by bobbysmith007

  • status changed from new to closed.
  • resolution set to fixed.

Add/Change #624 (billing reports dont work ?)




Change Properties
Action