Dependency Graph
View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003569 | mantisbt | bugtracker | public | 2004-02-16 10:12 | 2004-02-29 07:16 |
| Reporter | ndeboer | Assigned To | aarjona | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.18.1 | ||||
| Summary | 0003569: 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. | ||||
| Tags | No 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 );
| ||||
related to
child of
duplicate of