I am importing over 8k XML files in one directory, but it ends up crashing at XML file #1706 and giving me following error:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'config' at row 1


I went into the MySQL table feeds_importer and altered the config column from TEXT to LONGTEXT, which enabled it to go a bit further and crashes now at XML file #3173.

Comments

lightmed’s picture

lightmed CreditAttribution: lightmed commented

I had same problem. My problem solved when I changed config-column from TEXT to LONGTEXT on feeds_source table.

valderama’s picture

valderama CreditAttribution: valderama commented

There are two related issues on the Feeds issue queue, which propose to change the schema of the table:
http://drupal.org/node/1715124
http://drupal.org/node/1736438

However, as "feed_files_fetched" saves all items which were already imported, it grows endless if you have a periodic import.

What the exact purpose of this information, is there a way to get rid of it? What could be a good way to solve this issue?

Thanks,
Walter