SQLSTATE[22001]: while importing products

Please check if your CSV is correct, this looks like some quote issue, or you misconfigured the separator (which can be either ',' or ';')

Please attach your CSV file and importer config.

I got this same error importing from an XML file. The field in question looked like this:

<published>Yes</published>

The DB field it is going into is VARCHAR(5). I had run this import successfully *many* times, but had to delete and recreate the import definition due to another issue. That's when this error came up.

When I recreated the import definition, I used the same name, thinking that all traces of the original definition must have been deleted. That must not be the case, though, because I then deleted the import again and created it with a different machine name. The error went away.

I did not modify my XML file at all during this process, so that seems to indicate an actual bug in feeds import, not a problem with the data being imported.

Also, when removing mappings and/or deleting an import definition entirely, ALL traces of the item(s) being deleted should be removed. I've noticed that, even just deleting a single mapping and adding it (or another mapping) back, it keeps the old info when I go to the parser settings.

have the same problem with feeds