• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Register
  • Login
Bagisto Forum

Bagisto

  • Register
  • Login
  • Search
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups

Getting error at the time of database migration

General Discussion
2
2
337
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R
    rima last edited by 5 Mar 2021, 06:36

    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

    1 Reply Last reply Reply Quote 0
    • V
      Vaishali Agarwal last edited by 5 Mar 2021, 09:38

      @rima
      please mention your database server details or version?

      1 Reply Last reply Reply Quote 0
      1 out of 2
      • First post
        1/2
        Last post