/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 vote123 views1 answer
Générer des nombres aléatoires décimaux en php
PHP
0 vote114 views1 answer
Php array insert before key
PHP
0 vote153 views3 answers
Laravel sync with attributes
PHP Laravel
0 vote159 views1 answer
Maximum upload file size: 2 MB. how to increase in softaculous
PHP
8 votes123 views6 answers
Define table name in model laravel
PHP Laravel
0 vote127 views2 answers
Delete in wordpress query
PHP
-1 vote140 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP Laravel
2 votes144 views4 answers
Laravel print query with parameters
PHP Laravel
1 vote148 views2 answers
Php date function get previous month
PHP
15 votes117 views4 answers
Convert timestamp to date php
PHP