Relationship Graph

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

View Issue Details

IDProjectCategoryView StatusLast Update
0003219mantisbtsqlpublic2003-12-13 04:36
Reporterslajar Assigned Toaarjona  
PrioritynormalSeveritycrashReproducibilityalways
Status closedResolutionfixed 
Product Version0.18.0a4 
Summary0003219: 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
Matthias

TagsNo tags attached.

Relationships

has duplicate 0003246 closedaarjona Query fails - generating list of bugs 

Activities

updater

updater

2003-08-05 10:23

updater   ~0004487

Isn't this the same as bugno: 0003246 Or is the the solution to that bugno??

aarjona

aarjona

2003-08-05 18:25

reporter   ~0004488

This makes sense. Assigning.

aarjona

aarjona

2003-08-05 18:41

reporter   ~0004489

fix checked in.

Related Changesets

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