Relationship Graph

Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

IDProjectCategoryView StatusLast Update
0003569mantisbtbugtrackerpublic2004-02-29 07:16
Reporterndeboer Assigned Toaarjona  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version0.18.1 
Summary0003569: Search results in wrong number of bugs
Description

When I enter a search query (APPLICATION ERROR) and uncheck both solved and resolved, I get a result page with "1 - 30 / 75". Mantis thinks there are two pages (show = 50), but there is (ofcourse) only one.

Steps To Reproduce

Try this on this site. I found the bug here also.

TagsNo tags attached.
Attached Files
3569.patch (742 bytes)   
Index: core/filter_api.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/core/filter_api.php,v
retrieving revision 1.16
diff -u -r1.16 filter_api.php
--- core/filter_api.php 5 Feb 2004 00:34:38 -0000       1.16
+++ core/filter_api.php 27 Feb 2004 01:50:28 -0000
@@ -168,7 +168,7 @@
                }

                # Get the total number of bugs that meet the criteria.
-               $query = "SELECT COUNT( $t_bug_table.id ) as count $t_from $t_join $t_where";
+               $query = "SELECT COUNT( DISTINCT $t_bug_table.id ) as count $t_from $t_join $t_where";
                $result = db_query( $query );
                $bug_count = db_result( $result );

3569.patch (742 bytes)   

Relationships

has duplicate 0003476 closedvboctor "Search" produces crazy and unusable pages 
has duplicate 0003533 closedaarjona Total bug count is sometimes incorrect when searching text 

Activities

aarjona

aarjona

2004-02-26 21:01

reporter   ~0005116

Fixed in CVS.
Patch attached.

aarjona

aarjona

2004-02-26 21:02

reporter   ~0005117

bleh..

patch now actually attached