I had a migration that was working a few months ago on an 8.6 site before the JSON API module was part of core. Nothing has changed on the site I'm migrating to or from, but I'm now getting the following SQL error:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'sourceid1' at row 1: INSERT INTO


I don't have a column sourceid1 and it's not clear what it's doing in Drupal's migration module. Any idea what could be happening here?

For reference, I'm using this article: https://www.lullabot.com/articles/pull-content-from-a-remote-drupal-8-site-using-migrate-and-json-api

  • Source ID refers to the incoming source id in a migration – Kevin Jun 13 at 12:19
  • ...which is missing from the row that's trying to be imported, hence the attempt to insert a blank string into the mapping table. To clarify, sourceid1 is a column in a table that the migrate module creates, it's not a column in your migration data – Clive Jun 13 at 12:39
  • I'm confused. So it's not from my data but from the module and it's missing? How? – crash springfield Jun 13 at 12:47
  • No, the data comes from your migration source. The migration module can't find a value for the column you've set as the identifier, whether thats for one row or multiple it's not possible to say from here, so it can't continue – Clive Jun 13 at 12:49
  • What do you mean by identifier? Identifier of what? I've added the article I've been following for reference. – crash springfield Jun 13 at 12:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.