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

Asked Jul 29 '18 at 07:18

Active Jul 29 '18 at 07:18

Viewed 60 times

In my users table, I have this column:

$table->string('email', 255)->unique();

However, I am getting this error:

 Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

As per this article, I wrote the following code in AppServiceProvider.php:

use Illuminate\Support\Facades\Schema;

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

However, the issue remains unsolved. Please help!

P.S. I am using Laravel 5.6.*

asked Jul 29 '18 at 07:18

Axel

2,577
8
37
85

What's your MySQL / MariaDB version? – Brian Lee Jul 29 '18 at 07:21
@DigitalDrifter It's `5.7.21` and the PHP version is `7.2.4`! – Axel Jul 29 '18 at 07:22
And the db collation? Is it `utf8mb4` in the config? – Brian Lee Jul 29 '18 at 07:24
You may also try setting the database engine in the config: `'engine' => 'InnoDB ROW_FORMAT=DYNAMIC',` – Brian Lee Jul 29 '18 at 07:25
@DigitalDrifter Where's the config file? – Axel Jul 29 '18 at 07:27
It's in `config/database.php`. – Brian Lee Jul 29 '18 at 07:27
That didn't help! I wrote the code just below `'default' => env('DB_CONNECTION', 'mysql'),`, btw! And while creating db, I didn't select any of the collation. – Axel Jul 29 '18 at 07:29
1

`$table->string('email', 249)->unique();` should work. `defaultStingLength` only works when you actually use the default string length instead of specifying your own – apokryfos Jul 29 '18 at 08:05
after you ad the line in `AppServiceProvider` class, run the following command in your terminal `php artisan config:cache` – Akram Wahid Jul 29 '18 at 08:09
I fixed it! The issue was with the Engine. I changed it to InnoDB. Thanks all of you. – Axel Jul 29 '18 at 09:29

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

0 Answers0