Closed (fixed)
Project:
Tasklist Advanced
Version:
5.x-1.0
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
16 Mar 2007 at 10:21 UTC
Updated:
30 Mar 2007 at 18:16 UTC
In .install file there is:
// let's make sure that there's an entry in {tasks_advanced} for each existing entry in {tasks}
// need to make sure all parents are turned into projects
db_query("INSERT INTO {tasks_advanced} (nid, taskcategory, tasktype)
SELECT t.nid, 'unknown', IF(t.nid IN (SELECT parent FROM tasks), 'project', 'action')
FROM {tasks} t
LEFT JOIN {tasks_advanced} a ON t.nid = a.nid
WHERE ISNULL(a.nid)");
there should be:
// let's make sure that there's an entry in {tasks_advanced} for each existing entry in {tasks}
// need to make sure all parents are turned into projects
db_query("INSERT INTO {tasks_advanced} (nid, taskcategory, tasktype)
SELECT t.nid, 'unknown', IF(t.nid IN (SELECT parent FROM {tasks}), 'project', 'action')
FROM {tasks} t
LEFT JOIN {tasks_advanced} a ON t.nid = a.nid
WHERE ISNULL(a.nid)");
Comments
Comment #1
moonray commentedThanks. Fixed in CVS for both Drupal 4.7 and Drupal 5.
Comment #2
(not verified) commented