|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0000702||v2.3 Release (Closed)||[All Projects] General||public||2011-01-22 09:53||2011-03-24 09:53|
|Target Version||Fixed in Version||2.3|
|Summary||0000702: function projectSelectWithOptGroup shows duplicate result|
|Description||In 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.
|Tags||No tags attached.|
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. :)
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.
|Resolved as described in r1606;|
|2011-01-22 09:53||nimbus||New Issue|
|2011-01-22 09:53||nimbus||File Added: Bug1.zip|
|2011-01-22 12:52||caseydk||Status||new => assigned|
|2011-01-22 12:52||caseydk||Assigned To||=> caseydk|
|2011-01-22 12:52||caseydk||Note Added: 0001577|
|2011-01-22 17:32||nimbus||Note Added: 0001578|
|2011-01-23 23:13||caseydk||Project||v2.2 Release (Closed) => v2.3 Release (Closed)|
|2011-01-23 23:14||caseydk||Note Added: 0001581|
|2011-01-23 23:14||caseydk||Status||assigned => resolved|
|2011-01-23 23:14||caseydk||Resolution||open => fixed|
|2011-03-24 09:53||caseydk||Fixed in Version||=> 2.3|
|2011-03-24 09:53||caseydk||Status||resolved => closed|