You may encounter an error if you are using older version of MySQL or MariaDB because the older version doesn't support JSON data type. 


SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json not null, `created_at` timestamp null, `updated_at` timestamp null, `delete' at line 1 (SQL: create table `templates` (`id` bigint unsigned not null auto_increment primary key, `author_id` bigint unsigned not null, `visibility` enum('public', 'private') not null, `status` tinyint null default '0', `type` varchar(20) not null, `title` varchar(150) not null, `description` varchar(500) null, `cover` varchar(191) null, `template` json not null, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC)

OR

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 not null, `created_at` timestamp null, `updated_at` times

In MariaDB the JSON column support was added in v10.2 and MySQL v5.7. The fix is easy you just need to upgrade your (MariaDB or MySQL) version to minimum required version and you will be able to run the installer without any issues.


Requirement

MySQL: 5.7x

MariaDB: 10.2.x