Closed Bug 3365 Opened 26 years ago Closed 26 years ago

Incorrect collection of stats when zero NEW or ASSIGNED bugs

Categories

(Bugzilla :: Bugzilla-General, defect, P2)

Product:
Bugzilla
Component:
Bugzilla-General
Platform:
Sun
SunOS
Type:
defect

Tracking

()

Status:
VERIFIED FIXED
Milestone:
Bugzilla old

People

(Reporter: cbaldwin, Assigned: terry)

Details

Give the following situation the collectstats.pl script assigns the query results to the wrong field in the stats file. bug_status # of bugs NEW 0 ASSIGNED 20 REOPENED 1 The SQL query returns two number 20 and 1. The script assumes the that the first number the query returns is the number of new bugs. In this case that is wrong. The same problem would occur if there were 0 ASSIGNED bugs and one ore more REOPENED bugs. Workaround: Modify the SQL query to return the bug status as well as the number of bugs. select bug_status, count(bug_status) form.... Then when building the data for the stats file the script can check each returned row to see which bug_status it is dealing with.
Status: NEW → RESOLVED
Closed: 26 years ago
Resolution: --- → FIXED
Yikes! Yes, I agree, this was very bad. Thanks. I have fixed, and checked in a new version. Please check it out.
per Terry, auto-verifying any resolved bug that hasn't been touched since before 2.10 was released.
Status: RESOLVED → VERIFIED
Moving to Bugzilla product
Component: Bugzilla → Bugzilla-General
Product: Webtools → Bugzilla
QA Contact: matty
Target Milestone: --- → Bugzilla old
Version: other → unspecified
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.