You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ptd_from_uid is NULL AND ptd_status_cat_val IN('1','Cancelled') ORDER BY e' at line 1
SELECT tbl.ptd_id AS "id", tbl.ptd_project_id AS "project_id", tbl.ptd_milestone_id AS "milestone_id", tbl.ptd_todo_id AS "todo_id", tbl.ptd_name AS "name", tbl.ptd_description AS "description", tbl.ptd_task_cat_val AS "task_cat_val", tbl.ptd_location AS "location", tbl.ptd_billable_cat_val AS "billable_cat_val", tbl.ptd_transportation_cat_val AS "transportation_cat_val", tbl.ptd_startdate AS "startdate", tbl.ptd_enddate AS "enddate", tbl.ptd_owner_uid AS "owner_uid", tbl.ptd_owner_gid AS "owner_gid", tbl.ptd_from_uid AS "from_uid", tbl.ptd_status_cat_val AS "status_cat_val", tbl.ptd_priority_cat_val AS "priority_cat_val", tbl.ptd_permission AS "permission", tbl.ptd_pending_status AS "pending_status", tbl.ptd_ipath AS "ipath", tbl.ptd_obj_status AS "obj_status", tbl.ptd_cr_date AS "cr_date", tbl.ptd_cr_uid AS "cr_uid", tbl.ptd_lu_date AS "lu_date", tbl.ptd_lu_uid AS "lu_uid" , a.pn_uname AS cr_name , b.pn_uname AS lu_name , c.pn_uname AS from_name , d.pn_name AS owner_group_name , e.pn_uname AS owner_name , f.ppr_name AS project_name , g.pmi_name AS milestone_name FROM os_core_v4b_projects_todo AS tbl LEFT JOIN os_core_users a ON a.pn_uid = tbl.ptd_cr_uid LEFT JOIN os_core_users b ON b.pn_uid = tbl.ptd_lu_uid LEFT JOIN os_core_users c ON c.pn_uid = tbl.ptd_from_uid LEFT JOIN os_core_groups d ON d.pn_gid = tbl.ptd_owner_gid LEFT JOIN os_core_users e ON e.pn_uid = tbl.ptd_owner_uid LEFT JOIN os_core_v4b_projects_project f ON f.ppr_id = tbl.ptd_project_id LEFT JOIN os_core_v4b_projects_milestone g ON g.pmi_id = tbl.ptd_milestone_id WHERE ptd_owner_uid= AND ptd_from_uid is NULL AND ptd_status_cat_val IN('1','Cancelled') ORDER BY enddate, name, priority_cat_val, status_cat_val
  1. (array) 0:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/DBUtil.class.php
    2. (integer) line = 75
    3. (string) function = v4b_exit
    4. (array) args:
      1. (string) 0 = Exiting after SQL-error
  2. (array) 1:
    1. (string) file = /home5/thailan8/public_html/includes/v4blib/DBUtil.class.php
    2. (integer) line = 1112
    3. (string) function = executeSQL
    4. (string) class = DBUtil
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = SELECT tbl.ptd_id AS "id", tbl.ptd_project_id AS "project_id", tbl.ptd_milestone_id AS "milestone_id", tbl.ptd_todo_id AS "todo_id", tbl.ptd_name AS "name", tbl.ptd_description AS "description", tbl.ptd_task_cat_val AS "task_cat_val", tbl.ptd_location AS "location", tbl.ptd_billable_cat_val AS "billable_cat_val", tbl.ptd_transportation_cat_val AS "transportation_cat_val", tbl.ptd_startdate AS "startdate", tbl.ptd_enddate AS "enddate", tbl.ptd_owner_uid AS "owner_uid", tbl.ptd_owner_gid AS "owner_gid", tbl.ptd_from_uid AS "from_uid", tbl.ptd_status_cat_val AS "status_cat_val", tbl.ptd_priority_cat_val AS "priority_cat_val", tbl.ptd_permission AS "permission", tbl.ptd_pending_status AS "pending_status", tbl.ptd_ipath AS "ipath", tbl.ptd_obj_status AS "obj_status", tbl.ptd_cr_date AS "cr_date", tbl.ptd_cr_uid AS "cr_uid", tbl.ptd_lu_date AS "lu_date", tbl.ptd_lu_uid AS "lu_uid" , a.pn_uname AS cr_name , b.pn_uname AS lu_name , c.pn_uname AS from_name , d.pn_name AS owner_group_name , e.pn_uname AS owner_name , f.ppr_name AS project_name , g.pmi_name AS milestone_name FROM os_core_v4b_projects_todo AS tbl LEFT JOIN os_core_users a ON a.pn_uid = tbl.ptd_cr_uid LEFT JOIN os_core_users b ON b.pn_uid = tbl.ptd_lu_uid LEFT JOIN os_core_users c ON c.pn_uid = tbl.ptd_from_uid LEFT JOIN os_core_groups d ON d.pn_gid = tbl.ptd_owner_gid LEFT JOIN os_core_users e ON e.pn_uid = tbl.ptd_owner_uid LEFT JOIN os_core_v4b_projects_project f ON f.ppr_id = tbl.ptd_project_id LEFT JOIN os_core_v4b_projects_milestone g ON g.pmi_id = tbl.ptd_milestone_id WHERE ptd_owner_uid= AND ptd_from_uid is NULL AND ptd_status_cat_val IN('1','Cancelled') ORDER BY enddate, name, priority_cat_val, status_cat_val
  3. (array) 2:
    1. (string) file = /home5/thailan8/public_html/modules/v4bProjects/classes/TodoUtil.class.php
    2. (integer) line = 236
    3. (string) function = selectExpandedObjectArray
    4. (string) class = DBUtil
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (string) 0 = v4b_projects_todo
      2. (array) 1:
        1. (array) 0:
          1. (string) join_table = users
          2. (string) join_field = uname
          3. (string) object_field_name = cr_name
          4. (string) compare_field_table = cr_uid
          5. (string) compare_field_join = uid
        2. (array) 1:
          1. (string) join_table = users
          2. (string) join_field = uname
          3. (string) object_field_name = lu_name
          4. (string) compare_field_table = lu_uid
          5. (string) compare_field_join = uid
        3. (array) 2:
          1. (string) join_table = users
          2. (string) join_field = uname
          3. (string) object_field_name = from_name
          4. (string) compare_field_table = from_uid
          5. (string) compare_field_join = uid
        4. (array) 3:
          1. (string) join_table = groups
          2. (string) join_field = name
          3. (string) object_field_name = owner_group_name
          4. (string) compare_field_table = owner_gid
          5. (string) compare_field_join = gid
        5. (array) 4:
          1. (string) join_table = users
          2. (string) join_field = uname
          3. (string) object_field_name = owner_name
          4. (string) compare_field_table = owner_uid
          5. (string) compare_field_join = uid
        6. (array) 5:
          1. (string) join_table = v4b_projects_project
          2. (string) join_field = name
          3. (string) object_field_name = project_name
          4. (string) compare_field_table = project_id
          5. (string) compare_field_join = id
        7. (array) 6:
          1. (string) join_table = v4b_projects_milestone
          2. (string) join_field = name
          3. (string) object_field_name = milestone_name
          4. (string) compare_field_table = milestone_id
          5. (string) compare_field_join = id
      3. (string) 2 = WHERE ptd_owner_uid= AND ptd_from_uid is NULL AND ptd_status_cat_val IN('1','Cancelled')
      4. (string) 3 = ORDER BY enddate, name, priority_cat_val, status_cat_val
      5. (integer) 4 = -1
      6. (integer) 5 = -2
  4. (array) 3:
    1. (string) file = /home5/thailan8/public_html/modules/v4bProjects/classes/V4BTodoArray.class.php
    2. (integer) line = 79
    3. (string) function = getTodosUser
    4. (string) class = TodoUtil
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (array) 0:
        1. (boolean) uid =
      2. (string) 1 = A
      3. (string) 2 = enddate
      4. (array) 3:
        1. (boolean) uid =
  5. (array) 4:
    1. (string) file = /home5/thailan8/public_html/modules/v4bProjects/pnuser.php
    2. (integer) line = 115
    3. (string) function = getViewData
    4. (string) class = V4BTodoArray
    5. (object) object:
    6. (string) type = ->
    7. (array) args:
      1. (array) 0:
        1. (NULL) uid = (none)
      2. (string) 1 = A
      3. (string) 2 = user
      4. (string) 3 = enddate
  6. (array) 5:
    1. (string) file = /home5/thailan8/public_html/includes/pnMod.php
    2. (integer) line = 735
    3. (string) function = v4bProjects_user_view
    4. (array) args:
      1. (array) 0: (empty)
  7. (array) 6:
    1. (string) file = /home5/thailan8/public_html/index.php
    2. (integer) line = 141
    3. (string) function = pnModFunc
    4. (array) args:
      1. (string) 0 = v4bProjects
      2. (string) 1 = user
      3. (string) 2 = view
      4. (array) 3: (empty)
Exit-Handler: Exiting after SQL-error