I just installed dotproject through Fatntastico and am immediately running into errors. The first thing I tried after logging into dotproject was to click on the "Tasks" link. The following SQL exception is thrown:
ERROR: /home/refor7/public_html/evidencebasedcryonics/project/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 FROM tasks, user_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_id
ORDER BY project_id, task_start_date
Backtrace:
0 /home/refor7/public_html/evidencebasedcryonics/project/includes/db_adodb.php:61 dprint('/home/refor7/public_html/evidencebasedcryonics/project/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 FROM tasks, user_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_id
ORDER BY project_id, task_start_date
')
1 /home/refor7/public_html/evidencebasedcryonics/project/modules/tasks/tasks.php:289 db_exec('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 FROM tasks, user_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_id
ORDER BY project_id, task_start_date')
2 /home/refor7/public_html/evidencebasedcryonics/project/modules/tasks/index.php:115 include('/home/refor7/public_html/evidencebasedcryonics/project/modules/tasks/tasks.php')
3 /home/refor7/public_html/evidencebasedcryonics/project/index.php:311 require('/home/refor7/public_html/evidencebasedcryonics/project/modules/tasks/index.php')
Unknown column 'task_project' in 'on clause'
I know you don't support this product, but shouldn't basic functionality work after it has been installed. If other users are experiencing the same problem, maybe it should be removed from the Fantastico until it does.
Dilber MC Theme by HarzeM