Edit of a task gives a user warning
TallDavid - August 2, 2007 - 22:53
| Project: | Tasklist |
| Version: | 5.x-1.2 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | by design |
Jump to:
Description
Whenever I click to edit an existing task, I get a warning similar to the one below:
user warning: Unknown column 't.parent' in 'field list' query: SELECT n.nid, n.title, t.parent FROM node n INNER JOIN tasks t ON t.nid = n.nid INNER JOIN tasks_advanced a ON a.nid = n.nid WHERE n.type='tasks' AND t.completed = '0000-00-00' AND a.tasktype = 'project' AND n.nid != 34 ORDER BY IF(t.parent = 0,0,1), n.title ASC in /home/.../public_html/.../includes/database.mysql.inc on line 172.
I'm running Tasklist 5.x-1.2 and Tasklist Advanced 5.x-1.0.
The task can then be edited without problems, but, the warning message is annoying.
How can I correct this issue?
#1
There was a database structure change in the 1.2, therefore make sure you run the update.php from the module page.
#2
Update.php was run when the newer version of the module was installed and has been run multiple times since then as other updated modules were installed.
Any other ideas?
#3
This is due to the Tasklist advanced module which still has the old schema version . Try this patch and let us know if it is working: http://drupal.org/node/147225
#4
Installation of the patch failed on my system. Rather than wasting time troubleshooting why the patch failed, wouldn't it be better to get the fix implemented for download in a development release?
#5
the problem is that tasklist advanced depends on tasklist.
tasklist was fixed recently and its db structure slightly changed, which causes tasklist advanced to break.
I notice you reported this issue in the tasklist advanced issue queue, which is actually the right place to report this.