Menu
▾
▴
#249 MySQL 5 - SQL Syntax Error - Task Log/Task per User - V2.0.4
Because of MySQL5 strict SQL syntax checking, an error
occurs whenn you try to have a task log report.
In order to correct this, you have to modify this file:
dotproject/modules/projects/reports/tasklogs.php
and replace line 130:
."\nFROM task_log AS t, tasks"
by
."\nFROM (task_log AS t, tasks)"
HTH.
--Eric
Logged In: YES
user_id=1640554
Another error in file:
dotproject/modules/tasks/tasks.class.php
prevents correct display of the "Tasks per User" view (in
Tasks module)
You can etit this file and replace line 1353:
from users as u, user_tasks as ut
by
FROM (users as u, user_tasks as ut)
HTH.
--Eric
Logged In: YES
user_id=694893
Originator: NO
To fix modules/tasks/todo.php
Change the query code to:
// query my sub-tasks (ignoring task parents)
$q = new DBQuery;
$q->addQuery('ta.*');
$q->addQuery('project_name, project_id, project_color_identifier');
$q->addQuery('tp.task_pinned');
$q->addTable('projects', 'pr');
$q->innerJoin('tasks', 'ta','pr.project_id = ta.task_project');
$q->innerJoin('user_tasks', 'ut','ut.task_id = ta.task_id');
$q->leftJoin('user_task_pin', 'tp', 'tp.task_id = ta.task_id and tp.user_id = ' . $user_id);
$q->addWhere("ut.user_id = '$user_id'");
$q->addWhere('( ta.task_percent_complete < 100 or ta.task_percent_complete is null)');
$q->addWhere("ta.task_status = '0'");