[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 r
ight syntax to use near 'json not null, remember_token varchar(100) null, created_at timestamp null, ’ at line 1 (SQL: create table users (id int unsigned not n
ull auto_increment primary key, name varchar(255) not null, email varchar(255) not null, password varchar(60) not null, avatar varchar(255) not null, confirmat ion_token varchar(255) not null, is_active smallint not null default ‘0’, questions_count int not null default ‘0’, answers_count int not null default ‘0’, comm ents_count int not null default ‘0’, favorites_count int not null default ‘0’, likes_count int not null default ‘0’, followers_count int not null default ‘0’, f ollowings_count int not null default ‘0’, settings json not null, remember_token varchar(100) null, created_at timestamp null, updated_at timestamp null) defau
lt character set utf8 collate utf8_unicode_ci)
[PDOException]
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 r
ight syntax to use near 'json not null, remember_token varchar(100) null, created_at timestamp null, ’ at line 1
This is a similar issue to having old MySQL versions. We made this change in 5.2. Either upgrade to a new version, or, just don’t use the json type in migrations. If you really want to use that in the migration, and want the old database version, you could stay on Laravel 5.1 LTS.
[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))
这个max key 767是个啥,
C:\Program Files (x86)\HashiCorp\Vagrant>vagrant box add laravel/homestead
==> box: Loading metadata for box 'laravel/homestead’
box: URL: https://atlas.hashicorp.com/laravel/homestead
This box can work with multiple providers! The providers that it
can work with are listed below. Please review the list and choose
the provider you will be working with.
vagrant box add laravel/homestead /workspace/virtualBox.box
这条命令输入完,virtualBox这款软件的界面上看不到我导入的这个虚拟机
virtualBox是5.1.18版本,是软件版本太新识别不了还是别的?
cmd 消息
The box you’re attempting to add already exists. Remove it before
adding it again or add it with the --force flag.
SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema
.tables where table_schema = zhihu and table_name = migrations)
[PDOException]
SQLSTATE[HY000] [2002] No such file or directory