Skip to main content

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_unique`(`email`))




When you initally migrate to the database you might get this error:



 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_unique`(`email`))

 So, to solve this error open your AppServiceProvider.php  which is inside App\Provider\AppServiceProvider.

import this at the top:

use Illuminate\Support\Facades\Schema;


and write Schema::defaultStringLength(191); inside the boot function. Like this:


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

 Now, Delete User and migration tables from the database. Otherwise you will see that error again.
Now, run the migration again.

 Thanks!

Comments

Post a Comment

Popular posts from this blog

Laravel Vuejs Basic Setup

In this article we will see how to setup vue with laravel. 1) Create a laravel project: laravel new laravue 2) In web.php create a temporary route:  Route :: get ( '/test' ,  function  () {      return   view ( 'welcome' ); }); So, when you will see the welcome page once you hit the  http://laravue.test/test  url. 2) In terminal run:  npm install 3) npm install vue (In package.json file you will see that vue dependency has been added successfully) 4) Now go to resources -> js -> app.js file. Here we will have to load the vue. write the following lines in app.js.  require ( './bootstrap' ); window . Vue  =  require ( 'vue' ); const   app  =  new   Vue ({      el :   '#app' }); (Here, vue js will execute and control anything that will be inside the app id. So, for our example  let's put the app id inside the welcome view). So, inside welcome.blade.php 's body...
Post a Comment
Read more