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?