One of these issues you might stumble across using the PHP framework Laravel is this one: Specified key was too long; max key length is 767 bytes After some research, I've found out it's coming up when using older versions of MySQL (prior to 5.7.8) or MariaDB (prior to 10.2.2). It was MariaDB in my case. Solution #1: In Laravel this can be resolved simply by changing your app service provider configuration (in app/Providers/AppServiceProvider.php) with the following: \ \ \ ; { Schema::defaultStringLength( );
} use Illuminate Support Facades Schema public function boot () /**
     * Ensure we aren't running into `Specified key was too long; max key length is 767 bytes`
     *
     * https://peterthaleikis.com/posts/laravel:-specified-key-was-too-long-max-key-length-is-767-bytes/
     **/ @see 191 After this you might need to rebuild your database using php artisan migrate:fresh --seed - this will completely reset your database and start off fresh. Solution #2: You can also upgrade your database server. This hasn't been discussed here as it is very system specific. DuckDuckGo is your friend 💪️ Previously published on https://peterthaleikis.com/posts/laravel:-specified-key-was-too-long-max-key-length-is-767-bytes/ .

"Specified key was too long; max key length is 767 bytes" Error in Laravel

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

3 Life Savers During Covid Lockdown

10 Cool CI/CD Tools For Your Project

27 Stories To Learn About Ssl

20 Essential Backend Tools For Developers

3 Most Common Ways to Connect your Node and React Applications

369 Stories To Learn About Database

3 Life Savers During Covid Lockdown

10 Cool CI/CD Tools For Your Project

27 Stories To Learn About Ssl

20 Essential Backend Tools For Developers

3 Most Common Ways to Connect your Node and React Applications

369 Stories To Learn About Database

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps