| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
|---|---|---|---|---|---|---|---|---|---|
| 0001654 | v3.4 Release (Current) | [All Projects] Tasks | public | 2015-06-30 14:06 | 2019-01-03 12:53 | ||||
| Reporter | Wildgoose | ||||||||
| Assigned To | opto | ||||||||
| Priority | normal | Severity | tweak | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Platform | PHP | OS | Linux | OS Version | 5.4.24 | ||||
| Product Version | |||||||||
| Target Version | Fixed in Version | ||||||||
| Summary | 0001654: Pinned tasks cannot be unpinned | ||||||||
| Description | Once a task has been pinned in the ToDo list, it cannot be unpinned. | ||||||||
| Steps To Reproduce | pin a task in the ToDo task list | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
Themoulos (reporter) 2015-07-22 06:40 |
I downloaded and tested the latest version from github, which actually works... The problem seems to be located in file "tasks.class.php", in function "getTaskTree". I changed the query source ================================================================ $q = $this->_getQuery(); $q->addTable('tasks'); $q->addQuery('*, p.project_name'); $q->addWhere('task_project = ' . (int) $project_id); 5. $q->addJoin('projects', 'p', 'p.project_id = task_project'); ================================================================= to the following: ================================================================= $q = $this->_getQuery(); $q->addTable('tasks'); $q->addQuery('tasks.*, p.project_name, p.project_owner, p.project_company, task_pinned'); $q->addWhere('task_project = ' . (int) $project_id); 5. //$q->addWhere('task_status = 0'); $q->addJoin('projects', 'p', 'p.project_id = task_project'); $q->addQuery('user_task_priority'); $q->addJoin('user_tasks', 'ut', 'ut.task_id = tasks.task_id'); $q->addJoin('user_task_pin', 'utp', 'tasks.task_id = utp.task_id'); =============================================================== and now it works as it should. Please, verify that only this is needed (I changed other things as well and somehow lost track of all changes, but changing this one point makes sence. |
|
opto (manager) 2016-06-05 02:37 |
works in 3.3.66 |
|
caseydk (administrator) 2019-01-03 12:53 |
In the 31 Dec 2018 release: http://docs.web2project.net/release-notes/3.4.html |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-06-30 14:06 | Wildgoose | New Issue | |
| 2015-07-22 06:40 | Themoulos | Note Added: 0003754 | |
| 2016-06-05 02:37 | opto | Note Added: 0003782 | |
| 2016-06-05 02:37 | opto | Status | new => resolved |
| 2016-06-05 02:37 | opto | Resolution | open => fixed |
| 2016-06-05 02:37 | opto | Assigned To | => opto |
| 2016-06-05 02:38 | opto | Project | v3.3 Release => v3.4 Release (Current) |
| 2016-06-05 02:38 | opto | Category | Tasks => General |
| 2016-12-27 23:32 | caseydk | Category | General => Tasks |
| 2019-01-03 12:53 | caseydk | Note Added: 0003937 | |
| 2019-01-03 12:53 | caseydk | Status | resolved => closed |
| Issue History |