Can't create user about platform HOT 10 CLOSED

JSON format support MariaDB 10.2

from platform.

But he also clearly says that not all migrations have passed.
I need some time to reproduce the problem on MariaDB

from platform.

Hi, can you say more information
What software do you use? And what version? (PHP, Laravel, MySQL or PostgreSQL)

from platform.

Yes, Laravel 5.4 (last version, fresh installation), PHP 7.1.2, MariaDB 10.1.21

from platform.

Ok, so you have json in migrations.

Thanks, I try upgrading MariaDB 👍

from platform.

Ok, sorry, but still can't because migrations of Orchid doesn't migrate (the user schema that I can see in my database is the user from Laravel fresh installation).

So the make:admin command return the query exception

from platform.

You made
php artisan vendor:publish &
php artisan migrate ?
At these stages there were no problems?

from platform.

Yes, I change the query exception for make:admin command and this is the result:

https://gist.github.com/d8vjork/71264a2f0b909ac17c16ec0379662602

The solution: I change the json/jsonb to text from some migration files and run php artisan migrate (and yes, I upgrade MariaDB to 10.2 but it continues having problems with JSON from Laravel).

Edit: And having no issues from Roles editor, maybe I recommend change JSON/JSONB to TEXT datatype for MySQL/MariaDB compatibility.

from platform.

I was able to reproduce the problem and get an error.
But, as it turned out the JSON type is still not supported in MariaDB.

  [Illuminate\Database\QueryException]                                                                                                                                                                                                                              
  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` timest  
  amp null) default' at line 1 (SQL: create table `roles` (`id` int unsigned not null auto_increment primary key, `slug` varchar(255) not null, `name` varchar(255) not null, `permissions` json not null, `created_at` timestamp null, `updated_at` timestamp nul  
  l) default character set utf8 collate utf8_unicode_ci)                                                                                                                                                                                                            

Link 1
Link 2
Link 3

I can not change the values from json to text or blob, since I suppose to use select and updates in the json

from platform.

So, this only support MariaDB 10.3 (alpha) / MySQL 5.7 and future versions of both.

from platform.