/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

2 votes282 views2 answers
Laravel now date
PHP
1 vote300 views1 answer
How to create controler in laravel
PHP
1 vote286 views2 answers
Php remove all whitespace from a string
PHP
6 votes293 views5 answers
Php new object
PHP
0 vote363 views1 answer
Str_replace smarty template
PHP
11 votes315 views4 answers
Laravel 8 password confirmation validation
PHP Laravel
0 vote344 views1 answer
How to disable auto prediction html input in laravel
PHP Laravel
25 votes296 views6 answers
Merge three array in php
PHP
1 vote350 views1 answer
Laravel cashier overwrite users table name
PHP Laravel
1 vote268 views2 answers
Add filter in wordpress
PHP