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. |
|