installation problem

[smartjeet]

Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1 (SQL: create table roles (id int unsigned not null auto_increment primary key, name varchar(191) not null, description varchar(191) null, permission_type varchar(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)

[rahul]

Hi @smartjeet

Please refer the following one for your problem - https://forums.bagisto.com/topic/336/installation-has-failed/2

Thanks

[smartjeet]

i am using mysql not maria db...what should i do now??

[smartjeet]

is bagisto not for mysql??

[rahul]

Hi @smartjeet

You can use mysql.

[smartjeet]

but i got "Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1 (SQL: create table roles (id int unsigned not null auto_increment primary key, name varchar(191) not null, description varchar(191) null, permission_type varchar(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)" this problem

[smartjeet]

are vai kuch to bolo

[smartjeet]

i think i should try any another script bcoz bagisto is not installing properly and support is very poor...good bye

[rahul]

Hi @smartjeet

I have provided you proper solution.

You are using MariaDB 10.1 which does not support JSON column so i advice you to upgrade your version to MariaDB 10.2 (Support JSON column and way to upgrade is given link).

Just do it and it will start working.

Thanks
Rahul Shukla

[smartjeet]

i am telling you that i am not using maria db i am using mysql still showing this error "Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1 (SQL: create table roles (id int unsigned not null auto_increment primary key, name varchar(191) not null, description varchar(191) null, permission_type varchar(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)"