Some time if source table contains bigger ID then migrate class shows this er...

Contribution Date

Tue, 03/24/2015 - 12:00

Technology

Contribution Project

Contribution Details

Some time if source table contains bigger ID then migrate class shows this error.
By making this as float variable or variable that suites source id will resolve this issue.
For ex: I had source id 1178620778846 and was giving errors for interger type.
So previously it was like

$this->map = new MigrateSQLMap(
      $this->machineName,
      array(
      'ID' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'alias' => 'n',
      ),
      ),
      MigrateDestinationNode::getKeySchema()
    );

After i changed as given below and it worked

$this->map = new MigrateSQLMap(
      $this->machineName,
      array(
      'ID' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'alias' => 'n',
        'size' => 'big',
      ),
      ),
      MigrateDestinationNode::getKeySchema()
    );

I have added 'size' => 'big' in mapping array.

Contribution Author

Mohit Aghera

Contribution Issue Link

SQLSTATE[22003]: Numeric value out of range: 1264

Contribution Link

https://www.drupal.org/project/migrate/issues/1410594#comment-9752679

Files count

0

Patches count

0