Anonymous Login
2019-04-24 19:06 PDT

View Issue Details Jump to Notes ]
IDProjectCategoryView StatusLast Update
0001654v3.4 Release (Current)[All Projects] Taskspublic2019-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

-Relationships
+Relationships

-Notes

~0003754

Themoulos (reporter)

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 (manager)

works in 3.3.66

~0003937

caseydk (administrator)

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