"Data too long for column 'event' at row 7" error in RSS feed plugin

💻 Development
1

I noticed that the RSS plugin was not picking up a new item. After some investigation I found that my item generated the following error:

Data too long for column 'event' at row 7

When I changed the column type of ‘value’ in ‘RssFeedPlugin_item_data’ table to ‘LONGTEXT’ instead of ‘TEXT’ it seemed to have fixed the problem.

Fyi, this was the feed generating the problem.

Maybe this column should be LONGTEXT by default?

2

@hansdezwart Probably MEDIUMTEXT with maximum length 16MB should be sufficient. But your report has shown that the error handling could be better, so that only the one long item failed rather than the whole feed so I will look into improving that.