Laravel migration: unique key is too long, even if specified

by

Specify a smaller length for your e-mail:

$table->string('email', 250);

Which is the default, actually:

$table->string('email');

And you should be good.

For Laravel 5.4 you can find a solution in this Laravel 5.4: Specified key was too long error, Laravel News post:

As outlined in the Migrations guide to fix this all you have to do is edit your AppServiceProvider.php file and inside the boot method set a default string length:

use Illuminate\Database\Schema\Builder;


public function boot()
{
    Builder::defaultStringLength(191);
}

More Related Contents:

  1. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  2. Laravel one to many relation with a one to one relation
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. How to do this in Laravel, subquery where in
  5. Laravel 5 PDOException Could Not Find Driver
  6. How to join three table by laravel eloquent model
  7. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  8. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  9. Laravel 5.4 field doesn’t have a default value
  10. “No such file or directory” or “No such host is known” when running migrations
  11. Laravel $q->where() between dates
  12. belongsToMany relationship in Laravel across multiple databases
  13. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  14. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  15. Laravel nested relationships
  16. getting the value of an extra pivot table column laravel
  17. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  18. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  19. Base table or view not found: 1146 Table Laravel 5
  20. How do I get database column names in Laravel?
  21. Laravel SQLSTATE[HY000] [2002] Connection refused
  22. Eloquent many-to-many-to-many – how to load distant relation easily
  23. How can I do a migration in laravel 5.5?
  24. Mysql InnoDB engine in Laravel
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. Can one modify the templates created by artisan migrate command?
  27. How to create a database-driven multi-level navigation menu using Laravel
  28. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment