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

by

According to the official Laravel 7.x documentation, you can solve this quite easily.

Update your /app/Providers/AppServiceProvider.php to contain:

use Illuminate\Support\Facades\Schema;

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

Alternatively, you may enable the innodb_large_prefix option for your database. Refer to your database’s documentation for instructions on how to properly enable this option.

More Related Contents:

  1. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  2. convert mysql query to laravel query builder
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. Laravel 5 PDOException Could Not Find Driver
  5. MySQL versus PDO [duplicate]
  6. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  7. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  8. MySQL remote connection fails with “unknown authentication method”
  9. Laravel 5.4 field doesn’t have a default value
  10. Is there a way to “limit” the result with ELOQUENT ORM of Laravel?
  11. How can I implement single table inheritance using Laravel’s Eloquent?
  12. Laravel 5.4 – Validation with Regex [duplicate]
  13. Laravel join with 3 Tables
  14. Laravel 5.4^ – How to customize notification email layout?
  15. Laravel Eloquent group by most recent record
  16. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  17. 404 Not Found, but route exist in Laravel 5.4
  18. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  19. Including a css file in a blade template?
  20. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  21. How to fix MySql: index column size too large (Laravel migrate)
  22. “General error: 1005 Can’t create table” Using Laravel Schema Build and Foreign Keys
  23. Laravel Eloquent Ignore Casing
  24. PHP Laravel: No connection could be made because the target machine actively refused it
  25. Creating MYSQL Procedure in Laravel 4 Migrations
  26. MySQL and PDO: Could PDO::lastInsertId theoretically fail?
  27. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  28. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance
  29. find in set in laravel ? example
  30. Update row with data from another row in the same table

Leave a Comment