PHPCI icon indicating copy to clipboard operation
PHPCI copied to clipboard

[PDOException] while installing or updating PHPCI via ./console script

Open onahkenneth opened this issue 9 years ago • 3 comments

SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'log' can't have a default value.

Server Details MySQL 5.6.28 PHP 5.5.31 Apache 2.2

onahkenneth avatar Jan 25 '16 02:01 onahkenneth

I'm experiencing the same thing.

MySQL: 5.7.10 PHP: 7.0.0 Nginx: 1.9.10

mfairch avatar Feb 01 '16 14:02 mfairch

Same here. Running PHPCI 1.6.0 on MySQL 5.5.4.7, PHP 5.5.9, Lighttpd 1.4.33.

SilverPreece avatar Mar 29 '16 05:03 SilverPreece

The two migration file edits in #1042 fixed the problem for me. You need to remove the two attempts to set a default value for the "log" column. (Remember to edit both files.) After that, re-run ./console phpci:update to run the migration files that previously crapped out. With those missing migrations in place PHPCI is running fine. The migration files should be fixed in the next release.

SilverPreece avatar Mar 29 '16 06:03 SilverPreece