PHPCI icon indicating copy to clipboard operation
PHPCI copied to clipboard

Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'message' at row 1

Open timhovius opened this issue 9 years ago • 2 comments

I get the following error when I build a project

Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'message' at row 1

Expected behaviour

Build a job, but it failed.

Actual behaviour

Get an error

Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'message' at row 1

Environment info

Operating System: ubuntu 16.04 PHP Version: 7.0 MySQL Version: 5.6

timhovius avatar May 18 '16 11:05 timhovius

I got exactly the same error

RUNNING PLUGIN: \PHPCI\Plugin\PhpCodeSniffer Exception: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'message' at row 1

Chouchen avatar Jul 01 '16 20:07 Chouchen

Changing phpci.build_error.message from varchar to textdid it.

ALTER TABLEbuild_errorCHANGEmessage message TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

Chouchen avatar Jul 01 '16 20:07 Chouchen