Tasklist advanced throws errors when viewing the tasks. I have a multidomain setup. This appears on the parent domain:

user warning: Unknown column 't.parent' in 'field list' query: SELECT 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 LEFT JOIN i18n_node i18n ON n.nid = i18n.nid WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( n.status = 1 AND n.type='tasks' AND (t.completed = 0000-00-00) ) ORDER BY u.name, a.task_tree_left ASC in /home/gohelpor/public_html/includes/database.mysql.inc on line 172.

This appears on a secondary domain with the database prefix 'CR':

* user warning: Table 'gohelpor_drupal.tasks' doesn't exist query:
INSERT INTO CR_tasks_advanced (nid, taskcategory, tasktype) SELECT t.nid, 'unknown', IF(t.nid IN (SELECT parent FROM tasks), 'project',
'action') FROM CR_tasks t LEFT JOIN CR_tasks_advanced a ON t.nid = a.nid WHERE ISNULL(a.nid) in /home/gohelpor/public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'parent' in 'where clause' query:
UPDATE CR_tasks_advanced SET tasktype = 'project' WHERE nid = (SELECT nid FROM CR_tasks WHERE parent = 0) in /home/gohelpor/public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'parent' in 'where clause' query:
SELECT nid parent FROM CR_tasks WHERE parent = 0 in /home/gohelpor/public_html/includes/database.mysql.inc on line 172.

Comments

dami’s picture

Status: Active » Closed (duplicate)

This can be fixed by the patch in:
http://drupal.org/node/147225

Setting this to duplicate.