Getting error at the time of database migration

rima

php artisan migrate

Migrating: 2018_06_13_055341_create_roles_table

In Connection.php line 671:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'json null, created_at timestam
p null, updated_at timestamp null) default cha' at line 1 (SQL: create ta
ble roles (id int unsigned not null auto_increment primary key, name
varchar(191) not null, description varchar(191) null, permission_type v
archar(191) not null, permissions json null, created_at timestamp null,
updated_at timestamp null) default character set utf8mb4 collate 'utf8mb
4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)

In PDOConnection.php line 63:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'json null, created_at timestam
p null, updated_at timestamp null) default cha' at line 1

In PDOConnection.php line 61:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'json null, created_at timestam
p null, updated_at timestamp null) default cha' at line 1

Vaishali Agarwal

@rima
please mention your database server details or version?