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

Since I was not getting much help from the community I decided to dig into this error a bit more in a hope it will isolate the issue. So I started with a fresh PHP installation and found in code in the “migration.php” file that created the tables that were causing me errors.

->addColumn(‘title’, ‘string’, [‘limit’ => 50])

Changed this to read

->addColumn(‘title’, ‘string’, [‘limit’ => 255])

and

->addColumn(‘installName’, ‘string’, [‘limit’ => 254])

Change it to read

->addColumn(‘installName’, ‘string’, [‘limit’ => 254, ‘default’ => null, ‘null’ => true])

This actually solved the error messages I was getting and completed the installation. However, I am now get a message when its at the login:

Unexpected Error, please contact support.

I am hoping this might help point to the source that folks are having with SQL.

Andre