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?

Comments

scor’s picture

scor commented

There was a database structure change in the 1.2, therefore make sure you run the update.php from the module page.

It is important that update.php is run every time a module is updated to a newer version.

TallDavid’s picture

TallDavid commented

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?

scor’s picture

scor commented

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

TallDavid’s picture

TallDavid commented

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?

scor’s picture

scor commented
Status: Active » Closed (works as designed)

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.