Opened 12 years ago

Closed 12 years ago

#9510 closed defect (fixed)

TestStats for single Testplans at 1.4.8 not working - patched

Reported by: podskalsky Owned by: Roberto Longobardi
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)

Regards, Andreas

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

Download all attachments as: .zip

Change History (5)

Changed 12 years ago by podskalsky

Attachment: added

comment:1 Changed 12 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?

Ciao, Roberto

comment:2 Changed 12 years ago by Roberto Longobardi

Hi, 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. Roberto

comment:3 Changed 12 years ago by podskalsky

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

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

comment:4 Changed 12 years ago by anonymous

Resolution: fixed
Status: newclosed

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Roberto Longobardi.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Note: See TracTickets for help on using tickets.