The tasks module changed a db-field from 'parent' to 'task_parent', thus leading to sql-errors with tasks_advanced:

user warning: Unknown column 't.parent' in 'field list' query: SELECT DISTINCT(n.nid), t.parent, u.name AS assigned_name, t.assigned_to, a.taskcategory, a.tasktype, a.task_tree_left, a.task_tree_right, a.task_tree_depth, u.data FROM node n INNER JOIN tasks t ON t.nid = n.nid INNER JOIN tasks_advanced a ON a.nid = n.nid LEFT JOIN users u ON u.uid = t.assigned_to WHERE n.status = 1 AND n.type='tasks' AND (t.completed = 0000-00-00) ORDER BY u.name, a.task_tree_left ASC in /drupalwebdir/includes/database.mysqli.inc on line 151.

Comments

wikipug’s picture

wikipug commented

I made the following changes as a quick fix which seemed to work okay...

tasks_advanced.install
line 36: change 'select parent' to 'select task_parent as parent'

tasks_advanced.module
line 142: t.parent to parent in the order by clause
lines 142,587,618,651: change 'select parent' to 'select task_parent as parent'

Bit of a cheat but using the alias saved me having to check the code to see where the field is used.

robmorin’s picture

robmorin commented

I do not have any instances of "select parent" in the tasks_advanced.module file???

What version are you using i am using version 5.x

Thanks

Rob...

tom friedhof’s picture

tom friedhof commented
Status: Active » Closed (duplicate)

Already mentioned here: http://drupal.org/node/147225