ERROR: /usr/local/apache2/dotproject/includes/db_adodb.php(61): Error executing: SELECT distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,task_priority, task_percent_complete, task_duration, task_duration_type, task_project,task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table='tasks' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > '0' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active <> 0 AND task_project = projects.project_id AND user_tasks.user_id = 1 AND user_tasks.task_id = tasks.task_id AND (task_percent_complete < '100' OR task_end_date = '') AND projects.project_active = '1' AND projects.project_status <> '4' AND projects.project_status <> '5' AND task_status = '0'GROUP BY task_idORDER BY project_id, task_start_dateBacktrace:0 /usr/local/apache2/dotproject/includes/db_adodb.php:61 dprint('/usr/local/apache2/dotproject/includes/db_adodb.php',61,0,'Error executing: SELECT distinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,task_priority, task_percent_complete, task_duration, task_duration_type, task_project,task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table=\'tasks\' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > \'0\' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active <> 0 AND task_project = projects.project_id AND user_tasks.user_id = 1 AND user_tasks.task_id = tasks.task_id AND (task_percent_complete < \'100\' OR task_end_date = \'\') AND projects.project_active = \'1\' AND projects.project_status <> \'4\' AND projects.project_status <> \'5\' AND task_status = \'0\'GROUP BY task_idORDER BY project_id, task_start_date')1 /usr/local/apache2/dotproject/modules/tasks/tasks.php:289 db_exec('SELECTdistinct tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_dynamic, task_pinned, pin.user_id as pin_user,task_priority, task_percent_complete, task_duration, task_duration_type, task_project,task_description, task_owner, task_status, usernames.user_username, usernames.user_id, task_milestone,assignees.user_username as assignee_username, count(distinct assignees.user_id) as assignee_count, co.contact_first_name, co.contact_last_name,count(distinct files.file_task) as file_count, tlog.task_log_problem, MAX(history_date) as last_update FROM tasks, user_tasks LEFT JOIN history ON history_item = tasks.task_id AND history_table=\'tasks\' LEFT JOIN projects ON project_id = task_project LEFT JOIN users as usernames ON task_owner = usernames.user_id LEFT JOIN user_tasks as ut ON ut.task_id = tasks.task_id LEFT JOIN users as assignees ON assignees.user_id = ut.user_id LEFT JOIN contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN task_log AS tlog ON tlog.task_log_task = tasks.task_id AND tlog.task_log_problem > \'0\' LEFT JOIN files on tasks.task_id = files.file_task LEFT JOIN user_task_pin as pin ON tasks.task_id = pin.task_id AND pin.user_id = 1 WHERE project_active <> 0 AND task_project = projects.project_id AND user_tasks.user_id = 1 AND user_tasks.task_id = tasks.task_id AND (task_percent_complete < \'100\' OR task_end_date = \'\') AND projects.project_active = \'1\' AND projects.project_status <> \'4\' AND projects.project_status <> \'5\' AND task_status = \'0\'GROUP BY task_idORDER BY project_id, task_start_date')2 /usr/local/apache2/dotproject/modules/tasks/index.php:115 include('/usr/local/apache2/dotproject/modules/tasks/tasks.php')3 /usr/local/apache2/dotproject/index.php:311 require('/usr/local/apache2/dotproject/modules/tasks/index.php')Unknown column 'tasks.task_id' in 'on clause'