How to fix the MySQL related "Specified key was too long error" error in Laravel

Laravel: How to fix the MySQL related "Specified key was too long error" error in Laravel

This is a common problem (especially if you use a local development environment such as XAMPP).

The error will look something like this:

[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

 [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Luckily the fix is simple. Add the following to the boot() method of your app/Providers/AppServiceProvider.php file:

  1. Schema::defaultStringLength(191);

webdevetc profile pic
webdevetc

I am a 29 year old backend web developer from London, mostly focusing on PHP and Laravel lately. This (webdevetc.com) is my blog where I write about some web development topics (PHP, Laravel, Javascript, and some server stuff). contact me here.



More...


Comments and discussion about How to fix the MySQL related "Specified key was too long error" error in Laravel

Found this interesting? Maybe you want to read some more in this series?

Or see other topics in the Laravel language

Or see other languages/frameworks:
PHP Laravel Composer Apache CentOS and Linux Stuff WordPress General Webdev and Programming Stuff JavaScript
Or see random questions

How to add and remove items to an array in JS?

What is the null coalescing operator in PHP7?

How to order a Laravel hasMany relationship?

What is an example of an object literal?

How to replace values in a string, in JS

How to set environmental variables in your .htaccess file

What are some ways you can log debug messages and data in JS?

How to check if a relation was loaded on an Eloquent model already?

How to fix the MySQL related "Specified key was too long error" error in Laravel

What is the difference between empty(), isset(), != null, is_null() in PHP