Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes - Code Kayak

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

By admin | November 20, 2017 | No Comments | Laravel

When you run the migration command in Laravel you will get the following error

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

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

Reason for the error
Laravel 5.4 has done changes for the default charset of the database. It is now utf8mb4

How to fix this error
1 Upgrate your MySql Database to v5.7.7 and higher

2 You can edit the AppServiceProvider.php file which is located app>Providers location



		
		
			namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
         Schema::defaultStringLength(191);
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
				
						namespace App\Providers;
 
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
         Schema::defaultStringLength(191);
    }
 
    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}



		
		
	
		Post navigation
		← Complete Guide for Laravel Authentication
Laravel Authorization by Example  →


					

					
					

						

	Vue Mastery Course
			





		
			 



		
Laravel

Get next id in auto generated field in Laravel
Redirect to specified route after logout – Laravel
Laravel Gate::define easy code
Fetch select fields on a hasMany relation
Set Selected on Select Form Control in Laravel
Laravel- Call function of a Model in a blade file
Laravel  like in Eloquent
Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource
Laravel Lifecycle Overview
Laravel 5 – Remove public from URL
How to get raw Exception Message in Laravel?
Laravel Test Driven Development
Laravel Api Request validation
Vee Validate show errors by REST API server messages Laravel + Vue.js
How to create model with resource-full controller
Laravel Model Observer
JSON request to Laravel RESTFull API end point
Beginning JWT in Laravel
Laravel and Vue.JS Installation
Laravel get records with Order BY
Laravel Resource Controller
Laravel RESTful API Development
Laravel API Resource for API end point
Pass variable to Mail::send() function in Laravel
Response to preflightLaravel – request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’
Laravel with Vue.js
How to pass data to view in Laravel
How to make HTTP client get request with Guzzle in Laravel
Download file from storage in Laravel
The page has expired due to inactivity.  Please refresh and try again. In Laravel
How to upload file in Laravel
Simple REST API with Laravel
How to make two-factor authentication in Laravel
How to add custom fields to registration form in Laravel
Sending SMS with Nexmo in Laravel
Stripe Payment Integration with Laravel
Middleware in Laravel
Creating Model
Testing Laravel Passport OAuth2 page does not work: Authentication Required
API Authentication using Laravel Passport – Complete Guide 2020
Socialite authentication in Laravel
Email configuration with Laravel
Multiple Authentication Example in Laravel 5
Argument 2 passed to App\Providers\AuthServiceProvider::App\Providers\{closure}() must be an instance of App\Post
Laravel Authorization by Example
Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Complete Guide for Laravel Authentication
Creating View in Laravel
Create Your First Controller in Laravel
Laravel Installation
Frontend Development
Redux
Vue.js
React
Angular
Javascript

		

	
		
			
				

											
							Backend
Laravel
Ruby on Rails
Visual Basic .NET
WordPress
						
										

											
							Learn Java
Spring Boot
Spring Framework
EJB
Struts 2
						
										

											
							Mobile App Development
Swift Language
						
										


											
							Backend Development
Redux
Vue.js
React
Angular
Javascript
						
										

				

			
		

	
		
		
		
			
			
			
			

				

					ShopIsle powered by WordPress