/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

0 vote107 views1 answer
Uncaught TypeError: call_user_func(): Argument #1
PHP
0 vote188 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter
1 vote126 views2 answers
Wp cli command activate plugin
PHP Wordpress
21 votes120 views3 answers
Query sql in php
PHP
0 vote108 views1 answer
On keyup jquery for search php on basis of class name
PHP
0 vote128 views1 answer
Yii2 OAuth2
PHP Yii
5 votes110 views2 answers
Laravel group by with where clause
PHP
2 votes106 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP
1 vote106 views3 answers
Laravel eloquent to array key value
PHP
2 votes112 views1 answer
Php start of day epoch
PHP