[Vtigercrm-developers] 6.0 -> 6.1 migration - com_vtiger_workflows.task_id

[Richard Hills - Technologywise]

I have finally had a chance to debug the 6.0->6.1 migration script and 
have now had my first ever fully successful upgrade (albeit with a 
custom labelpopulator work around provided by another member of this list).

In the migration script I saw:
$result = $adb->pquery('SELECT task_id, module_name FROM 
com_vtiger_workflowtasks
                         INNER JOIN com_vtiger_workflows ON 
com_vtiger_workflows.workflow_id = com_vtiger_workflowtasks.workflow_id
                         WHERE task LIKE ?', array('%VTEmailTask%'));

This query fails on our 5.4 database as taskid table has not been 
specified and task_id exists in both.

Can someone confirm this is an issue for others also, or is my 
com_vtiger_workflows broken / not supposed to have a task_id?

Thanks

-- 
Richard Hills
TechnologyWise Ltd, Tauranga, NZ
richard at tw.co.nz
www.technologywise.co.nz
ph: +64 (0)7 571 1060
fax: +64 (0)7 571 1061