I'm getting the following error:
Migration failed with source plugin exception Migration failed with source plugin exception: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'posmsoftllc' for column 'sourceid1' at row 1
I can't figure out why I'm getting this error.
It has something to do with my MigrateSQLMap - there's no real primary key on the source database, but I suppose username would probably work. I've got the MigrateSQLMap setup as follows:
$this->map = new MigrateSQLMap($this->machineName, array( 'Username' => array('type' => 'varchar', 'length' => 75, 'unsigned' => FALSE, 'not null' => FALSE, ) ), MigrateDestinationEntityAPI::getKeySchema('commerce_line_item', 'recurring') );
But I'm receiving this error - what could be causing this? Why is it expecting an integer value? Do I even need this map for a successful migration?