#249 MySQL 5 - SQL Syntax Error - Task Log/Task per User - V2.0.4

open
nobody
None
5
2006-11-08
2006-11-08
evillier
No

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

Discussion

  • evillier

    evillier - 2006-11-08

    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

     
  • evillier

    evillier - 2006-11-08
    • summary: MySQL 5 - SQL Syntax Error - Task Log - V2.0.4 --> MySQL 5 - SQL Syntax Error - Task Log/Task per User - V2.0.4
     
  • Jon Booth

    Jon Booth - 2007-01-29

    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'");

     

Log in to post a comment.