Multiple text elements fails to save

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.


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

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