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:
- Schema::defaultStringLength(191);
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
Blade Templating System
Controllers
Laravel Database Stuff
Eloquent
Routes and Routing
General Laravel Stuff
Laravel Collections
Or see other languages/frameworks:
PHP Laravel Composer Apache CentOS and Linux Stuff WordPress General Webdev and Programming Stuff JavaScriptOr see random questions
How to hide directory listing in .htaccess?
How to block IPv6 IP addresses in .htaccess
How to make Apache force download of files (in .htaccess)
How to block an IP range based on CIDR in Apache with .htaccess
How to pick what array_intersect function to use in PHP?
How to add the CSRF (Cross-site request forgery) token in Laravel?
How to group a SQL statement in brackets/parenthesis
How to destroy or remove a cookie in PHP
How to use subdomains as parameters in your routes (or in your web.php file)
What is Bubble sort, and how to write an implementation of it in PHP