Postingan lainnya
migrasi laravel
ini error nya kenapa yah ? padahal saya hanya mencoba migrasi dari laravel dan file migrations nya masih bawaan dari laravel 5.5
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`))
0
3 Jawaban:
Jawaban Terpilih
di AppServiceProvider.php
tambahin ini :
use Illuminate\Support\Facades\Schema;
function boot()
{
Schema::defaultStringLength(191);
}
1
<?php
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()
{
//
}
}
jadi seperti itu gan ?
0