/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 vote114 views2 answers
Wordpress single post template
PHP
1 vote103 views3 answers
Php +=
PHP
0 vote125 views2 answers
Laravel login register api
PHP Laravel
0 vote103 views2 answers
Set modes magento 2
PHP
13 votes95 views3 answers
Laravel password encryption
PHP
0 vote148 views2 answers
Sweet alert confirm box laravel
PHP Laravel
9 votes128 views4 answers
Add another field in existing migration laravel
PHP Laravel
7 votes91 views3 answers
Php time script
PHP
0 vote118 views2 answers
Php radians to degrees
PHP
0 vote98 views2 answers
Wc php get shipping methods
PHP