View Issue Details

IDProjectCategoryView StatusLast Update
0004996mantisbtsqlpublic2005-04-18 10:42
ReporterThox Assigned Tothraxisp  
PrioritynormalSeveritymajorReproducibilitysometimes
Status closedResolutionfixed 
Product Versiongit trunk 
Fixed in Version1.0.0a1 
Summary0004996: "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.

TagsNo tags attached.

Relationships

child of 0004937 closedvboctor Mantis 1.0.0a1 Release 

Activities

jlatour

jlatour

2004-12-17 04:17

reporter   ~0008686

Can you determine what causes this problem?

Thox

Thox

2004-12-17 04:29

reporter   ~0008687

The custom statuses are causing the problem. The function user_get_assigned_open_bug_count() has the following SQL query:

$query = "SELECT COUNT(*)
FROM $t_bug_table
WHERE $t_where_prj
status<>'$t_resolved'
AND status<>'$t_closed'
AND handler_id='$c_user_id'";

OliverBee

OliverBee

2004-12-20 04:18

reporter   ~0008739

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(*)
FROM $t_bug_table
WHERE $t_where_prj
status<'$t_resolved'
AND handler_id='$c_user_id'";

thraxisp

thraxisp

2004-12-20 20:13

reporter   ~0008747

fixed in CVS. Removed hardcoded "RESOLVED" as well.