installation problem



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



  • Hi @smartjeet

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

    Thanks



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



  • is bagisto not for mysql??



  • Hi @smartjeet

    You can use mysql.



  • 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



  • are vai kuch to bolo



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



  • 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



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


Log in to reply