Fresh installation on localhost fails : SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘title’ at row 38

Hi,

I am trying to install fresh Xibo but facing some problem. The details of my environment as follow :

  • Xibo 2.0.1
  • Wamp 3.1.7 32bit
  • PHP 7.1.26
  • MySql 5.7.24
  • PHP Myadmin 4.8.4

Error : SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘title’ at row 38

Can anyone help me to solve this issue.

MySQL 5.7 won’t work at the moment - or at least not in its default configuration.

There’s a bug logged, and it should be fixed in 2.0.2.

Or you can apply the bug fixes manually which I did and it worked for fresh installation and migration (with some additional minor changes)