| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| 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 | ||||
| Reporter | nimbus | ||||||||
| Assigned To | caseydk | ||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Product Version | |||||||||
| 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. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
caseydk (administrator) 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. :) |
|
nimbus (reporter) 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. |
|
caseydk (administrator) 2011-01-23 23:14 |
Resolved as described in r1606; |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 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 |
| Issue History |