# RSS Feed Module Error issued by SQL Error

**URL:** https://community.xibo.org.uk/t/rss-feed-module-error-issued-by-sql-error/31567
**Category:** CMS Features and Functionality
**Created:** [April 18, 2024, 12:10pm UTC](https://community.xibo.org.uk/t/rss-feed-module-error-issued-by-sql-error/31567 "2024-04-18T12:10:36Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![it-supportstkbo](https://community.xibo.org.uk/letter_avatar_proxy/v4/letter/i/76d3ee/32.png) [@it-supportstkbo](https://community.xibo.org.uk/u/it-supportstkbo)
#### Post date: [April 18, 2024, 12:10pm UTC](https://community.xibo.org.uk/t/rss-feed-module-error-issued-by-sql-error/31567/1 "2024-04-18T12:10:36Z")

</div>

To be completed by the original poster:

# CMS Version

4.0.10

# Player Type

Tizen

# Player Version

311/403

# Issue

Hi,  
after upgrading the CMS to 4.0.10 I’m having issues with the RSS Feed. The Module is not loading anymore. I’ve created a blank layout for testing and added different RSS Feed types without any configuration and getting an unexpected error immediately:

 ![image](https://community.xibo.org.uk/uploads/default/original/2X/9/925712d955f0e3091e96596f9816225839442169.png)  
The log is showing a mysql error:

> run: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘originalFileName’ at row 1 Exception Type: PDOException

It seems to be an upgrade error of the fieldtype during the mysql migration from 5.7 to 8. Has anyone similar issues or maybe a workaround/fix for that?

Thanks  
Andreas

---

<div class="post-metadata">

### Author: ![pitoco02](https://community.xibo.org.uk/user_avatar/community.xibo.org.uk/pitoco02/32/15878_2.png) [@pitoco02](https://community.xibo.org.uk/u/pitoco02)
#### Post date: [April 19, 2024, 1:45pm UTC](https://community.xibo.org.uk/t/rss-feed-module-error-issued-by-sql-error/31567/2 "2024-04-19T13:45:28Z")

</div>

> [@it-supportstkbo](#):
>
> run: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘originalFileName’ at row 1 Exception Type: PDOException

This is caused depending on the number of characters that a URL containing the media file coming from an RSS has.  
This happens when the number of characters is greater than 254, as the “media.originalFileName” column only has space for 254 characters in the database.

I was able to fix this error by changing the “originalFileName” column at the “media” table from a `varchar(254)` to` varchar(700)` (or longer/shorter depends on how many characters are coming from your media URL via RSS) using the command bellow:

```auto
ALTER TABLE `media` 
CHANGE COLUMN `originalFilename` `originalFilename` VARCHAR(700) NULL DEFAULT NULL ;

```

Or using the workbench:

 ![image](https://community.xibo.org.uk/uploads/default/original/2X/2/2aadcd6b9fe8bbab48403f12b5dbe086b03e3c12.png)

**Important:**  
I’m just citing what solved my case.  
If you have no experience with databases, be very careful with any changes you make;  
Always make a backup first and remember that you are responsible for any such changes.

---

<div class="post-metadata">

### Author: ![system](https://community.xibo.org.uk/uploads/default/original/2X/a/a8759c2d8cc561474733895ac75beeb830f5d8ca.png) [@system](https://community.xibo.org.uk/u/system)
#### Post date: [July 19, 2024, 7:46pm UTC](https://community.xibo.org.uk/t/rss-feed-module-error-issued-by-sql-error/31567/3 "2024-07-19T19:46:22Z")

</div>

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.