View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003219 | mantisbt | sql | public | 2003-07-07 00:54 | 2003-12-13 04:36 |
| Reporter | slajar | Assigned To | aarjona | ||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 0.18.0a4 | ||||
| Summary | 0003219: view_all_bug_page.php crashes on old mysql versions | ||||
| Description | The problem is an unusual using of the DISTINCT command. In the line 164 you will find the line: $query3 = "SELECT COUNT( DISTINCT ( $g_mantis_bug_table.id ) ) as count " . $t_from_clause . $t_where_clause; just replace it with this: $query3 = "SELECT COUNT( $g_mantis_bug_table.id ) as count " . $t_from_clause . $t_where_clause; That's it! You really don't need to distinct the queryin this case. yours | ||||
| Tags | No tags attached. | ||||
|
MantisBT: master 9faade25 2003-08-05 12:41 beerfrick Details Diff |
Fix for issue 0003219. Unnecesary DISTINCT function call made the query fail with older MySQL releases. Modified Files: core/filter_api.php doc/ChangeLog git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@2211 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0003219 |
|
| mod - doc/ChangeLog | Diff File | ||
| mod - core/filter_api.php | Diff File | ||