Recent Topics

Getting error at the time of database migration



  • php artisan migrate

    Migrating: 2018_06_13_055341_create_roles_table

    In Connection.php line 671:

    SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
    n your SQL syntax; check the manual that corresponds to your MariaDB server
    version for the right syntax to use near 'json null, created_at timestam
    p null, updated_at timestamp null) default cha' at line 1 (SQL: create ta
    ble roles (id int unsigned not null auto_increment primary key, name
    varchar(191) not null, description varchar(191) null, permission_type v
    archar(191) not null, permissions json null, created_at timestamp null,
    updated_at timestamp null) default character set utf8mb4 collate 'utf8mb
    4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)

    In PDOConnection.php line 63:

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

    In PDOConnection.php line 61:

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



  • @rima
    please mention your database server details or version?


Log in to reply