Bagisto installation error on a remote server

pulkitvij

I am new to bagisto. I am not able to install bagisto.
first I ran the command

1.composer create-project bagisto/bagisto
2. then I setted up the .env file
3. But when i run php artisan migrate

it migrates 5 tables only
(admin,admin_password_reset, migrations, password resets, Users)
and shows up this error
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MySQL server v
ersion for the right syntax to use near 'json null, created_at timestamp
null, updated_at timestamp null) default cha' at line 1 (SQL: create tabl
e roles (id int unsigned not null auto_increment primary key, name va
rchar(191) not null, description varchar(191) null, permission_type var
char(191) not null, permissions json null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_
unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)

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

i have been trying hard to fix it up by upgrading mysql
but not able to solve. I using Database client version: libmysql - 5.1.73

Please help.

Thanks

rahul

Hi @pulkitvij

Kindly update your database version which supports JSON column type.