Last updated January 10, 2011. Created on January 10, 2011.
Edited by mikeryan. Log in to edit this page.

If a column name in the source key passed to the map key appears in more than one table of the source query, you will get an error along the lines of "Integrity constraint violation: 1052 Column 'field' in on clause is ambiguous". The alias for the table containing the column instance you want to use needs to be passed to the map class constructor:

->map = new MigrateSQLMap($this->machineName,
'bid' => array(
'type' => 'int',
'not null' => TRUE,
'alias' => 'b',

Looking for support? Visit the forums, or join #drupal-support in IRC.