One error causes the rest of the Feed import to error out.

[efatsi]

Description

When importing multiple records, if one record fails due to Data too long for column SQL error, all remaining entry import attempts fail for an unrelated reason: `Column not found: 1054 Unknown column 'content.field_copy_legacyId'

Steps to reproduce

I haven't spent the time required to isolate the bug here. But we're using a legacyId field to match existing entries, and that works fine until one record blows up and then the SQL lookup starts trying to find that field where it shouldn't be.

I'm under a tight timeline, so my approach is to manually fix the entries that are overflowing SQL columns, which lets the whole import pass, otherwise I'd dig in to what the issue is and what a fix might look like.

Additional info

• Plugin version: 4.2.3
• Craft version: 3.4.18

[kristiansp]

I'm not sure I understand completely what's the issue here, but can you change the field type to something long enough to hold the values your feed gives you?

I had an issue once where I had a number field where I imported some external IDs into, and at some point it failed because the number got to large. Changing the field to a text field holding the digits fixed the issue, and it matches just as good, even though it's then a string comparison, not a numeric comparison.