MantisBT - v2.3 Release (Closed)
View Issue Details
0000702v2.3 Release (Closed)[All Projects] Generalpublic2011-01-22 09:532011-03-24 09:53
Reporternimbus 
Assigned Tocaseydk 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version2.3 
Summary0000702: function projectSelectWithOptGroup shows duplicate result
DescriptionIn some modules that use this function (Project add/edit - Copy tasks; File: add/edit)

1. I ran some test and it have result like in Picture No.1, it some project repeat 0000011:0000010 times. There are no duplicate id or name in database ( I checked by phpmyadmin)
2. So I add DISTINCT keyword into line 242 of: includes/main_functions.php:
   $q->addQuery('DISTINCT pr.project_id, co.company_name, project_name');
3. Now it work ok as in Picture No. 2.
TagsNo tags attached.
Attached Fileszip Bug1.zip (96,498) 1969-12-31 16:00
https://bugs.web2project.net/file_download.php?file_id=180&type=bug

Notes
(0001577)
caseydk   
2011-01-22 12:52   
Wait.. wait.. wait.. you submit a bug report *and* the fix for it? What were you thinking?

With more people like you around... well, this would be an even better place to be.

Nice job and thanks. :)
(0001578)
nimbus   
2011-01-22 17:32   
:)

Actually, I'm not good at coding. I just try to solve problems arise with my installation and log them here for your ref.

About this bug, I could not trace further due to limit experience in coding. However this solution work good for me at the moment.

Enjoy weekend.
(0001581)
caseydk   
2011-01-23 23:14   
Resolved as described in r1606;

Issue History
2011-01-22 09:53nimbusNew Issue
2011-01-22 09:53nimbusFile Added: Bug1.zip
2011-01-22 12:52caseydkStatusnew => assigned
2011-01-22 12:52caseydkAssigned To => caseydk
2011-01-22 12:52caseydkNote Added: 0001577
2011-01-22 17:32nimbusNote Added: 0001578
2011-01-23 23:13caseydkProjectv2.2 Release (Closed) => v2.3 Release (Closed)
2011-01-23 23:14caseydkNote Added: 0001581
2011-01-23 23:14caseydkStatusassigned => resolved
2011-01-23 23:14caseydkResolutionopen => fixed
2011-03-24 09:53caseydkFixed in Version => 2.3
2011-03-24 09:53caseydkStatusresolved => closed