I'm trying an D7 2 D7 import on a node with an image attached. As its failing I'm trying to break it down and run the File import separately. It is consistently failing with the following message:

Migration failed with source plugin exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.migrate_map_112a

Before I attempted import I mapped the [filename] field between source and destination and ensured the same field was enabled under Source Fields block. After this error occurs the [filename] Source Field is checked off automatically and removed from the mapping.

Thanks

Laurence

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan commented
Category: Bug report » Support request
Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

Make sure your field mappings are correct. If your file migration is MySiteFile, and your file field in your node is field_file, then for the field_file mapping itself you need to have the Source Migration set to MySiteFile. You also will see a field_file:file_class mapping - the Default Value column for this needs to be set to MigrateFileFid.

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Murphysboro, IL, USA
CreditAttribution: mikeryan commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)