MantisBT - v3.4 Release (Current)
View Issue Details
0001654v3.4 Release (Current)[All Projects] Taskspublic2015-06-30 14:062019-01-03 12:53
ReporterWildgoose 
Assigned Toopto 
PrioritynormalSeveritytweakReproducibilityalways
StatusclosedResolutionfixed 
PlatformPHPOSLinuxOS Version5.4.24
Product Version 
Target VersionFixed in Version 
Summary0001654: Pinned tasks cannot be unpinned
DescriptionOnce a task has been pinned in the ToDo list, it cannot be unpinned.
Steps To Reproducepin a task in the ToDo task list
TagsNo tags attached.
Attached Files

Notes
(0003754)
Themoulos   
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.
(0003782)
opto   
2016-06-05 02:37   
works in 3.3.66
(0003937)
caseydk   
2019-01-03 12:53   
In the 31 Dec 2018 release: http://docs.web2project.net/release-notes/3.4.html

Issue History
2015-06-30 14:06WildgooseNew Issue
2015-07-22 06:40ThemoulosNote Added: 0003754
2016-06-05 02:37optoNote Added: 0003782
2016-06-05 02:37optoStatusnew => resolved
2016-06-05 02:37optoResolutionopen => fixed
2016-06-05 02:37optoAssigned To => opto
2016-06-05 02:38optoProjectv3.3 Release => v3.4 Release (Current)
2016-06-05 02:38optoCategoryTasks => General
2016-12-27 23:32caseydkCategoryGeneral => Tasks
2019-01-03 12:53caseydkNote Added: 0003937
2019-01-03 12:53caseydkStatusresolved => closed