RC2 Migration Fails - JSON column cannot have default value

[vmitchell85]

When attempting to migrate the database I get the following error:

SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'options' can't have a default value (SQL: create table 'abilities' ('id' int unsigned not null auto_increment primary key, 'name' varchar(150) not null, 'title' varchar(255) null, 'entity_id' int unsigned null, 'entity_type' varchar(150) null, 'only_owned' tinyint(1) not null default '0', 'options' json null default '{}', 'scope' int null, 'created_at' timestamp null, 'updated_at' timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

I'm running MySQL 5.7.22 and I found the following in the MySQL documentation:

A JSON column cannot have a default value.

It seems like the fix would be just to remove the default value that is set in the migration.

[looksystems]

Same here.

See also: laravel/framework#16107

[bkuhl]

It also doesn't make sense to define a default and a nullable column.

[JosephSilber]

1. Updated the RC2 release notes.

2. Changed Bouncer's migration file.

3. Tagged a new release.

Thanks for reporting this 👍