Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PHP

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_uniq

Update your /app/Providers/AppServiceProvider.php

use IlluminateSupportFacadesSchema;

public function boot()
{
    Schema::defaultStringLength(191);
}
 
PREVIOUS NEXT
Tagged: #Syntax #error #access #Specified #key #max #key #length #bytes #alter #table #add #unique
ADD COMMENT
Topic
Name
1+4 =