Debug School

rakesh kumar
rakesh kumar

Posted on

Laravel: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

laravel-migration-error-syntax-error-or-access-violation

 Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access
 violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: a
lter table `users` add unique `users_email_unique`(`email`))
Enter fullscreen mode Exit fullscreen mode

Solution

use Illuminate\Support\Facades\Schema;

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191);
}
Enter fullscreen mode Exit fullscreen mode

======================OR====================================
<?php

namespace App\Providers;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
/**
* Register any application services.
*
* @return void
*/
public function register()
{
//
}

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Schema::defaultStringLength(191); //
}
Enter fullscreen mode Exit fullscreen mode

}

then
Step 2

Rakesh@DESKTOP-JA2LATG MINGW64 /c/xampp/htdocs/vuejs
$ php artisan migrate:fresh
Dropped all tables successfully.
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.03 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.02 seconds)
Migrating: 2023_01_07_102728_create_students_table
Migrated:  2023_01_07_102728_create_students_table (0.01 seconds)
Enter fullscreen mode Exit fullscreen mode

Oldest comments (0)