Recent Topics

Bagisto installation error on a remote server



  • Re: installation problem

    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

    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



  • Hi @pulkitvij

    Kindly update your database version which supports JSON column type.


Log in to reply