/PHP/SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}

Source: laravel-news.com

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_uniq

Update your /app/Providers/AppServiceProvider.phpuse Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}

Source: laravel-news.com

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}

Source: stackoverflow.com

Schema error laravel

use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}

Similar codes

1 vote165 views1 answer
Php get current datetime mysql format
PHP
6 votes152 views2 answers
WhereHas site:https://laravel.com/docs/
PHP
4 votes173 views4 answers
Remove last comma from string php
PHP
0 vote176 views1 answer
How push to array whit key in laravel
PHP Laravel
1 vote209 views4 answers
Codeigniter where_not_in
PHP CodeIgniter
1 vote197 views1 answer
Xdebug won't step over in phpstorm
PHP
8 votes163 views2 answers
Php string search in array
PHP
0 vote183 views1 answer
Hook into admin add order item / product on add/submit
PHP
6 votes205 views3 answers
Previous url laravel
PHP Laravel
4 votes197 views6 answers
Laravel custom pagination
PHP