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