View Issue Details

IDProjectCategoryView StatusLast Update
0009358mantisbtroadmappublic2019-05-09 06:11
ReporterJocelyn Assigned To 
PrioritynormalSeveritytweakReproducibilityalways
Status confirmedResolutionopen 
Product Version1.1.2 
Summary0009358: Roadmap shows duplicate entries
Description

In mantis 1.1.1, the roadmap page showed many duplicate entries. (see first screenshot)
In mantis 1.1.2, the roadmap page still shows some duplicate entries. (see 2nd screenshot)
In my screenshots, bug 109 is related to 7 bugs and is child of 7 other bugs.

Is this the intended behavior? This is confusing for me...

TagsNo tags attached.
Attached Files
mantis_bug111.png (2,789 bytes)   
mantis_bug111.png (2,789 bytes)   
mantis_bug112.png (1,873 bytes)   
mantis_bug112.png (1,873 bytes)   

Relationships

related to 0012546 new Incidences with dependencies are duplicated 
related to 0009357 closeddregad Change Log still shows duplicate entries 
child of 0009488 confirmed Improve and fix roadmap/changelog listings 

Activities

Jocelyn

Jocelyn

2008-07-10 09:12

reporter   ~0018360

I just tried one quick change to the source code of the file roadmap_page.php :

Around line 106, replace:
$query = "SELECT $t_bug_table.*, $t_relation_table.source_bug_id FROM $t_bug_table
LEFT JOIN $t_relation_table ON $t_bug_table.id=$t_relation_table.destination_bug_id AND $t_relation_table.relationship_type=2
WHERE project_id='$c_project_id' AND target_version='$c_version' ORDER BY status ASC, last_updated DESC";

With:
$query = "SELECT $t_bug_table.*, $t_relation_table.source_bug_id FROM $t_bug_table
LEFT JOIN $t_relation_table ON $t_bug_table.id=$t_relation_table.destination_bug_id AND $t_relation_table.relationship_type=2
WHERE project_id='$c_project_id' AND target_version='$c_version'
GROUP BY $t_bug_table.id
ORDER BY status ASC, last_updated DESC";

The "GROUP BY" clause has the effect of removing all duplicate bug IDs.
On my mantis installation, it works fine.

dregad

dregad

2012-10-16 09:17

developer   ~0033224

Unassigned from jreese as he is no longer actively developing.

sandyj

sandyj

2019-05-08 18:47

reporter   ~0062041

still happening in 2.9

dregad

dregad

2019-05-09 06:11

developer   ~0062044

Related to, possible duplicate of 0012546