View Issue Details

IDProjectCategoryView StatusLast Update
0009358mantisbtroadmappublic2019-05-09 06:11
ReporterJocelynAssigned To 
PrioritynormalSeveritytweakReproducibilityalways
Status confirmedResolutionopen 
Product Version1.1.2 
Target VersionFixed in Version 
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.

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

2008-07-07 15:23

 

mantis_bug111.png (2,789 bytes)
mantis_bug111.png (2,789 bytes)

2008-07-07 15:24

 

mantis_bug112.png (1,873 bytes)
mantis_bug112.png (1,873 bytes)
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

Issue History

Date Modified Username Field Change
2008-07-07 15:23 Jocelyn New Issue
2008-07-07 15:23 Jocelyn File Added: mantis_bug111.png
2008-07-07 15:24 Jocelyn File Added: mantis_bug112.png
2008-07-07 17:05 jreese Relationship added related to 0009357
2008-07-07 17:06 jreese Status new => assigned
2008-07-07 17:06 jreese Assigned To => jreese
2008-07-08 08:19 jreese Target Version => 1.2.0
2008-07-10 09:12 Jocelyn Note Added: 0018360
2008-07-12 18:19 giallu Target Version => 1.2.0
2008-08-11 08:49 jreese Relationship added child of 0009488
2009-05-04 14:27 siebrand Target Version 1.2.2 => 1.x.x
2012-10-16 09:03 dregad Status assigned => confirmed
2012-10-16 09:04 dregad Assigned To jreese =>
2012-10-16 09:17 dregad Note Added: 0033224
2014-01-21 16:46 atrol Target Version 1.3.0-beta.1 =>
2019-05-08 18:47 sandyj Note Added: 0062041
2019-05-09 06:11 dregad Relationship added related to 0012546
2019-05-09 06:11 dregad Note Added: 0062044