/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 vote296 views1 answer
Db raw update laravel
PHP
0 vote303 views1 answer
Filtering Eloquent collection data with filter
PHP
12 votes336 views6 answers
Laravel validate date
PHP Laravel
7 votes312 views2 answers
Laravel 8 query builder, Inner Join Clause
PHP
0 vote346 views1 answer
How to Create a Transient PHP wordpress
PHP
0 vote328 views1 answer
Retrievemultipleimage from database in laravel
PHP Laravel
3 votes294 views3 answers
Php randon integer 4 digit
PHP
1 vote319 views1 answer
Php time ago
PHP
7 votes351 views5 answers
Laravel remove public from url
PHP Laravel
0 vote320 views3 answers
Leap year formula
PHP