Opened 2 years ago

Closed 2 years ago

#9510 closed defect (fixed)

TestStats for single Testplans at 1.4.8 not working - patched

Reported by: podskalsky Owned by: seccanj
Priority: highest Component: TestManagerForTracPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.12


There is a bug in your SQL statement!
Single TestPlan statistics are not running at 1.4.8!

patched line 115 at

sql = "SELECT COUNT(*) FROM testcasehistory th1, (SELECT id, planid, max(time) as maxtime FROM testcasehistory WHERE planid = '%s' AND time > %s AND time <= %s GROUP BY planid, id) th2 WHERE th1.time = th2.maxtime AND = AND th1.planid = th2.planid AND th1.status = '%s'" % (testplan, to_any_timestamp(from_date), to_any_timestamp(at_date), status)


Attachments (1) (4.4 KB) - added by podskalsky 2 years ago.

Download all attachments as: .zip

Change History (5)

Changed 2 years ago by podskalsky

comment:1 Changed 2 years ago by anonymous

Ciao Andreas,
well, thanks for catching this one!

I'll try to take a look at this tonight, in the meantime, would you take a look at the development version of 1.4.9 attached to ticket #8958 and let me know what you think?


comment:2 Changed 2 years ago by seccanj

the fix to this ticket is in the latest BETA 1.4.9 release, attached to #9287.

Actually there also is the need for updating the language catalogs. I have uploaded the modified versions on Transflex for anyone to contribute.

Refer to the forum post for details.

It would be great if you could take a tour and, besides looking at the new stuff, make sure nothing (big) is broken.

Thanks, ciao.

comment:3 Changed 2 years ago by podskalsky

can't find this "bug" at BETA 1.4.9 release :-)

At "test activity trend" there is nothing displayed for test plans with "selected" test cases ("Only the Test Cases selected before")

comment:4 Changed 2 years ago by anonymous

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

Add Comment

Modify Ticket

as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from seccanj. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.