View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0004996 | mantisbt | sql | public | 2004-12-17 03:46 | 2005-04-18 10:42 |
Reporter | Thox | Assigned To | thraxisp | ||
Priority | normal | Severity | major | Reproducibility | sometimes |
Status | closed | Resolution | fixed | ||
Product Version | git trunk | ||||
Fixed in Version | 1.0.0a1 | ||||
Summary | 0004996: "Open and assigned to me" shows wrong number | ||||
Description | The "Open and assigned to me" count on the Main / news page is not accurate. My current display shows 83, although the summary correctly shows the true value of 3. | ||||
Additional Information | PHP 5, IIS 6, and using a number of extra custom issue statuses. | ||||
Tags | No tags attached. | ||||
Can you determine what causes this problem? |
|
The custom statuses are causing the problem. The function user_get_assigned_open_bug_count() has the following SQL query: $query = "SELECT COUNT(*) |
|
I agree with this problem and think the sql query is wrong. I have a custom status "tested" between resolved and closed. I think the sql query should only select status beyond resolved and not above like: $query = "SELECT COUNT(*) |
|
fixed in CVS. Removed hardcoded "RESOLVED" as well. |
|