[Vtigercrm-developers] Migration Script

[Alan Lord (News)]

Having found that a certain migration hadn't completed properly I copied 
the code from 600_to_610.php (from a vtiger clean 6.3.0 installation 
package) which hadn't run into a new file and started running it from 
the command line.

I noticed two errors that you probably wan to fix...

On line 976 you have:

> Migration_Index_View::ExecuteQuery($updateQuery,array('Contacted - Unsuccessful' , 'Contacted - Unsuccessful'));

There is a spelling mistake in the database which this should be fixing 
but you have a spelling mistake in your strings. The 2nd 'Contacted - 
Unsuccessful' should read 'Contected - Unsuccessful'. lol

Then more seriously is the following query on line 1020 which won't run:

> $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%'));

MySQL returns:

  #1052 - Column 'task_id' in field list is ambiguous

So you need to re-write this query as:

> $result = $adb->pquery('SELECT com_vtiger_workflowtasks.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%'))


Al

-- 
Libertus Solutions
http://www.libertus.co.uk