Skip to content

SQL errors #163

Open
Open
@kbray1967

Description

@kbray1967

I have downloaded and installed dot.Project. When running a lot of the pages have multiple SQL errors, ie. "incorrect DATETIME value"

ERROR: C:\Users\Ken\Desktop\dotProject-2.2.0\includes\db_adodb.php(67): Error executing:
SELECT distinct tsk.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 fi.file_task) as file_count, if (tlog.task_log_problem IS NULL, 0, tlog.task_log_problem) AS task_log_problem FROM (dotp_user_tasks as ut3, dotp_tasks as tsk) LEFT JOIN dotp_projects as prj ON project_id = task_project LEFT JOIN dotp_users as usernames ON task_owner = usernames.user_id LEFT JOIN dotp_user_tasks as ut ON ut.task_id = tsk.task_id LEFT JOIN dotp_users as assignees ON assignees.user_id = ut.user_id LEFT JOIN dotp_contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN dotp_task_log AS tlog ON tlog.task_log_task = tsk.task_id AND tlog.task_log_problem > 0 LEFT JOIN dotp_files as fi on tsk.task_id = fi.file_task LEFT JOIN dotp_user_task_pin as pin ON tsk.task_id = pin.task_id AND pin.user_id = 1 WHERE project_status <> 7 AND task_project = prj.project_id AND ut3.user_id = 1 AND ut3.task_id = tsk.task_id AND (task_percent_complete < 100 OR task_end_date = '') AND prj.project_status <> 7 AND prj.project_status <> 4 AND prj.project_status <> 5 AND task_status = 0 GROUP BY tsk.task_id ORDER BY project_id, task_start_date
(Incorrect DATETIME value: '')
Backtrace:
0 C:\Users\Ken\Desktop\dotProject-2.2.0\includes\db_adodb.php:67 dprint('C:\Users\Ken\Desktop\dotProject-2.2.0\includes\db_adodb.php',67,0,'Error executing:
SELECT distinct tsk.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 fi.file_task) as file_count, if (tlog.task_log_problem IS NULL, 0, tlog.task_log_problem) AS task_log_problem FROM (dotp_user_tasks as ut3, dotp_tasks as tsk) LEFT JOIN dotp_projects as prj ON project_id = task_project LEFT JOIN dotp_users as usernames ON task_owner = usernames.user_id LEFT JOIN dotp_user_tasks as ut ON ut.task_id = tsk.task_id LEFT JOIN dotp_users as assignees ON assignees.user_id = ut.user_id LEFT JOIN dotp_contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN dotp_task_log AS tlog ON tlog.task_log_task = tsk.task_id AND tlog.task_log_problem > 0 LEFT JOIN dotp_files as fi on tsk.task_id = fi.file_task LEFT JOIN dotp_user_task_pin as pin ON tsk.task_id = pin.task_id AND pin.user_id = 1 WHERE project_status <> 7 AND task_project = prj.project_id AND ut3.user_id = 1 AND ut3.task_id = tsk.task_id AND (task_percent_complete < 100 OR task_end_date = '') AND prj.project_status <> 7 AND prj.project_status <> 4 AND prj.project_status <> 5 AND task_status = 0 GROUP BY tsk.task_id ORDER BY project_id, task_start_date
(Incorrect DATETIME value: '')')
1 C:\Users\Ken\Desktop\dotProject-2.2.0\modules\tasks\tasks.php:316 db_exec('SELECT distinct tsk.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 fi.file_task) as file_count, if (tlog.task_log_problem IS NULL, 0, tlog.task_log_problem) AS task_log_problem FROM (dotp_user_tasks as ut3, dotp_tasks as tsk) LEFT JOIN dotp_projects as prj ON project_id = task_project LEFT JOIN dotp_users as usernames ON task_owner = usernames.user_id LEFT JOIN dotp_user_tasks as ut ON ut.task_id = tsk.task_id LEFT JOIN dotp_users as assignees ON assignees.user_id = ut.user_id LEFT JOIN dotp_contacts as co ON co.contact_id = usernames.user_contact LEFT JOIN dotp_task_log AS tlog ON tlog.task_log_task = tsk.task_id AND tlog.task_log_problem > 0 LEFT JOIN dotp_files as fi on tsk.task_id = fi.file_task LEFT JOIN dotp_user_task_pin as pin ON tsk.task_id = pin.task_id AND pin.user_id = 1 WHERE project_status <> 7 AND task_project = prj.project_id AND ut3.user_id = 1 AND ut3.task_id = tsk.task_id AND (task_percent_complete < 100 OR task_end_date = '') AND prj.project_status <> 7 AND prj.project_status <> 4 AND prj.project_status <> 5 AND task_status = 0 GROUP BY tsk.task_id ORDER BY project_id, task_start_date')
2 C:\Users\Ken\Desktop\dotProject-2.2.0\modules\tasks\index.php:123 include('C:\Users\Ken\Desktop\dotProject-2.2.0\modules\tasks\tasks.php')
3 C:\Users\Ken\Desktop\dotProject-2.2.0\index.php:301 require('C:\Users\Ken\Desktop\dotProject-2.2.0\modules\tasks\index.php')

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions