/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

3 votes94 views1 answer
Codeigniter form_validation email
PHP
0 vote92 views1 answer
Php best crud generator
PHP
0 vote99 views1 answer
Nested with laravel
PHP
0 vote130 views1 answer
Exclude row from clooection laravel
PHP Laravel
0 vote112 views1 answer
Multe data on database laravel
PHP Laravel
0 vote112 views1 answer
Singular from table laravel
PHP Laravel
1 vote107 views1 answer
Laravel add (s) at the end of text based on how many data
PHP Laravel
2 votes84 views1 answer
Drupal 8 get nodes types
PHP Drupal
0 vote103 views1 answer
Woocommerce php customer reset password length
PHP
2 votes112 views2 answers
Importing current year in laravel blade
PHP Laravel