Tasklist Advanced doesn't properly install when prefixed tables are used.
vito_swat - March 16, 2007 - 10:21
| Project: | Tasklist Advanced |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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)");
#1
Thanks. Fixed in CVS for both Drupal 4.7 and Drupal 5.
#2