Also under Layouts, we’ve spotted that a new layout that has more than 26 individual text elements will fail to save and in the logs we’ll see an error of:
SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘objectAfter’ at row 1
reducing it to 26 or fewer text elements saves without any problems. Adding other element types (on top of the 26 text elements) doesn’t cause any problems (though I haven’t tried excessive amounts).
To replicate:
- Create a new layout
- Add 26 text elements (leaving them as “text” is fine)
- Logs should be clean (assuming an otherwise working Xibo install)
- Add 27th text element
- 27th text element won’t save correctly and you’ll see the above in the logs.
Environment:
- Xibo 4.0.6 (clean install today)
- Ubuntu 22.04
- MySQL 8.0.35-0ubuntu0.22.04.1
- PHP 8.1.2-1ubuntu2.14
I’m not a frequent herder of systems running Xibo, so I’m not sure if this is a known issue or a newly introduced one.