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

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?

@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.

I am unsure whether the whole feed failed; this particular newsletter gets sent out as soon as there is one item in the feed. However, finding the error was hard because the feed did not show it anywhere. I only saw the error when I changed the date on the feed item for phpList to retrieve it again at my manual request.

@hansdezwart When I tested using your feed, the first item was too long and that made the process of fetching the feed items fail. I have changed the code so that only the one item fails and processing will continue with the remaining items.

I think that phplist issued an error message about the data being too long but if you are using a cron job to fetch the feed items then it may well have been lost.

@duncanc Ah, that makes sense. Thanks for the clarification!