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

Get Help
1

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.

2

We’re aware of this issue on manual installations with MySQL 5.7 strict mode, it will be resolved in 2.0.2 release - there were several small changes to the installation migration in 2.0.2.

We’re currently aiming to release 2.0.2 next week.

Apologies for the inconvenience.

3

You can get it to run by turning strict mode off for MySQL 5.7.

I would not suggest using Xibo v2.0.1 in a production environment only use for testing.

4

I would also suggest you check out my recent post on issues I had with 2.x.x. I included 2 links that will help solve your issue.

5