laravel-options icon indicating copy to clipboard operation
laravel-options copied to clipboard

Migrate error on MariaDB

Open animexxx opened this issue 3 years ago • 1 comments

Hi, I have try and it work on local but when i push to live server running MariaDB the migrate error 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) default character set utf8mb4 collate 'utf8mb4_unicode_ci'' at line 1 (SQL: create tableoptions (idbigint unsigned not null auto_increment primary key,keyvarchar(191) not null,value json not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

I think it because MariaDB not support json type. Please advise.

Thank for great tool

animexxx avatar Jan 22 '22 18:01 animexxx

MariaDB supports JSON https://mariadb.com/kb/en/json-data-type/ . If your MariaDB version is from before 2017 you can try to update.

swichers avatar Apr 20 '22 02:04 swichers