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)"